| layout | default |
|---|---|
| title | FND User Responsibilities | Oracle EBS SQL Report |
| description | Similar to report FND Responsibility Access, but also shows inactive / end dated user responsibilities while FND Access Control shows currently active… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, User, Responsibilities, fnd_user_resp_groups_direct, fnd_user_resp_groups_indirect, fnd_user |
| permalink | /FND%20User%20Responsibilities/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Similar to report FND Responsibility Access, but also shows inactive / end dated user responsibilities while FND Access Control shows currently active assigned responsibilities only. Same as Oracle's 'Active Users' report.
User Name, Responsibility Name, Application, Active only, End Dated from
fnd_user_resp_groups_direct, fnd_user_resp_groups_indirect, fnd_user, fnd_responsibility_vl, fnd_application_vl
FND User Upload, CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC Inventory Pending Cost Adjustment, CAC ICP PII Inventory Pending Cost Adjustment, FND User Roles 11i, FND User Roles, INV Cycle count listing, INV Cycle counts pending approval
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 Responsibilities 30-Sep-2018 174651.xlsx |
| Blitz Report™ XML Import | FND_User_Responsibilities.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-user-responsibilities/ |
The FND User Responsibilities report provides a comprehensive view of responsibility assignments to users. Unlike standard active-only reports, this report can include inactive and end-dated assignments, making it a powerful tool for historical auditing and access troubleshooting.
Standard Oracle forms often hide end-dated records, making it difficult to answer questions like "Did this user have access to the General Ledger last month?" or "When was this user's access revoked?". Auditors often require proof not just of current access, but of the history of access changes.
This report lists user responsibility assignments with their effective start and end dates. It allows administrators to:
- Audit historical access for compliance reviews.
- Verify when a user's access was terminated.
- Compare direct responsibility assignments vs. indirect assignments (inherited via roles).
The report queries fnd_user_resp_groups_direct and fnd_user_resp_groups_indirect to capture all assignment types. It joins with fnd_user and fnd_responsibility_vl for descriptive names.
- User Name: Filter for a specific user.
- Responsibility Name: Filter for a specific responsibility.
- Active only: Toggle to show only currently active assignments or include historical ones.
- End Dated from: Filter to find assignments that expired after a certain date.
The report is efficient. Using the Active only parameter can reduce the dataset size significantly in older systems with many historical records.
Q: What is the difference between direct and indirect responsibility? A: A direct responsibility is assigned explicitly to the user. An indirect responsibility is inherited because the user was assigned a Role (e.g., via User Management) that contains the responsibility.
Q: Does this show which user granted the access?
A: It shows the CREATED_BY and LAST_UPDATED_BY columns, which indicate who performed the assignment (or if it was done by a system process like AUTOINSTALL).
- 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