Search Results fnd_menus




Deep Dive into FND_MENUS Table in Oracle EBS 12.1.1/12.2.2

The FND_MENUS table is a foundational component of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, serving as the repository for menu definitions that govern application navigation and security. It stores hierarchical menu structures used by the Oracle Application Framework (OAF), Forms, and other modules to render user interfaces. Below is a detailed technical analysis of its structure, purpose, and integration within EBS.

Key Attributes of FND_MENUS

  • MENU_ID: Primary key, uniquely identifying each menu.
  • MENU_NAME: Unique name for the menu (e.g., "SYSADMIN").
  • USER_MENU_NAME: Display name shown to end-users (e.g., "System Administrator").
  • DESCRIPTION: Optional text describing the menu's purpose.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.
  • TYPE: Indicates menu type (e.g., "FOLDER" for container menus).

Functional Role in EBS

The FND_MENUS table enables:

  1. Navigation Hierarchy: Defines parent-child relationships between menus and submenus via the FND_MENU_ENTRIES table.
  2. Security Integration: Menus are linked to responsibilities (through FND_RESPONSIBILITY) and function security (via FND_FORM_FUNCTIONS).
  3. Multi-Lingual Support: User-facing names are stored in FND_MENUS_TL (Translation table).

Technical Dependencies

Related TableRelationship
FND_MENU_ENTRIESStores menu items (forms, submenus) associated with a menu.
FND_RESPONSIBILITYLinks menus to responsibilities (MAIN_MENU_ID column).
FND_FORM_FUNCTIONSFunctions referenced by menu entries for security checks.

Customization Considerations

Modifications to FND_MENUS require adherence to Oracle's customization guidelines:

  • Use Oracle Application Developer (OAD) or Oracle Developer Suite for changes.
  • Always create custom menus with new MENU_IDs to avoid conflicts during upgrades.
  • Leverage FND_LOAD utilities for data migration between environments.

Performance Implications

Indexes on MENU_ID and MENU_NAME ensure efficient lookup during:

  • Responsibility initialization.
  • Menu rendering in OAF/Forms.
  • Security validation (Function Security).

Version-Specific Notes

In EBS 12.2.2, FND_MENUS remains structurally consistent with 12.1.1, but enhancements include:

  • Tighter integration with WebLogic Server for menu caching.
  • Extended support for REST service endpoints in menu entries.

Understanding FND_MENUS is critical for EBS administrators and developers tasked with customizing navigation flows or implementing granular access controls in Oracle Applications.