| layout | default |
|---|---|
| title | FND User Roles | Oracle EBS SQL Report |
| description | Report for User Management (UMX) roles and their assigned users to manage role-based access control (RBAC). User uoles are maintained from the User… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, FND, User, Roles, wf_local_roles, wf_local_roles_tl, fnd_responsibility_vl |
| permalink | /FND%20User%20Roles/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Report for User Management (UMX) roles and their assigned users to manage role-based access control (RBAC). User uoles are maintained from the User Management responsibility, but you would require the UMX|SECURITY_ADMIN role for this. If you do not have this role but apps DB access, you can add it from the backend:
begin wf_local_synch.propagateuserrole( p_user_name=>'ANDY.HAACK', p_role_name=>'UMX|SECURITY_ADMIN' ); commit; end;
User Name, Role Name, Role Code, Active only
wf_local_roles, wf_local_roles_tl, fnd_responsibility_vl, wf_local_user_roles, wf_user_role_assignments
FND User Roles 11i, FND Roles, OKL Termination Quotes
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | FND User Roles 10-Jan-2021 130904.xlsx |
| Blitz Report™ XML Import | FND_User_Roles.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-user-roles/ |
The FND User Roles report details the assignment of User Management (UMX) roles to users. It is a key component for managing Role-Based Access Control (RBAC) in Oracle EBS, providing visibility into who holds which roles.
As organizations move towards RBAC, access is increasingly granted via Roles rather than direct Responsibility assignments. Managing these role assignments is critical. Administrators need to ensure that users have the correct roles for their job functions and that roles are not over-provisioned.
This report provides a clear mapping between Users and Roles. It helps security teams:
- Review all roles assigned to a specific user.
- See all users assigned to a specific role (e.g., "Who has the Security Admin role?").
- Identify active vs. inactive role assignments.
The report utilizes the Workflow directory service tables (wf_local_roles, wf_user_role_assignments) which underpin the UMX security model.
- User Name: Search for a specific user's roles.
- Role Name / Role Code: Search for all users with a specific role.
- Active only: Filter to show only current assignments.
The report joins user and role tables. In systems with very large numbers of users and complex role hierarchies, filtering by User or Role is recommended.
Q: How is this different from FND User Responsibilities? A: FND User Responsibilities shows the result of access (the responsibilities). FND User Roles shows the mechanism of access (the roles). A single role might grant multiple responsibilities.
Q: Can I use this to add roles? A: This is a reporting tool. However, the description includes a PL/SQL snippet showing how to grant roles via the backend if needed.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics