Search Results bsc_db_measure_groups_tl_u1

Overview

BSC.BSC_DB_MEASURE_GROUPS_TL is the translation (TL) table for measure groups within the Oracle E-Business Suite Balanced Scorecard (BSC) module, part of the Oracle Enterprise Performance Foundation and ETRM/OBIA performance management stack. It stores the language-dependent descriptive attributes—namely the short name and help text—for each measure group defined in the parent entity table BSC_DB_MEASURE_GROUPS_B. The suffix _TL denotes the standard EBS multilanguage translation pattern, in which one physical table holds a row per installed language for each logical entity, with the SOURCE_LANG column tracking the origin language from which translations are derived.

From a dimensional modeling perspective, the metadata classifies this object as hub-leaning based on its foreign-key structure. In Data Vault terms, the MEASURE_GROUP_ID serves as a durable business key and the table behaves principally as a reference/distribution construct rather than a pure transaction satellite. This classification is a modeling suggestion only; functionally, the table is a translation satellite attached to the measure group hub.

Key Information Stored

The table contains five columns and occupies the APPS_TS_TX_DATA tablespace with PCTFREE 10. The most significant columns are:

• MEASURE_GROUP_ID (NUMBER) — Surrogate/business identifier for the measure group; the parent key in the translation relationship.
• LANGUAGE (VARCHAR2) — The target language code for the translated text row.
• SOURCE_LANG (VARCHAR2) — The language of the source text that the translated row mirrors; changes to the source-language row propagate to translated rows until a translation is explicitly provided.
• HELP (VARCHAR2(150)) — The measure group description, documented as a maximum of 50 characters of meaningful help text.
• SHORT_NAME (VARCHAR2(30)) — A concise display label for the measure group used in scorecard UIs and reports.

The declared primary key is BSC_DB_MEASURE_GROUPS_TL_PK on MEASURE_GROUP_ID, while the unique business-key candidate BSC_DB_MEASURE_GROUPS_TL_U1 spans (MEASURE_GROUP_ID, LANGUAGE), occupying the APPS_TS_TX_IDX tablespace. This composite uniqueness enforces one translation row per measure group per language.

Common Use Cases and Queries

Primary use cases include multilingual scorecard presentation, translation completeness auditing, and joining measure group metadata to associated measure columns.

• Retrieve the localized description for a specific measure group: SELECT SHORT_NAME, HELP FROM BSC.BSC_DB_MEASURE_GROUPS_TL WHERE MEASURE_GROUP_ID = :id AND LANGUAGE = USERENV('LANG').
• Identify untranslated rows for a target language: SELECT MEASURE_GROUP_ID, SOURCE_LANG FROM BSC.BSC_DB_MEASURE_GROUPS_TL WHERE LANGUAGE = 'ES' AND SOURCE_LANG = 'US'.
• Count available translations per group: SELECT MEASURE_GROUP_ID, COUNT(*) FROM BSC.BSC_DB_MEASURE_GROUPS_TL GROUP BY MEASURE_GROUP_ID.
• Join to the translated measure columns table: SELECT g.SHORT_NAME, c.COLUMN_NAME FROM BSC.BSC_DB_MEASURE_GROUPS_TL g JOIN BSC.BSC_DB_MEASURE_COLS_TL c ON g.MEASURE_GROUP_ID = c.MEASURE_GROUP_ID AND g.LANGUAGE = c.LANGUAGE.

Reporting typically filters by LANGUAGE to avoid duplicate rows, since the same MEASURE_GROUP_ID repeats once per installed language.

Related Objects

The following objects reference or closely relate to this table:

• BSC_DB_MEASURE_COLS_TL — References BSC_DB_MEASURE_GROUPS_TL via MEASURE_GROUP_ID; the strongest documented dependency.
• BSC_DB_MEASURE_GROUPS_B — Base (language-independent) table holding the canonical measure group definition; joined on MEASURE_GROUP_ID.
• BSC_DB_MEASURE_COLS_B — Base table of measure columns belonging to each group.
• APPS synonym BSC_DB_MEASURE_GROUPS_TL — The APPS-layer synonym through which application code accesses the BSC-owned table.
• BSC_DB_MEASURE_GROUPS_TL_U1 — The unique index enforcing (MEASURE_GROUP_ID, LANGUAGE) integrity.

Queries should always honor the LANGUAGE predicate to preserve correct cardinality across translations.