Results for “bne_interface_cols_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BNE_INTERFACE_COLS_TL is the translation table for BNE_INTERFACE_COLS_B within the BNE (Web Applications Desktop Integrator) schema in Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to store language-specific translations of the descriptive column attributes defined in the base table. Web Applications Desktop Integrator, commonly known as Web ADI, allows users to create, upload, and download desktop-integrated spreadsheets that interface directly with EBS forms and concurrent programs. The BNE_INTERFACE_COLS_B and its translation counterpart BNE_INTERFACE_COLS_TL define the layout and metadata of columns displayed within these integrator interfaces.

From a Data Vault modeling perspective, the mined metadata classifies this object as standalone. In practice, translation tables most closely resemble satellites, because they attach descriptive, language-dependent attributes to a parent business key defined in BNE_INTERFACE_COLS_B. Analysts should treat classification as a heuristic suggestion rather than a fixed architectural rule.

Key Information Stored

The table holds fifteen documented columns and is keyed by the composite primary key BNE_INTERFACE_COLS_TL_PK, defined on INTERFACE_CODE, SEQUENCE_NUM, APPLICATION_ID, and LANGUAGE. A second unique index, BNE_INTERFACE_COLS_TL_UK1, extends this business key with ZD_EDITION_NAME, providing the strongest business-key candidate for uniqueness enforcement across editions.

• INTERFACE_CODE – identifies the parent integrator interface definition; part of both the primary and business keys.
• SEQUENCE_NUM – orders the column within the interface layout.
• APPLICATION_ID – the owning application context for the column definition.
• LANGUAGE – the language of the translated text held in this row.
• SOURCE_LANG – the source language from which the translation was derived.
• USER_HINT – the localized guidance text shown to users entering data.
• USER_HELP_TEXT – longer localized help content for the column.
• PROMPT_LEFT and PROMPT_ABOVE – localized column prompt captions positioned to the left of or above the field.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE – standard EBS audit and concurrency columns.
• ZD_EDITION_NAME – editioning support column present in 12.2.x.

Common Use Cases and Queries

Typical usage involves retrieving localized column prompts and help for a given interface and language, or auditing which languages have been seeded for a layout.

• Reporting translated prompts: SELECT INTERFACE_CODE, SEQUENCE_NUM, PROMPT_LEFT, PROMPT_ABOVE FROM BNE_INTERFACE_COLS_TL WHERE LANGUAGE = USERENV('LANG').
• Identifying untranslated languages: compare distinct LANGUAGE values against the base table's expected set.
• Verifying business-key integrity against the UK1 index columns including ZD_EDITION_NAME.

Related Objects

• BNE_INTERFACE_COLS_B – the base table providing the untranslated column definitions; join on INTERFACE_CODE, SEQUENCE_NUM, and APPLICATION_ID.
• BNE_INTERFACE_COLS_VL – the language view that unites base and translation rows.
• BNE_INTERFACES_B and BNE_INTERFACES_TL – parent interface definitions referenced through INTERFACE_CODE.
• FND_APPLICATION – resolves APPLICATION_ID to an application name.
• FND_LANGUAGES – validates LANGUAGE and SOURCE_LANG values.