| layout | default |
|---|---|
| title | FND Responsibility Menu Exclusions | Oracle EBS SQL Report |
| description | Responsibility menu exclusions – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Responsibility, Menu, Exclusions, fnd_application_vl, fnd_responsibility_vl, fnd_resp_functions |
| permalink | /FND%20Responsibility%20Menu%20Exclusions/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Responsibility menu exclusions
Responsibility Name, Excluded User Function Name, Excluded Function Name, Excluded Menu Name
fnd_application_vl, fnd_responsibility_vl, fnd_resp_functions, fnd_form_functions_vl, fnd_menus_vl
FND Responsibility Access 11i, FND Responsibility Access, Blitz Report Assignments and Responsibilities, FND User Login History, FND Menu Entries, FND Forms Personalizations, FND User Login Page Favorites
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 Responsibility Menu Exclusions 23-Jan-2018 063112.xlsx |
| Blitz Report™ XML Import | FND_Responsibility_Menu_Exclusions.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-responsibility-menu-exclusions/ |
The FND Responsibility Menu Exclusions report documents the specific functions and menus that have been explicitly excluded from responsibilities. This is a critical component of security auditing, ensuring that broad responsibilities are properly restricted according to the principle of least privilege.
Organizations often create generic responsibilities (e.g., "Super User") and then restrict them for specific roles by excluding sensitive functions or menus. However, these exclusions are often hidden in sub-tabs of the responsibility definition form. Without a clear report, it is easy to overlook missing exclusions or fail to document how a responsibility differs from its base menu definition, leading to potential security gaps.
This report provides a clear list of all menu and function exclusions defined at the responsibility level. It helps security teams:
- Verify that intended restrictions are actually in place.
- Document the differences between similar responsibilities.
- Troubleshoot why a user cannot access a function they expect to see (if it was inadvertently excluded).
The report queries the fnd_resp_functions table, which stores the exclusion rules, and joins it with fnd_responsibility_vl, fnd_form_functions_vl, and fnd_menus_vl to provide human-readable names for the excluded items.
- Responsibility Name: Filter for a specific responsibility to see its exclusions.
- Excluded Function/Menu Name: Search for a specific function to see which responsibilities have excluded it.
This report queries a specific set of configuration tables and is generally very fast and lightweight.
Q: What is the difference between a menu exclusion and a function exclusion? A: A menu exclusion hides an entire submenu and all its contents. A function exclusion hides a specific action or screen, regardless of where it appears in the menu structure.
Q: Does this report show the final resulting menu? A: No, it only lists the exclusions. To see the full resulting access, use the FND Responsibility Access report.
- 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