Search Results bsc_sys_labels_tl_u1

Overview

BSC.BSC_SYS_LABELS_TL is a translation (TL) table in the Oracle E-Business Suite Balanced Scorecard (BSC) schema. It stores multilingual label text for user-interface elements such as tabs and simulation tree indicators. As the "_TL" suffix implies, the table holds the language-dependent portion of the BSC_SYS_LABELS entity, while the corresponding base table, BSC_SYS_LABELS_B, holds the language-independent anchor rows. This split follows the standard Oracle EBS MLS (Multi-Language Support) architecture, in which a "_B" table stores one row per entity and a "_TL" table stores one row per entity per installed language.

From a modeling perspective, the mined relationship data classifies BSC_SYS_LABELS_TL as satellite-leaning. This heuristic suggests treating the table as a satellite attached to a hub centered on LABEL_ID (or on the composite label identity), with LANGUAGE acting as the descriptive, time-independent qualifier of the translated text. The classification is advisory rather than prescriptive; the table's real role in EBS is the MLS translation store, not a data-warehouse construct.

Key Information Stored

The table consists of six documented columns, with a composite primary key of LABEL_ID, LANGUAGE, SOURCE_CODE, and SOURCE_TYPE.

• LABEL_ID (NUMBER) — Identifier of the label. This is the primary surrogate link back to the base table row in BSC_SYS_LABELS_B and forms part of the composite primary key.
• LANGUAGE (VARCHAR2) — The language code for the translated text in this row. Together with LABEL_ID, it distinguishes translation rows.
• SOURCE_TYPE (NUMBER) — Source type, indicating the category of the label origin. A business-key column and part of the unique index.
• SOURCE_CODE (NUMBER) — Source code; the tab identifier or indicator type. A business-key column, and also the foreign-key column joining to BSC_SYS_LABELS_B.
• SOURCE_LANG (VARCHAR2) — The language that the text mirrors. If the text has not yet been translated into LANGUAGE, changes made to the source-language row are reflected here as well. This is the standard MLS mirroring pointer.
• NAME (VARCHAR2, 150) — The actual label text presented to the user.

The unique index BSC_SYS_LABELS_TL_U1 (on SOURCE_TYPE, SOURCE_CODE, LABEL_ID, LANGUAGE) is the documented business-key candidate, differing slightly in column order from the primary key BSC_SYS_LABELS_TL_PK. The primary key represents the physical row identity, while the unique index enforces the business uniqueness constraint across source, label, and language.

Common Use Cases and Queries

Typical uses include retrieving the correct localized label for a tab or simulation indicator, auditing which translations are present, and detecting untranslated rows where NAME still mirrors SOURCE_LANG.

A simple lookup of all translations for a given label:

• SELECT LANGUAGE, NAME FROM BSC.BSC_SYS_LABELS_TL WHERE LABEL_ID = :label_id;

Detecting missing translations (rows whose LANGUAGE differs from SOURCE_LANG but whose text was never translated):

• SELECT LABEL_ID, LANGUAGE, SOURCE_LANG, NAME FROM BSC.BSC_SYS_LABELS_TL WHERE LANGUAGE <> SOURCE_LANG;

A join back to the base table to resolve context for a specific source:

• SELECT t.LANGUAGE, t.NAME, t.SOURCE_TYPE FROM BSC.BSC_SYS_LABELS_TL t WHERE t.LABEL_ID = :label_id AND t.SOURCE_CODE = :source_code;

These patterns are frequent in localization validation reports and in scorecard configuration diagnostics.

Related Objects

The most significant related objects are:

• BSC.BSC_SYS_LABELS_B — the base MLS table. Joined on SOURCE_CODE (per the documented foreign key) and on LABEL_ID as the translation anchor.
• BSC.BSC_SYS_LABELS_TL_U1 — the unique index enforcing business-key uniqueness on SOURCE_TYPE, SOURCE_CODE, LABEL_ID, LANGUAGE.
• BSC.BSC_SYS_LABELS_TL_PK — the composite primary key index.
• APPS.BSC_SYS_LABELS_TL — the APPS-level synonym/interface that application code uses to access this table.
• FND BSC design data — the registered FND design data entry (BSC.BSC_SYS_LABELS_TL) that governs the object's deployment.

The table references BSC_SYS_LABELS_B via SOURCE_CODE and is itself referenced by the APPS synonym layer. This tight relationship reflects its role as the translated companion to the balanced scorecard label base table.