Results for “bsc_kpi_analysis_measures_tl”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BSC_KPI_ANALYSIS_MEASURES_TL is the translation (language) table for analysis measures within the Oracle EBS Balanced Scorecard module. In the Oracle EBS schema design convention, a table ending in the suffix _TL stores the same logical row as its base (_B) counterpart, distinguished by the LANGUAGE column, and carries the language-sensitive descriptive attributes such as translated names and help text. This object therefore holds translated analysis-measures information that backs the KPI analysis features of the Balanced Scorecard application.
The metadata classifies this object within the BSC product, which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The ETRM record notes "Not implemented in this database," indicating that in the reference environment the physical object is not present, and it exists primarily as a compatibility or historical artifact. Its Data Vault classification, mined heuristically from the foreign-key structure, is satellite-leaning: the table carries descriptive, language-dependent attributes keyed to a parent analysis-measures entity rather than acting as a hub of independent business keys or a link between hubs. This should be treated as a modeling suggestion rather than an authoritative definition.
Key Information Stored
The table is documented with nine columns. The most significant are the identifying and descriptive attributes:
- INDICATOR, ANALYSIS_OPTION0, ANALYSIS_OPTION1, ANALYSIS_OPTION2, SERIES_ID — composite identifying attributes that, together with LANGUAGE, form the surrogate primary key BSC_KPI_ANALYSIS_MEASURESTL_PK and the unique index BSC_KPI_ANALYSIS_MEASURESTL_U1. These tie each translated row to a specific analysis measure and series combination.
- LANGUAGE — the language code that distinguishes the translated row; a core part of both the primary key and the unique business-key index.
- SOURCE_LANG — the source language from which the translation derives.
- NAME — the translated display name of the analysis measure.
- HELP — the translated help or descriptive text associated with the measure.
The surrogate primary key is BSC_KPI_ANALYSIS_MEASURESTL_PK (INDICATOR, ANALYSIS_OPTION0, ANALYSIS_OPTION1, SERIES_ID, LANGUAGE, ANALYSIS_OPTION2). The unique index BSC_KPI_ANALYSIS_MEASURESTL_U1 (INDICATOR, ANALYSIS_OPTION0, ANALYSIS_OPTION1, ANALYSIS_OPTION2, SERIES_ID, LANGUAGE) represents the business-key candidate. The foreign-key metadata links the table to BSC_KPI_ANALYSIS_MEASURES_B through ANALYSIS_OPTION2, anchoring each translated row to its base record.
Common Use Cases and Queries
Because the object is translation-oriented, typical use is joining translated descriptive columns to the base analysis-measures table to present user-facing names and help in a requested language.
- Retrieving the translated NAME and HELP for a given analysis measure and language.
- Reporting on available translations to identify gaps in language coverage (rows present in _B but absent in _TL).
- Joining to BSC_KPI_ANALYSIS_MEASURES_B on ANALYSIS_OPTION2 to resolve base attributes alongside translated text.
A representative pattern is:
- SELECT t.NAME, t.HELP FROM BSC_KPI_ANALYSIS_MEASURES_TL t WHERE t.LANGUAGE = :lang AND t.INDICATOR = :indicator;
- SELECT b.*, t.NAME FROM BSC_KPI_ANALYSIS_MEASURES_B b LEFT JOIN BSC_KPI_ANALYSIS_MEASURES_TL t ON t.ANALYSIS_OPTION2 = b.ANALYSIS_OPTION2 AND t.LANGUAGE = :lang;
Given the obsolete status and the "not implemented" note, confirm actual object existence in the target database before relying on these queries in production.
Related Objects
- BSC_KPI_ANALYSIS_MEASURES_B — the base table referenced via ANALYSIS_OPTION2; the primary parent of the translated rows.
- BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION0, ANALYSIS_OPTION1, ANALYSIS_OPTION2, SERIES_ID, INDICATOR — composite FK columns that bind the translation to specific analysis-measure and series identifiers.
- The KPI analysis and scorecard presentation layers within the BSC module, which consume translated measure names and help text.
Because the BSC module is documented as obsolete, dependent views and reports should be validated against the installed 12.1.1 or 12.2.2 instance before use.
-
Translated analysis measures information
-
Translated analysis measures information
Not implemented in this database·Explore BSC module →
-
APPS.BSC_KPI_ANALYSIS_MEASURES_VL·↳ BSC_KPI_ANALYSIS_MEASURES_B·↳ BSC_KPI_ANALYSIS_MEASURES_TL·Explore BSC module →
-
Not implemented in this database·Explore BSC module →
-
Analysis measures information
Not implemented in this database·Explore BSC module →
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
PACKAGE: APPS.BSC_TEMPLATE 12.1.1
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.BSC_TAB_TPLATE 12.1.1