Search Results bsc_kpi_calculations




Overview
Explore in AI Chat

Overview

The BSC_KPI_CALCULATIONS table is a core data object within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It functions as a junction or mapping table that establishes the relationship between Key Performance Indicators (KPIs) and the specific calculation logic used to derive their values. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is essential for the configuration and execution of performance measurement frameworks, enabling administrators to link a defined KPI to one or more predefined calculation formulas stored in the system.

Key Information Stored

The table's structure is defined by a composite primary key, which consists of two critical columns. The CALCULATION_ID column stores a unique identifier that references a specific calculation formula defined in the BSC_SYS_CALCULATIONS table. The INDICATOR column stores the identifier for a specific Key Performance Indicator, which is a foreign key to the BSC_KPIS_B table. Together, each record in this table represents a single, explicit assignment of a calculation method to a KPI. The table does not store the calculation logic itself but serves as the critical link between the KPI definition and its computational engine.

Common Use Cases and Queries

This table is primarily accessed for configuration, auditing, and troubleshooting within the Balanced Scorecard setup. A common administrative task is to review all calculations assigned to a particular KPI. The following query pattern illustrates this, joining to the relevant descriptive tables:

  • SELECT kpi.NAME, calc.CALCULATION_NAME FROM BSC_KPI_CALCULATIONS kpic INNER JOIN BSC_KPIS_B kpi ON kpic.INDICATOR = kpi.INDICATOR INNER JOIN BSC_SYS_CALCULATIONS calc ON kpic.CALCULATION_ID = calc.CALCULATION_ID WHERE kpi.NAME = '&KPI_NAME';

Conversely, identifying all KPIs that utilize a specific calculation formula is another key reporting use case, vital for assessing the impact of changing a calculation definition. Data integrity checks often involve queries to find orphaned records where either the KPI or the calculation definition no longer exists in their respective source tables.

Related Objects

The BSC_KPI_CALCULATIONS table sits at the center of a defined relational model within the BSC schema, as documented in the provided metadata.

  • Referenced Tables (Foreign Keys):
    • BSC_KPIS_B: Linked via the INDICATOR column. This is the base table for KPI definitions.
    • BSC_SYS_CALCULATIONS: Linked via the CALCULATION_ID column. This table stores the master list of available calculation formulas.
  • Referencing Table (Child Table):
    • BSC_KPI_CALCULATIONS_USER: This table references BSC_KPI_CALCULATIONS using both the INDICATOR and CALCULATION_ID columns, typically to store user-specific overrides or notes related to a specific KPI-calculation assignment.

The primary key constraint BSC_KPI_CALCULATIONS_PK on (CALCULATION_ID, INDICATOR) enforces uniqueness for each KPI-calculation combination.