FND Responsibility Menu Exclusions – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Responsibility menu exclusions
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Responsibility Name, Excluded User Function Name, Excluded Function Name, Excluded Menu Name
Oracle EBS Tables Used
fnd_application_vl, fnd_responsibility_vl, fnd_resp_functions, fnd_form_functions_vl, fnd_menus_vl
Report Categories
Related Reports
FND Responsibility Upload, Blitz Report Template Sharing, FND Responsibility Access, Blitz Report Assignments and Responsibilities, FND User Login History
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Responsibility Menu Exclusions 23-Jan-2018 063112.xlsx |
| Blitz Report™ XML Import | FND_Responsibility_Menu_Exclusions.xml |
| SQL Source | FND Responsibility Menu Exclusions.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-responsibility-menu-exclusions/ |
Executive Summary
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.
Business Challenge
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.
The Solution
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).
Technical Architecture
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.
Parameters & Filtering
- 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.
Performance & Optimization
This report queries a specific set of configuration tables and is generally very fast and lightweight.
FAQ
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.
Useful Links
- 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
© Enginatics GmbH