Search Results fnd_menu_entries_tl




Overview
Explore in AI Chat

Overview

The FND_MENU_ENTRIES_TL table is a core translation table within the Application Object Library (FND) of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Residing in the APPLSYS schema, its primary function is to store translated text for the entries that populate the EBS navigational menu structure. It operates as a child table to the base table FND_MENU_ENTRIES, enabling the system to present menu prompts and descriptions in multiple languages based on the user's session language. This table is fundamental to the internationalization (NLS) capabilities of the EBS user interface, ensuring that menus are rendered correctly in all supported languages.

Key Information Stored

The table's structure is designed to link translated text to a specific menu entry and language. Its primary key is a composite of MENU_ID, ENTRY_SEQUENCE, and LANGUAGE, which uniquely identifies a translation for a single menu entry. The MENU_ID and ENTRY_SEQUENCE columns form a foreign key relationship to the FND_MENU_ENTRIES base table, defining which menu entry is being translated. The LANGUAGE column holds the language code (e.g., 'US' for American English, 'D' for German). The primary translatable columns are USER_MENU_NAME, which holds the translated text displayed to the user in the navigator, and DESCRIPTION, which provides a translated description of the menu entry. The SOURCE_LANG column indicates the original language in which the entry was created.

Common Use Cases and Queries

A primary use case is troubleshooting or auditing the multilingual setup of the EBS menu. Developers and functional implementers frequently query this table to verify translations exist for newly added custom menu entries or to identify entries missing translations for a target language. A common reporting query retrieves all translations for a specific menu or entry sequence. For example, to find all translations for a menu with ID 12345, one would use: SELECT menu_id, entry_sequence, language, user_menu_name FROM fnd_menu_entries_tl WHERE menu_id = 12345 ORDER BY language, entry_sequence;. Another critical scenario involves data fixes, where an incorrect or missing translation for a key menu prompt must be inserted or updated directly in the database, often using the ADIAGNOSE utility or via a custom script with proper validation against the base table.

Related Objects

FND_MENU_ENTRIES_TL has direct, integral relationships with several other FND objects. As documented, its two key foreign key dependencies are:

  • FND_MENU_ENTRIES: This is the base table. The TL table inherits the MENU_ID and ENTRY_SEQUENCE from it. Any entry in FND_MENU_ENTRIES_TL must have a corresponding parent record here.
  • FND_MENUS_TL: The translation table for the FND_MENUS base table. The foreign key relationship on MENU_ID and LANGUAGE ensures referential integrity between the translated menu and its translated entries.

In practice, this table is also closely related to the FND_MENUS and FND_FORM_FUNCTIONS_TL tables, as menu entries often invoke form functions whose prompts are also translated. Data in this table is typically maintained via the Oracle Application Developer responsibility menus form and is leveraged by the FNDLOAD utility for seeding and migrating menu structures.