Results for “bsc_kpi_defaults_tl”

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

Overview

BSC_KPI_DEFAULTS_TL is the translation table for the Balanced Scorecard (BSC) KPI Defaults entity in Oracle E-Business Suite. In the EBS architecture, translation (_TL) tables exist to store language-specific, multilingual descriptive text that accompanies a base (_B) table. Here, the base table is BSC_KPI_DEFAULTS_B, which holds the language-independent definition of KPI default indicators, and BSC_KPI_DEFAULTS_TL stores the corresponding translated display text used to render the KPI information box in the Balanced Scorecard application. The object belongs to the BSC module, which Oracle has classified as Obsolete in current releases.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. This reflects its role: it carries descriptive, context-dependent attributes (translated names and text) keyed to a parent business entity, rather than serving as a hub or a link between independent entities. The translation rows are dependent satellites of the base KPI default record.

The ETRM documentation notes that this table is not implemented in the reference database instance, meaning it may exist only in installations where Balanced Scorecard was configured or in historical schemas. Implementers should verify presence before relying on it in custom code.

Key Information Stored

The table is owned by the BSC schema and contains 25 documented columns in the 12.1.1 ETRM schema. The most significant columns fall into three groups.

Keys and language context. The composite primary key BSC_KPI_DEFAULTS_TL_PK is defined over INDICATOR, TAB_ID, and LANGUAGE. A second unique index, BSC_KPI_DEFAULTS_TL_U1, covers TAB_ID, INDICATOR, and LANGUAGE, functioning as the business-key candidate that guarantees one translated row per indicator, per tab, per language. SOURCE_LANG records the language from which a translation was derived, distinguishing original text from translated text.

• INDICATOR – identifier of the KPI indicator; also the foreign key back to BSC_KPI_DEFAULTS_B.
• TAB_ID – identifier of the tab or information box grouping within the scorecard.
• LANGUAGE – the NLS language code for the translated content.
• SOURCE_LANG – the originating language of the source string.
• ANALYSIS_OPTION0_NAME, ANALYSIS_OPTION1_NAME, ANALYSIS_OPTION2_NAME – translated labels for up to three analysis options presented in the KPI information box.
• PERIOD_NAME – translated label for the period dimension.
• SERIES_NAME – translated label for the series dimension.
• DIM_LEVEL1_NAME through DIM_LEVEL8_NAME – translated names for up to eight dimension levels exposed in the KPI display.
• DIM_LEVEL1_TEXT through DIM_LEVEL8_TEXT – translated descriptive text accompanying each dimension level.

Common Use Cases and Queries

The primary reporting use case is retrieving the correct localized label set for a KPI information box. A typical query joins the base and translation tables filtered by session language:

• SELECT t.indicator, t.tab_id, t.period_name, t.series_name FROM bsc_kpi_defaults_tl t WHERE t.language = USERENV('LANG') AND t.indicator = :indicator AND t.tab_id = :tab_id;
• Comparing available translations: SELECT indicator, tab_id, language FROM bsc_kpi_defaults_tl WHERE indicator = :indicator ORDER BY language;
• Auditing missing translations by left-joining BSC_KPI_DEFAULTS_B to _TL and filtering NULL LANGUAGE values.

Because the module is obsolete, most query activity is diagnostic or migration-related, such as extracting historical scorecard configuration before decommissioning.

Related Objects

• BSC_KPI_DEFAULTS_B – the base table; joined on BSC_KPI_DEFAULTS_TL.INDICATOR = BSC_KPI_DEFAULTS_B.INDICATOR and TAB_ID. This is the documented foreign-key relationship.
• BSC_KPI_DEFAULTS_TL_PK / BSC_KPI_DEFAULTS_TL_U1 – the primary key constraint and unique business-key index enforcing uniqueness across INDICATOR, TAB_ID, and LANGUAGE.
• BSC schemas views and KPI information box rendering components – application-layer objects that consume the translated name and text columns for display.
• FND_LANGUAGES – the standard EBS language reference implicitly associated with the LANGUAGE and SOURCE_LANG columns.