Search Results bsc_kpi_defaults_b_pk

Overview

The BSC_KPI_DEFAULTS_B table is a core data repository within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It functions as the base table for storing default indicator data, specifically for populating the information box component of the application. This table is central to the configuration and management of Key Performance Indicators (KPIs), serving as the transactional anchor for default KPI settings that are linked to specific scorecard tabs and indicator definitions. Its role is to establish and maintain the foundational, non-translatable attributes of a KPI's default presentation and behavior within a given tab context.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key relationships. The primary columns include INDICATOR and TAB_ID, which together uniquely identify a default KPI record by linking it to a specific indicator within a specific scorecard tab. Another critical column is DIM_SET_ID, which references a default dimension set, defining the hierarchical context (e.g., Organization, Time, Product) for the KPI's data. While the provided metadata does not list all columns, the table typically stores configuration data such as default calculation methods, display formats, target values, and thresholds that govern how the KPI is initially presented and evaluated in its associated tab.

Common Use Cases and Queries

This table is primarily accessed during the setup and administration of Balanced Scorecards. Common operational scenarios include the initial configuration of a KPI across different dashboard tabs, the mass update of default properties for a group of indicators, and the diagnostic tracing of KPI data issues. A typical query involves joining to its related tables to retrieve a comprehensive default setup for reporting or data validation.

Sample Query Pattern:
SELECT b.INDICATOR, b.TAB_ID, b.DIM_SET_ID, tl.NAME
FROM BSC_KPI_DEFAULTS_B b,
     BSC_KPI_DEFAULTS_TL tl
WHERE b.INDICATOR = tl.INDICATOR
AND b.TAB_ID = tl.TAB_ID
AND tl.LANGUAGE = USERENV('LANG')
AND b.INDICATOR = :p_indicator_id;

Related Objects

The BSC_KPI_DEFAULTS_B table is integral to a tightly defined schema within the BSC module, with the following documented relationships:

• Primary Key: BSC_KPI_DEFAULTS_B_PK on columns (INDICATOR, TAB_ID).
• Foreign Keys (Outgoing References):
  • References BSC_TAB_INDICATORS via column TAB_ID.
  • References BSC_KPI_DIM_SETS_TL via column DIM_SET_ID (and INDICATOR).
• Foreign Keys (Incoming References):
  • Referenced by BSC_KPI_DEFAULTS_TL (the translation table) via columns (INDICATOR, TAB_ID). This table holds the language-specific descriptive content for the defaults.