Search Results fnd_menus_uk1

Overview

The FND_MENUS table is a core Application Object Library repository for menu definitions within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master table for storing the hierarchical structure of navigable menus that underpin the user interface. A menu is a logical grouping of functions, sub-menus, and other menus, which are ultimately assigned to responsibilities to define the accessible application features for a user. This table is owned by the APPLSYS schema and is fundamental to the security and navigation architecture of the entire EBS system.

Key Information Stored

The table's primary data elements are defined by its key columns. The MENU_ID column is the unique numeric primary identifier for each menu. The MENU_NAME column is a unique, user-defined alphanumeric key, often used for referencing the menu in various forms and setup tasks. While the provided ETRM excerpt lists only these key columns, a complete FND_MENUS table typically includes additional descriptive and control columns such as USER_MENU_NAME (the display name), DESCRIPTION, CREATION_DATE, and LAST_UPDATE_DATE. The table's integrity is enforced by the primary key FND_MENUS_PK (on MENU_ID) and the unique key FND_MENUS_UK1 (on MENU_NAME).

Common Use Cases and Queries

Technical consultants and DBAs interact with FND_MENUS primarily for diagnostic, reporting, and security analysis purposes. Common scenarios include tracing the menu hierarchy assigned to a specific responsibility, identifying all sub-menus referenced within a parent menu, and auditing menu usage. A foundational query retrieves menu details for a known responsibility by joining with FND_RESPONSIBILITY.

SELECT fm.menu_name, fm.user_menu_name
FROM fnd_menus fm, fnd_responsibility fr
WHERE fr.menu_id = fm.menu_id
AND fr.responsibility_key = 'SYSTEM_ADMINISTRATOR';

Another critical query identifies the constituent entries of a menu by joining with FND_MENU_ENTRIES, which links menus to their functions and sub-menus. Direct updates to this table are strongly discouraged; modifications should be performed through the official "Menus" form within the Application Developer responsibility to maintain metadata consistency.

Related Objects

The FND_MENUS table is a central hub referenced by numerous key security and navigation objects. As per the ETRM metadata, its primary relationships are:

• FND_MENU_ENTRIES: Defines the contents of a menu, referencing FND_MENUS twice—for the parent MENU_ID and the child SUB_MENU_ID.
• FND_RESPONSIBILITY: Assigns a menu to a responsibility via the MENU_ID column.
• FND_MENUS_TL: The Translation table storing language-specific names for menus, linked by MENU_ID.
• FND_RESP_FUNCTIONS: References the table where the ACTION_ID is a MENU_ID, connecting excluded functions to menus.
• Various Module-Specific Tables: Including ICX_SESSIONS, PA_DIST_LIST_ITEMS, and PO_COMMODITY_GRANTS, demonstrating how menus integrate with other application components like iProcurement and Projects.