Search Results bsc_kpi_periodicities




Overview
Explore in AI Chat

Overview

The BSC_KPI_PERIODICITIES table is a core data structure within the Oracle E-Business Suite Balanced Scorecard (BSC) module, versions 12.1.1 and 12.2.2. It serves as a junction or intersection table that defines the valid measurement frequencies (periodicities) associated with specific Key Performance Indicators (KPIs). Its primary role is to enforce the business rule that a single KPI can be measured and reported on multiple time-based schedules, such as monthly, quarterly, and annually. This table is essential for configuring the data collection, calculation, and reporting cadence for each strategic metric in the Balanced Scorecard framework.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two critical foreign key columns. The INDICATOR column stores the unique identifier for a KPI, linking it to the base definition in the BSC_KPIS_B table. The PERIODICITY_ID column stores the identifier for a specific time frequency, such as 'MONTH' or 'QUARTER', linking it to the master list of available periodicities in the BSC_SYS_PERIODICITIES table. Together, each row in this table represents an authorized periodicity for a given KPI. While the provided metadata focuses on keys, other columns likely exist to store control attributes like effective dates or statuses for each KPI-periodicity combination.

Common Use Cases and Queries

A primary use case is the administrative setup and validation of KPI measurement schedules. Reports and data entry forms rely on this table to present users with the list of valid periods for data input for a specific indicator. For instance, a data load interface would query this table to verify if a submitted data point for KPI 'X' for a 'WEEKLY' period is permissible. A common analytical query involves joining this table to related master tables to generate a list of all KPIs and their configured reporting frequencies.

SELECT kpi.NAME,
       per.NAME PERIODICITY
FROM   BSC_KPI_PERIODICITIES kp
       JOIN BSC_KPIS_B kpi ON kp.INDICATOR = kpi.INDICATOR
       JOIN BSC_SYS_PERIODICITIES per ON kp.PERIODICITY_ID = per.PERIODICITY_ID
WHERE  kpi.STATUS = 'A'
ORDER BY kpi.NAME;

Related Objects

The BSC_KPI_PERIODICITIES table sits at the center of a key data model, with documented relationships to several other BSC tables.

  • Referenced Tables (Foreign Key Sources):
    • BSC_KPIS_B: The INDICATOR column references this table to ensure every periodicity is assigned to a valid, defined KPI.
    • BSC_SYS_PERIODICITIES: The PERIODICITY_ID column references this table to ensure the frequency is a valid system-defined periodicity.
  • Referencing Tables (Foreign Key Targets):
    • BSC_KPI_DATA_TABLES: References this table via INDICATOR and PERIODICITY_ID, linking the periodicity configuration to the physical tables where actual KPI performance data is stored.
    • BSC_KPI_PERIODICITIES_USER: References this table via INDICATOR and PERIODICITY_ID, likely storing user-specific views or security settings for a KPI's periodicity.