Search Results fnd_menu_entries

Overview

The FND_MENU_ENTRIES table is a core repository table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS). It defines the hierarchical structure of the navigator menus, specifically for the legacy Release 10 SmartClient (10SC) interface. Each record in this table represents a single item within a menu, which can be a link to a form function, a separator, or a submenu. The table is fundamental to the application's security and user interface, as it dictates the menu entries a user can access based on their assigned responsibilities and menus. It resides in the APPLSYS schema and is a key component for building the navigational hierarchy presented to end-users.

Key Information Stored

The table stores the metadata required to construct a menu tree. Its primary key is a composite of MENU_ID and ENTRY_SEQUENCE, ensuring unique ordering of items within a specific menu. Critical columns include MENU_ID, which links to the parent menu defined in FND_MENUS, and ENTRY_SEQUENCE, which dictates the display order. The FUNCTION_ID column links the menu entry to an executable form function (in FND_FORM_FUNCTIONS), while SUB_MENU_ID allows for nested menu structures by pointing to another menu. Other important columns define the entry's type (e.g., function or separator), its grant flag for security, and prompt information. The user-facing prompts for these entries are stored in the corresponding translation table, FND_MENU_ENTRIES_TL.

Common Use Cases and Queries

This table is central to troubleshooting navigation issues, auditing security configurations, and performing custom reporting. Common scenarios include identifying all functions available within a specific menu for a responsibility, diagnosing missing menu entries, and analyzing the menu hierarchy. A typical query joins FND_MENU_ENTRIES with FND_MENUS, FND_FORM_FUNCTIONS, and the translation table to produce a readable report of a menu's structure.

• Listing Menu Structure: SELECT fme.menu_id, fme.entry_sequence, fmet.user_menu_name, fff.function_name FROM fnd_menu_entries fme JOIN fnd_menus_tl fmet ON fme.menu_id = fmet.menu_id JOIN fnd_form_functions fff ON fme.function_id = fff.function_id WHERE fme.menu_id = <MENU_ID> ORDER BY fme.entry_sequence;
• Finding Menus Containing a Specific Function: SELECT fm.menu_name, fme.* FROM fnd_menu_entries fme JOIN fnd_menus fm ON fme.menu_id = fm.menu_id WHERE fme.function_id = (SELECT function_id FROM fnd_form_functions WHERE function_name = '<FUNCTION_NAME>');

Related Objects

FND_MENU_ENTRIES has integral relationships with several other key FND tables, forming the backbone of the EBS navigation and function security model.

• FND_MENUS / FND_MENUS_TL: The parent table containing the definition of the menu itself, linked via MENU_ID and SUB_MENU_ID foreign keys.
• FND_FORM_FUNCTIONS: Defines the executable application function (like a form or a web page) invoked by the menu entry, linked via the FUNCTION_ID foreign key.
• FND_MENU_ENTRIES_TL: The translation table that holds the user-visible prompt for each menu entry in different languages.
• FND_RESP_FUNCTIONS & FND_USER_RESP_GROUPS: These tables work with FND_MENU_ENTRIES to enforce security, determining which menu entries are accessible to a user's assigned responsibilities.