FND Menu Entry Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Upload to create, update and delete the entries of existing menus, as in the Menus form.
Upload Mode Create opens an empty sheet for new entries. Create, Update downloads the entries of the menus selected by the parameters; new rows can be added to the same file.
User Menu Name and Menu Name select the menu and default each other. An entry is identified by the menu and its Entry Sequence, which defaults to the next multiple of ten above the highest sequence of the menu. Changing the Entry Sequence of a downloaded row creates a new entry and keeps the old one; delete the old entry with Delete Record Yes.
Either Sub Menu or Function Name is required. A blank Grant Flag makes the entry not grantable.
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
Upload Mode, User Menu Name, Menu Name, Function Name, User Function Name, Responsibility
Oracle EBS Tables Used
fnd_menus_vl, fnd_menu_entries, fnd_menu_entries_tl, fnd_form_functions_vl
Report Categories
Related Reports
FND Menu Entries, FND Responsibility Access, Blitz Report Template Sharing, FND User Login Page Favorites, FND Responsibility Upload, FND Responsibility Menu Exclusions, FND Forms Personalizations, Blitz Report Assignments and Responsibilities
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 | Example |
| Blitz Report™ XML Import | FND_Menu_Entry_Upload.xml |
| SQL Source | FND Menu Entry Upload.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-menu-entry-upload/ |
Case Study & Technical Analysis: FND Menu Entry Upload
Executive Summary
FND Menu Entry Upload creates, updates and deletes the entries of Oracle Application Object Library menus, the navigation structures that connect responsibilities to forms and sub-menus. It is designed for EBS implementation and security teams who must add many menu entries at once, for example when a module such as Supply Chain Hub is installed and new functions need to appear on existing menus. The template downloads the entries of matching menus, lets the user add or change rows in Excel, and applies the changes through the menu entry API.
Business Challenge
- Manual Menu Configuration: Adding a set of functions to a menu through the Menus form requires one entry at a time, with the sequence and prompt set by hand.
- Consistent Navigation: Users of the same responsibility need the same entries in the same order, and inconsistent sequences make navigation confusing.
- Installation Projects: Module installations often require a defined list of entries to be added to seeded menus, and that list must be reproducible across environments.
- Clean Up: Obsolete entries must be removed in a controlled way, without editing the menu record by hand.
The Solution
- Menu Entry Extract: The template downloads each menu entry with its menu name, user menu name, sequence, prompt and description, so existing entries can be reviewed before changes.
- Sub Menu or Function Choice: Each row names either a sub-menu or a form function, which the upload uses to attach the entry to the menu.
- Grant Control: The grant flag decides whether the entry is available to security grants, with Y as the default.
- Deletion Flag: A delete column removes an existing entry when set to Y, so cleanup uses the same template as creation.
Technical Architecture (High Level)
Primary Tables
FND_MENUS_VL: the menu definitions, including the menu name, user menu name and menu type. It is read for both the parent menu and the referenced sub-menu.FND_MENU_ENTRIES: the entries of each menu, with the sequence, the function or sub-menu reference and the grant flag.FND_MENU_ENTRIES_TL: the translated prompt and description of each entry.FND_FORM_FUNCTIONS_VL: the form functions that an entry can launch, with their user function names.
Logical Relationships
- Each row of
FND_MENUS_VLis joined to its entries inFND_MENU_ENTRIESon the menu identifier. - Each entry is joined to
FND_MENU_ENTRIES_TLon the menu identifier and entry sequence, restricted to the session language. - The sub-menu reference is outer joined back to
FND_MENUS_VL, so the user menu name of the sub-menu is returned. - The function reference is outer joined to
FND_FORM_FUNCTIONS_VL, so the user function name is returned for function entries. - Rows are numbered by menu name and entry sequence to give each row a stable position in the template.
Parameters & Filtering
- Upload Mode: Selects Create, or Create and Update. In Create and Update mode the existing entries of the selected menus are downloaded.
- User Menu Name: Filters the menus by their translated name.
- Menu Name: Filters the menus by their internal name, such as the seeded navigation menu code.
- Function Name and User Function Name: Restrict the entries to those launching a given form function.
- Responsibility: Selects the menu attached to a responsibility, so the entries of that responsibility can be maintained.
Performance & Optimization
- Menu Scoped Extract: The menu filters are applied to the menu view first, so only entries of the chosen menus are read.
- Language Restriction: The translation join is limited to the session language, which keeps one prompt per entry.
- Outer Joins for Entries: Sub-menu and function references are outer joined, because an entry has one or the other and not both.
- Create Mode Template: In Create mode the download is suppressed, so the sheet is empty and no existing entries are read.
FAQ
Q: Which fields are required for a new menu entry? A: A menu name, an entry sequence if you want to control order, a prompt, and either a sub-menu or a function name.
Q: Can I remove an entry with this template? A: Yes. Set the Delete Record column to Y on the downloaded row of the entry.
Q: What does the Grant Flag control? A: It controls whether the entry is grantable through security. Y is the default, and N makes the entry not grantable.
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