Results for “bsc_sys_mm_controls_tl”

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

Overview

BSC_SYS_MM_CONTROLS_TL is a translated (TL) table in the BSC schema, owned by the Oracle Balanced Scorecard module. It stores language-specific, multilingual metadata for the multimedia remote controls rendered within the Balanced Scorecard user interface. Each row describes the display text and behavior attributes of a control — such as a button — associated with multimedia content shown in scorecard regions. The "_TL" suffix indicates that the table holds translatable columns, meaning one logical control can have multiple rows, one per installed language, keyed by the combination of the control identifier and the language code.

Under a heuristic Data Vault classification derived from its foreign key structure, this object is hub-leaning. This classification is offered as a modeling suggestion rather than a prescriptive design: the table behaves as a central reference for control definitions that are referenced by dependent detail tables, which is consistent with hub semantics. In practical EBS terms, it is a language-dependent configuration table that anchors the relationship between scorecard multimedia controls and their localized presentation strings.

Key Information Stored

The table has six documented columns. The most significant are the following:

• BUTTON_ID — The primary identifier for the multimedia remote control. It forms part of the primary key BSC_SYS_MM_CONTROLS_TL_PK and is the column referenced by dependent tables.
• LANGUAGE — The language code identifying the locale for this row. Together with BUTTON_ID, it composes the unique index BSC_SYS_MM_CONTROLS_TL_U1, which represents the business-key candidate for the table.
• SOURCE_LANG — Indicates the source language from which the translated content was derived, supporting Oracle's standard multilanguage translation framework.
• NAME — The localized display name of the control, presented to the user in the scorecard interface.
• HELP — The localized help or tooltip text associated with the control.
• COMMAND — The localized command or action text associated with the control.

The surrogate primary key is defined through BUTTON_ID in the constraint BSC_SYS_MM_CONTROLS_TL_PK, while BSC_SYS_MM_CONTROLS_TL_U1 (BUTTON_ID, LANGUAGE) is the business-key candidate that enforces uniqueness per language. Note that the primary key constraint is documented against BUTTON_ID alone, whereas the unique index spans both BUTTON_ID and LANGUAGE; the unique index is the more precise business identifier for a translated row.

Common Use Cases and Queries

Typical usage centers on retrieving the correct localized label for a multimedia control, either for display rendering or for reporting on scorecard configuration. A common pattern joins the translated table to its base or dependent objects while filtering on the session language:

• Fetching localized control text for a specific language:

SELECT button_id, language, name, help, command
FROM bsc.bsc_sys_mm_controls_tl
WHERE language = USERENV('LANG');

• Auditing completeness of translations across languages by grouping on BUTTON_ID and counting distinct LANGUAGE values.
• Identifying missing or stale translations by comparing SOURCE_LANG against the active language rows.
• Reporting on all controls referenced by BSC_KPI_MM_CONTROLS to verify that each dependent control has a corresponding translated definition.

These queries support interface rendering, translation audits, and configuration validation. Direct DML against the table is not recommended; changes should flow through the Balanced Scorecard application or its supported translation utilities.

Related Objects

The following objects are most significant in relation to this table:

• BSC_KPI_MM_CONTROLS — The principal dependent table. Its BUTTON_ID column carries a foreign key referencing BSC_SYS_MM_CONTROLS_TL, linking KPI multimedia controls to their translated control definitions.
• BSC_SYS_MM_CONTROLS_TL_PK — The primary key constraint on BUTTON_ID.
• BSC_SYS_MM_CONTROLS_TL_U1 — The unique index on (BUTTON_ID, LANGUAGE), serving as the business-key candidate.

The join to BSC_KPI_MM_CONTROLS on BUTTON_ID is the primary documented relationship and the most common integration point for querying and reporting on multimedia remote control configuration within Oracle Balanced Scorecard.