FND Menu Entries – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
None
Report Parameters
User Menu Name, User Menu Name like, Menu Name, Prompt, Submenu, Menu Entry, User Function Name, Function Name, User Form Name, Form Name, Assigned To Responsibility, Created By, Creation Date From, Creation Date To, Last Update Date From, Last Update Date To
Oracle EBS Tables Used
fnd_menus_vl, fnd_menu_entries_vl, fnd_menus_tl, fnd_form_functions_vl, fnd_form_vl
Report Categories
Related Reports
FND Menu Entry Upload, FND Responsibility Access 11i, FND Responsibility Access, FND Responsibility Menu Exclusions, FND User Login Page Favorites, Blitz Report Assignments and Responsibilities, FND Forms Personalizations, FND Responsibilities
Running This SQL Without Blitz Report
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.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Menu Entries 21-Jul-2017 172713.xlsx |
| Blitz Report™ XML Import | FND_Menu_Entries.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-menu-entries/ |
Executive Summary
The FND Menu Entries report documents the menu hierarchy in Oracle EBS. It shows which functions and sub-menus are attached to a parent menu, effectively mapping out the navigation structure.
Business Challenge
- Security Audit: Verifying which functions are accessible from a specific Responsibility’s menu.
- Navigation Design: Documenting the current menu structure before redesigning the user navigation.
- Troubleshooting: Finding where a specific function (e.g., “Enter Journals”) is located in the menu tree.
The Solution
This Blitz Report explodes the menu structure:
- Menu: The parent menu name.
- Entry: The prompt (label) seen by the user.
- Function/Submenu: The actual function or child menu attached to that entry.
- Grant: Shows if the function is “Grant” only (not visible, but authorized).
Technical Architecture
The report queries FND_MENUS_VL and FND_MENU_ENTRIES_VL. It can recursively traverse the tree if needed, but typically shows direct assignments.
Parameters & Filtering
- User Menu Name: Filter by the top-level menu (e.g., “GL_SUPERUSER”).
- Function Name: Find all menus that contain a specific function.
- Prompt: Search by the user-visible label.
Performance & Optimization
- Recursion: Menu structures can be deep. The report is optimized to show direct relationships.
FAQ
- Q: Does this show Exclusions?
- A: No, this shows the definition of the menu. To see what a user can actually access (net of exclusions), 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
© 2026 Enginatics