Search Results kpi_color

Overview

The BSC_SYS_KPI_COLORS table is a core repository within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) module, versions 12.1.1 and 12.2.2. It serves as the system table for persisting the visual and analytical state of Key Performance Indicators (KPIs) as rendered within the application's user interface. Specifically, it stores the calculated color-coding, actual and budget data values, and trend information for each KPI, segmented by a specific tab, period, and up to eight dimension levels. This table is essential for the "List Button" functionality, enabling users to view performance metrics with conditional formatting that reflects status against targets, thereby facilitating data-driven decision-making.

Key Information Stored

The table's structure is designed to uniquely identify a KPI instance and store its runtime evaluation. The primary key columns (TAB_ID, INDICATOR, KPI_MEASURE_ID, DIM_LEVEL1 through DIM_LEVEL8, PERIOD_ID) define the precise context of the scorecard view. The core data columns include KPI_COLOR and USER_COLOR for system-determined and user-customized visual indicators, and ACTUAL_DATA and BUDGET_DATA for the numerical values. Critically, the TREND_FLAG column, noted in the user's search, stores a numeric value representing the directional trend (e.g., improving, declining, static) for the KPI within that specific context. The KPI_TREND and KPI_MEASURE_ID columns provide links to trend definitions and specific measure types.

Common Use Cases and Queries

This table is primarily queried for rendering performance dashboards and generating analytical reports. A common use case is extracting the performance status of all KPIs for a specific scorecard tab and period to power a custom report. The following query pattern retrieves key performance data, including the trend flag, for analysis:

• SELECT TAB_ID, INDICATOR, KPI_MEASURE_ID, ACTUAL_DATA, BUDGET_DATA, KPI_COLOR, TREND_FLAG FROM BSC.BSC_SYS_KPI_COLORS WHERE TAB_ID = :p_tab_id AND PERIOD_ID = :p_period_id AND DIM_LEVEL1 = :p_dim_val;

Another critical scenario involves troubleshooting or auditing the color logic applied to KPIs, which would involve joining this table with other BSC definition tables to compare system-calculated colors (KPI_COLOR) against business rules.

Related Objects

As per the dependency information, the BSC_SYS_KPI_COLORS table is referenced by an APPS synonym, BSC_SYS_KPI_COLORS, which is the standard access point for application code. While the provided metadata does not list specific referencing objects, in the BSC module architecture, this table is intrinsically linked to KPI and measure definition tables (such as BSC_KPIS_B and BSC_SYS_KPI_MEASURES) and periodicity tables (BSC_SYS_PERIODS). The unique index BSC_SYS_KPI_COLORS_U1 enforces data integrity for the primary key columns on the APPS_TS_TX_IDX tablespace.