Search Results fnd_menus_tl

Overview

The FND_MENUS_TL table is a core Application Object Library table within Oracle E-Business Suite (EBS) that stores translated user-facing text for menus. It operates as a translation table (TL) for its base table, FND_MENUS, which defines the structure and logic of application menus. Its primary role is to support the multilingual capabilities of EBS by holding the translated name and description for each menu entry across different installed languages. This enables users to interact with the application's navigation menus in their preferred language, a fundamental requirement for global deployments of versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to map translated text to a specific menu and language. The critical columns, as indicated by the primary and unique keys, are MENU_ID, LANGUAGE, and USER_MENU_NAME. MENU_ID is the foreign key linking the translation to the base menu definition in FND_MENUS. The LANGUAGE column holds the language code (e.g., 'US' for American English) for the translation. USER_MENU_NAME contains the actual translated text displayed to the end-user in the application's navigation. While not explicitly listed in the provided metadata, a standard TL table in EBS typically also includes columns for the translated description (USER_MENU_DESC), source language indicators, and creation/update audit information.

Common Use Cases and Queries

A primary use case is troubleshooting or verifying the display of menu text in a specific language. Developers and functional consultants often query this table to identify missing translations or to audit menu nomenclature. Common SQL patterns include retrieving all translations for a specific menu or finding the translated name for a menu in the current session language. For example:

• To find all translations for a known menu ID: SELECT language, user_menu_name FROM fnd_menus_tl WHERE menu_id = <menu_id> ORDER BY language;
• To join with the base table for a comprehensive view: SELECT fm.menu_name, fmt.user_menu_name, fmt.language FROM fnd_menus fm, fnd_menus_tl fmt WHERE fm.menu_id = fmt.menu_id AND fmt.language = 'DE';

Direct data manipulation in this table is strongly discouraged; updates should be performed via the standard EBS administration forms or APIs to maintain integrity.

Related Objects

FND_MENUS_TL has defined relationships with several key EBS objects, as per the provided metadata. Its existence is dependent on FND_MENUS, to which it is linked via a foreign key on MENU_ID. This establishes the core translation relationship. Furthermore, FND_MENUS_TL serves as a parent table to FND_MENU_ENTRIES_TL. The foreign key from FND_MENU_ENTRIES_TL references both MENU_ID and LANGUAGE in FND_MENUS_TL, ensuring that translations for menu entries are consistently aligned with the language of the parent menu's translation. This object is central to the EBS navigation and internationalization architecture.