Results for “weighted_average”

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

Overview

BSC_KPIS_B is the base (non-translated) table that stores Key Performance Indicator definitions for the Oracle E-Business Suite Balanced Scorecard module (BSC). It resides in the BSC schema and is validated in both 12.1.1 and 12.2.2 releases. Each row represents a single KPI — a measurable performance metric that can be assembled into scorecards, cause-and-effect maps, and analytic groups. The table holds the structural and behavioral attributes of a KPI (indicator type, configuration type, periodicity, ownership flags, publishing and sharing settings, color and trend configuration), while descriptive text is stored separately in the translation table BSC_KPIS_TL. Because it anchors a wide network of dependent child tables and carries a self-referencing foreign key, the table behaves as the central entity for KPI metadata in Balanced Scorecard.

From a Data Vault modeling perspective, the FK topology suggests BSC_KPIS_B functions as a hub — a business-key-oriented core entity that is referenced by many satellites and link-style tables. The single-column primary key INDICATOR combined with the unique index BSC_KPIS_B_U1 on the same column supports this hub interpretation, though in native EBS terms it is simply the master KPI definition table.

Key Information Stored

BSC_KPIS_B has 26 documented columns. The most important are:

• INDICATOR — The primary key (BSC_KPIS_B_PK) and the single business-key candidate enforced by unique index BSC_KPIS_B_U1. It identifies each KPI and is the join column used by virtually every related table.
• SHORT_NAME — A concise label for the indicator, useful for list reports and picklists.
• CSF_ID — Links the KPI to its Critical Success Factor context.
• IND_GROUP_ID — Grouping/classification of the indicator.
• INDICATOR_TYPE and CONFIG_TYPE — Define the category and configuration behavior of the KPI.
• PERIODICITY_ID — Foreign key to BSC_SYS_PERIODICITIES, determining the measurement frequency (for example, monthly or quarterly).
• SOURCE_INDICATOR — Self-referencing foreign key to BSC_KPIS_B, used when a KPI is derived from another indicator (prototype relationships).
• PROTOTYPE_FLAG — Marks whether the row is a template indicator rather than an active scorecard KPI.
• PUBLISH_FLAG and SHARE_FLAG — Control visibility and distribution of the KPI across scorecards and users.
• DISP_ORDER — Display sequencing.
• APPLY_COLOR_FLAG, PROTOTYPE_COLOR, PROTOTYPE_COLOR_ID, COLOR_ROLLUP_TYPE, and WEIGHTED_COLOR_METHOD — Govern conditional formatting and color logic for KPI status.
• PROTOTYPE_TREND_ID — Drives trend indicator configuration.
• EDW_FLAG and CALENDAR_ID — Support enterprise data warehouse extraction and calendar assignment.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include generating KPI catalogs, auditing KPI configuration, and extracting definitions into reporting or EDW layers. A basic listing of published KPIs with their periodicity can be written as:

• SELECT k.INDICATOR, k.SHORT_NAME, p.PERIODICITY_NAME FROM BSC.BSC_KPIS_B k, BSC.BSC_SYS_PERIODICITIES p WHERE k.PERIODICITY_ID = p.PERIODICITY_ID AND k.PUBLISH_FLAG = 'Y';
• To find derived KPIs: SELECT INDICATOR, SOURCE_INDICATOR FROM BSC.BSC_KPIS_B WHERE SOURCE_INDICATOR IS NOT NULL;
• To retrieve translated descriptions, join BSC_KPIS_TL on INDICATOR.

Color-rule reporting frequently filters on APPLY_COLOR_FLAG and COLOR_ROLLUP_TYPE to reconcile scorecard display behavior. Data warehouse loads use EDW_FLAG to identify KPIs eligible for extraction.

Related Objects

The following objects are the most significant dependents and references, joined on the documented columns:

• BSC_KPIS_TL.INDICATOR — Translated names and descriptions; the primary companion table for display text.
• BSC_SYS_PERIODICITIES — Referenced via BSC_KPIS_B.PERIODICITY_ID for measurement frequency.
• BSC_KPI_CALCULATIONS.INDICATOR — Calculation definitions tied to each KPI.
• BSC_KPI_CAUSE_EFFECT_RELS — Cause-and-effect strategy map relationships, via CAUSE_INDICATOR and EFFECT_INDICATOR.
• BSC_KPI_ANALYSIS_GROUPS.INDICATOR and BSC_KPI_ANALYSIS_MEASURES_B.INDICATOR — Analytic grouping and measure assignments.
• BSC_KPI_TREE_NODES_B.INDICATOR — Placement of KPIs in scorecard hierarchies.
• BSC_KPI_PERIODICITIES.INDICATOR and BSC_KPI_MM_CONTROLS.INDICATOR — Periodicity and measure-management control records.
• BSC_KPI_PROPERTIES.INDICATOR, BSC_KPI_COMMENTS.INDICATOR, and BSC_TAB_INDICATORS.INDICATOR — Properties, commentary, and tab-level assignments.
• BSC_KPI_DIM_SETS_TL.INDICATOR, BSC_KPI_SUBTITLES_TL.INDICATOR, and BSC_KPI_SHELL_CMDS_TL.INDICATOR — Dimension sets, subtitles, and shell command translations.
• BSC_KPIS_B.SOURCE_INDICATOR — Self-reference for prototype/derived indicator lineage.