Search Results bsc_kpi_series_colors




Overview
Explore in AI Chat

Overview

The table BSC_KPI_SERIES_COLORS is a data repository within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) module, which is designated as obsolete in releases 12.1.1 and 12.2.2. Its primary function is to store the color mappings for data series and benchmarks associated with Key Performance Indicators (KPIs). This table enables the visual customization of scorecard charts and reports by defining specific colors for different data series (e.g., actuals, targets, forecasts) and benchmark lines, thereby enhancing data interpretation and graphical presentation. Its role is integral to the backend configuration of the BSC module's analytical and reporting capabilities.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key columns linking to master data. The primary key, BSC_KPI_SERIES_COLORS_PK, consists of the columns ANALYSIS_OPTION0, ANALYSIS_OPTION1, BM_ID, INDICATOR, SERIES_ID, and ANALYSIS_OPTION2. These columns collectively identify a unique color assignment for a specific KPI series. The INDICATOR column stores the identifier for the KPI itself. The SERIES_ID identifies the specific data series (like "Actual" or "Plan") for the KPI. The BM_ID column holds the identifier for a benchmark, linking to the BSC_SYS_BENCHMARKS_B table. The ANALYSIS_OPTION columns (0, 1, and 2) are dimensional keys that link to the BSC_KPI_ANALYSIS_MEASURES_B table, allowing color rules to be applied within specific analytical contexts or breakdowns.

Common Use Cases and Queries

A primary use case involves generating or customizing the color scheme for a Balanced Scorecard report. Administrators or integration processes would query this table to retrieve or set the display color for a KPI's data series under a given analysis dimension. A typical query would join to the KPI and benchmark tables to build a complete presentation rule set. For instance, to audit color assignments for a specific indicator, one might use:

SELECT s.INDICATOR, s.SERIES_ID, s.BM_ID, s.ANALYSIS_OPTION0, s.ANALYSIS_OPTION1, s.ANALYSIS_OPTION2
FROM BSC_KPI_SERIES_COLORS s
WHERE s.INDICATOR = :p_indicator_id;

Given the module's obsolete status, common operations would be limited to maintenance, data migration for upgrades, or support for legacy custom reports that directly reference this table structure.

Related Objects

BSC_KPI_SERIES_COLORS has documented foreign key relationships with two core BSC tables, as per the provided metadata:

  • BSC_KPI_ANALYSIS_MEASURES_B: The columns ANALYSIS_OPTION0, ANALYSIS_OPTION1, ANALYSIS_OPTION2, INDICATOR, and SERIES_ID in BSC_KPI_SERIES_COLORS reference this table. This relationship ties the color configuration to the specific analysis measures and dimensional breakdowns defined for a KPI.
  • BSC_SYS_BENCHMARKS_B: The BM_ID column in BSC_KPI_SERIES_COLORS references this table. This links the color entry to a defined benchmark, allowing benchmarks to be rendered in a distinct color on charts and graphs.

The table itself is referenced by its primary key constraint (BSC_KPI_SERIES_COLORS_PK), which enforces uniqueness for the combination of the listed key columns.