Results for “bsc_kpi_mm_controls”

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

Overview

BSC_KPI_MM_CONTROLS is a configuration table within the Oracle E-Business Suite Balanced Scorecard (BSC) module. Its documented description is "Multimedia control remote information," indicating that it stores the association between Key Performance Indicators (KPIs) defined in the Balanced Scorecard and multimedia control elements used to render interactive or rich-media content on scorecard dashboards. The object resides in the BSC schema and is documented in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. The product is explicitly flagged as obsolete in the ETRM metadata, and the object is marked "Not implemented in this database," meaning it is not physically instantiated in typical 12.1.1 or 12.2.2 instances and should be treated as a legacy or dormant artifact from earlier Balanced Scorecard releases.

Under the heuristic Data Vault classification mined from the foreign key structure, this table is modeled as a link. This reflects its structural role: it resolves a many-to-many style association between an indicator (KPI) and a multimedia button, carrying no independent descriptive attributes other than the command value. Accordingly, it is best treated as an associative link table rather than a hub or satellite.

Key Information Stored

The documented schema contains three columns, and the primary key is a composite: BSC_KPI_MM_CONTROLS_PK (BUTTON_ID, INDICATOR). A second unique index, BSC_KPI_MM_CONTROLS_U1 (INDICATOR, BUTTON_ID), covers the same column pair in reversed order — a business-key candidate that confirms the pairing is unique regardless of ordering.

• INDICATOR — Foreign key referencing BSC_KPIS_B, identifying the Balanced Scorecard KPI to which the multimedia control applies.
• BUTTON_ID — Foreign key referencing BSC_SYS_MM_CONTROLS_TL, identifying the multimedia control (button) definition, whose display text is language-dependent in the TL table.
• COMMAND — The only non-key descriptive column, holding the action or command string executed when the associated multimedia control is activated for the indicator.

Because the primary key is composite and built entirely from the two foreign keys, there is no independent surrogate identifier; the business key and the primary key coincide semantically.

Common Use Cases and Queries

Because the table is marked not implemented, production queries against it are unlikely to return data. Its principal use cases are historical analysis, upgrade assessment, and schema-reference work when migrating from older BSC releases or reviewing legacy customizations. A typical lookup retrieves the multimedia command configured for a given KPI:

• SELECT c.indicator, c.button_id, c.command FROM bsc.bsc_kpi_mm_controls c WHERE c.indicator = :p_indicator;
• Joining to the KPI base table to resolve indicator names: SELECT k.indicator, c.command FROM bsc.bsc_kpi_mm_controls c, bsc.bsc_kpis_b k WHERE c.indicator = k.indicator;
• Resolving button display text through the translation table: SELECT c.indicator, t.button_name FROM bsc.bsc_kpi_mm_controls c, bsc.bsc_sys_mm_controls_tl t WHERE c.button_id = t.button_id AND t.language = USERENV('LANG');

Reporting scenarios include auditing which KPIs were linked to interactive controls before an upgrade, and confirming that no orphaned multimedia references remain after BSC decommissioning.

Related Objects

• BSC_KPIS_B — Base KPI table; joined on BSC_KPI_MM_CONTROLS.INDICATOR = BSC_KPIS_B.INDICATOR.
• BSC_SYS_MM_CONTROLS_TL — Translated multimedia control definitions; joined on BSC_KPI_MM_CONTROLS.BUTTON_ID = BSC_SYS_MM_CONTROLS_TL.BUTTON_ID.
• BSC_SYS_MM_CONTROLS_B — Base (non-translated) multimedia control table, the parent of the TL table, relevant when reconstructing the full control hierarchy.
• BSC_KPIS_TL — Translated KPI names, used to present human-readable indicator labels alongside the link rows.
• BSC_KPI_MM_CONTROLS_PK / _U1 — The primary key constraint and unique index enforcing uniqueness of the (BUTTON_ID, INDICATOR) pairing.

Collectively, these objects define the multimedia-to-KPI associations that the Balanced Scorecard engine once used to drive interactive dashboard behavior.