Search Results bsc_db_measure_groups_tl




Overview
Explore in AI Chat

Overview

BSC_DB_MEASURE_GROUPS_TL is a translation (TL) table within the Oracle E-Business Suite Balanced Scorecard module (product code BSC). It stores language-dependent descriptive attributes for measure groups — the logical containers used to organize performance measures within Balanced Scorecard dashboards and scorecards. Because it is a TL table, each logical measure group is represented once per installed language, allowing the same group to carry translated short names and help text across a multilingual deployment.

The ETRM metadata classifies this object as belonging to the BSC - Balanced Scorecard product, which is flagged as obsolete in the 12.1.1 / 12.2.2 documentation set. The ETRM entry further records that the table is "Not implemented in this database" in the documented instance, meaning the object definition is retained for reference but the table carries no active rows in that environment.

Under the heuristic Data Vault classification mined from the foreign-key structure, the table is described as hub-leaning. In modeling terms, this suggests treating MEASURE_GROUP_ID as a durable business key whose descriptive, language-specific attributes would be modeled as satellite content attached to the measure-group hub, rather than as an independent transactional entity.

Key Information Stored

The documented physical schema for BSC_DB_MEASURE_GROUPS_TL comprises five columns. The most significant are:

  • MEASURE_GROUP_ID — the surrogate primary key component identifying the measure group. It forms the join back to the base (non-translated) measure-group entity and to the column-level translation table.
  • LANGUAGE — the language code for the row, determining which locale's translation is stored. Together with MEASURE_GROUP_ID it constitutes the business-key candidate captured by the unique index BSC_DB_MEASURE_GROUPS_TL_U1.
  • SOURCE_LANG — the source language from which the translation was derived, used by the translation framework to track the origin language of the text.
  • SHORT_NAME — the translated short display name of the measure group, the primary user-facing label rendered in scorecard navigation.
  • HELP — the translated help or descriptive text presented to end users when working with the measure group.

The surrogate primary key, BSC_DB_MEASURE_GROUPS_TL_PK, is defined on MEASURE_GROUP_ID alone, while the unique index BSC_DB_MEASURE_GROUPS_TL_U1 on (MEASURE_GROUP_ID, LANGUAGE) enforces the business rule that only one translation row may exist per group per language. This distinction — surrogate PK versus composite unique business key — is the standard Oracle Applications TL pattern.

Common Use Cases and Queries

The principal use case is multilingual reporting of Balanced Scorecard measure-group labels. A typical query joins the translation table to the base measure-group table filtered by the session language:

  • Retrieve translated display names for a scorecard's measure groups: select MEASURE_GROUP_ID, SHORT_NAME from BSC_DB_MEASURE_GROUPS_TL where LANGUAGE = userenv('LANG').
  • Audit translation completeness: compare row counts per LANGUAGE against the base measure-group table to detect groups lacking a translation in a required locale.
  • Trace help text: select SHORT_NAME, HELP where SOURCE_LANG differs from LANGUAGE to identify derived translations.
  • Join to BSC_DB_MEASURE_COLS_TL on MEASURE_GROUP_ID to reconstruct the full measure hierarchy with translated column labels.

Because the object is documented as obsolete and not implemented, these patterns are primarily relevant to historical data migration, upgrade assessment, or reference reconstruction rather than day-to-day production queries.

Related Objects

The documented foreign-key relationship identifies the following dependency:

  • BSC_DB_MEASURE_COLS_TL — references this table via MEASURE_GROUP_ID; the column-level translation table that carries measure columns belonging to each measure group.
  • BSC_DB_MEASURE_GROUPS_TL_PK — the primary-key constraint on MEASURE_GROUP_ID.
  • BSC_DB_MEASURE_GROUPS_TL_U1 — the unique index on (MEASURE_GROUP_ID, LANGUAGE) enforcing the translation business key.

The remaining related objects are the base, non-translated measure-group entity and the broader BSC_DB_MEASURE_COLS family referenced through the shared MEASURE_GROUP_ID key. Analysts working with obsolete BSC schemas should validate actual object presence in each environment, since the documentation explicitly notes non-implementation in the reviewed database.