Search Results menu_code

Overview

BNE_MENUS_TL is the translation table for BNE_MENUS_B within the BNE (Web Applications Desktop Integrator) product in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores language-specific menu definitions that drive the Oracle Web Applications Desktop Integrator user interface, and it pairs with its base table to hold the descriptive, translatable text for each menu. The table resides in the BNE schema and carries a status of VALID.

Following the heuristic Data Vault classification supplied in the metadata, this table is modeled as standalone. In Data Vault terms, a translation table of this nature is best understood as a satellite attached to the BNE_MENUS_B hub: the hub holds the durable menu identity, while BNE_MENUS_TL carries the language-dependent descriptive attributes (USER_NAME and related descriptive text) keyed to that identity. Because the metadata documents no foreign-key relationships to other objects, the table is treated as standalone for modeling purposes, even though it functionally depends on BNE_MENUS_B through the shared APPLICATION_ID and MENU_CODE business keys.

Key Information Stored

The table is documented with 11 columns. The surrogate/business primary key, BNE_MENUS_TL_PK, is composed of APPLICATION_ID, MENU_CODE, and LANGUAGE — the combination that uniquely identifies a translated menu row. A second unique index, BNE_MENUS_TL_UK1, extends the key with ZD_EDITION_NAME (APPLICATION_ID, MENU_CODE, LANGUAGE, ZD_EDITION_NAME), reflecting the editioning model introduced in 12.2.2.

• APPLICATION_ID — identifies the owning application context; part of the primary key.
• MENU_CODE — the unique code naming the menu; the primary business identifier carried from BNE_MENUS_B.
• LANGUAGE — the language of the translation row; part of the primary key.
• SOURCE_LANG — the source language from which the translation derives.
• USER_NAME — the user-facing (translated) display name of the menu.
• ZD_EDITION_NAME — the editioning qualifier that participates in the unique index BNE_MENUS_TL_UK1.
• CREATED_BY, CREATION_DATE — standard audit columns for row creation.
• LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard audit columns for the most recent change.

Note that the primary key is the combination of business columns rather than a single synthetic surrogate; the documented key is the natural composite of application, menu code, and language.

Common Use Cases and Queries

Typical reporting resolves the translated menu name for a given application and language by joining the translation table to the base table on APPLICATION_ID and MENU_CODE. A representative query retrieves the display name for a specified menu and language:

• SELECT t.user_name, t.source_lang, t.last_update_date FROM bne.bne_menus_tl t WHERE t.application_id = :app_id AND t.menu_code = :menu_code AND t.language = :lang;
• Enumerating all available translations for a menu to audit language coverage across the enterprise.
• Identifying stale translations by filtering on LAST_UPDATE_DATE or comparing SOURCE_LANG against LANGUAGE.
• Reconciling translated menus against the base table to detect orphaned or missing translations.
• In 12.2.2 environments, filtering by ZD_EDITION_NAME to isolate the active edition's translation rows.

Related Objects

The most significant related objects are the base table and the standard EBS constructs that surround it. Although the metadata classifies the table as standalone, functional relationships exist through shared business keys.

• BNE_MENUS_B — the base (non-translatable) menu table; joined on APPLICATION_ID and MENU_CODE.
• BNE_MENUS_VL — the typical translated view that joins BNE_MENUS_B and BNE_MENUS_TL to present language-resolved menu data.
• BNE_MENUS_TL_PK — the primary key constraint on (APPLICATION_ID, MENU_CODE, LANGUAGE).
• BNE_MENUS_TL_UK1 — the unique index adding ZD_EDITION_NAME.
• FND_APPLICATION / FND_APPLICATION_TL — resolves the APPLICATION_ID to an application name for reporting context.
• FND_LANGUAGES — provides the installed language definitions referenced by the LANGUAGE column.

These objects are the primary touchpoints for querying, validating, and reporting on translated BNE menu definitions in both 12.1.1 and 12.2.2.