Results for “bsc_kpi_defaults_b”

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

Overview

BSC_KPI_DEFAULTS_B is a base table in the Oracle E-Business Suite Balanced Scorecard (BSC) module, which is classified as obsolete in ETRM 12.1.1 and 12.2.2. The table stores indicator (KPI) definition data and display defaults used to populate the "information box" presented on a Balanced Scorecard tab. It defines how a given KPI is rendered—color thresholds, numeric formatting, dimensional context, and the source measure—so that the Scorecard UI can present a consistent, pre-configured view to end users.

The table is not implemented in the reference database documented by ETRM, and its parent product has been deprecated. Nonetheless, it remains a documented object with a defined physical schema of 23 columns owned by the BSC schema. From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification: the table carries descriptive attributes (format, colors, dimensional values, audit columns) keyed by business identifiers, rather than acting as a pure hub or link.

Key Information Stored

The primary key of the table is BSC_KPI_DEFAULTS_B_PK, a composite key defined over (INDICATOR, TAB_ID). A unique index, BSC_KPI_DEFAULTS_B_U1, is also documented over (TAB_ID, INDICATOR), reinforcing that the combination of a Scorecard tab and a KPI indicator is the business-key candidate for uniqueness. The most significant columns include:

• TAB_ID – Identifies the Scorecard tab to which the KPI default belongs; part of the composite primary key.
• INDICATOR – The KPI identifier; part of the composite primary key and the natural business key.
• FORMAT_MASK – Numeric or date formatting applied when the KPI value is displayed.
• COLOR_METHOD – Determines how color coding is applied to the indicator.
• COLOR_LEVEL1 through COLOR_LEVEL4 – Threshold color values used for conditional visual formatting.
• DIM_SET_ID – References the dimensional set used to contextualize the KPI.
• DIM_LEVEL1_VALUE through DIM_LEVEL8_VALUE – Fixed dimensional member values for up to eight levels.
• MEASURE_SOURCE – Identifies the source measure from which the KPI value is derived.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard EBS audit columns.

Common Use Cases and Queries

Typical usage involves resolving the display configuration for a KPI on a specific Scorecard tab, or reporting on the color thresholds and dimensional defaults configured across the Scorecard. A representative join retrieves the descriptive translation alongside the base defaults:

• Query: SELECT b.TAB_ID, b.INDICATOR, b.FORMAT_MASK, b.COLOR_METHOD, t.NAME FROM BSC_KPI_DEFAULTS_B b, BSC_KPI_DEFAULTS_TL t WHERE b.INDICATOR = t.INDICATOR AND b.TAB_ID = t.TAB_ID;
• Lookup by business key: filter on INDICATOR = :indicator AND TAB_ID = :tab_id.
• Reporting on dimensional defaults: retrieve DIM_LEVEL1_VALUE through DIM_LEVEL8_VALUE filtered by DIM_SET_ID.
• Audit analysis: use LAST_UPDATE_DATE and LAST_UPDATED_BY to trace configuration changes.

Related Objects

Referential integrity and translation relationships connect BSC_KPI_DEFAULTS_B to several BSC objects. The most significant dependencies include:

• BSC_KPI_DEFAULTS_TL – Translation table referencing the base table via INDICATOR and TAB_ID.
• BSC_TAB_INDICATORS – Referenced by the foreign key on BSC_KPI_DEFAULTS_B.TAB_ID.
• BSC_KPI_DIM_SETS_TL – Referenced by the foreign key on BSC_KPI_DEFAULTS_B.DIM_SET_ID.

Because the BSC module is obsolete, no active APIs or concurrent programs depend on this table in current releases; it is retained only for historical and reference purposes.