Search Results bsc_tab_indicators

Overview

The BSC_TAB_INDICATORS table is a core data structure within the now-obsolete Balanced Scorecard (BSC) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. Its primary function is to manage the assignment of Key Performance Indicators (KPIs) to specific tabs or sections within the Balanced Scorecard user interface. This mapping is essential for organizing and presenting performance metrics in a structured, user-defined manner, allowing different indicators to be grouped logically for analysis and reporting. As indicated by its "Obsolete" status, this table and the associated BSC module represent legacy functionality that is no longer under active development by Oracle, though it may still be present in existing installations for backward compatibility.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the fundamental relationship it manages. The two critical columns are INDICATOR and TAB_ID. The INDICATOR column stores the unique identifier for a specific KPI, linking to the core KPI definition tables. The TAB_ID column stores the identifier for a user interface tab or container within the scorecard. Together, each record establishes that a given indicator is visible and configured within a specific tab. While the provided metadata does not list additional descriptive columns, the table's purpose is to maintain this many-to-many relationship between performance indicators and their presentation groups.

Common Use Cases and Queries

The primary use case involves querying which KPIs are assigned to a particular scorecard tab for configuration, auditing, or migration purposes. A typical query would join this table with KPI master data to generate a report of tab contents. For instance, to list all indicators within a specific tab, one might use:

• SELECT ti.indicator, k.name FROM bsc_tab_indicators ti JOIN bsc_kpis_b k ON ti.indicator = k.indicator WHERE ti.tab_id = :p_tab_id;

Conversely, to find all tabs containing a specific KPI, the query would be:

• SELECT tab_id FROM bsc_tab_indicators WHERE indicator = :p_indicator;

Administrative use cases include validating data integrity by checking for orphaned records where the INDICATOR or TAB_ID no longer exists in their respective parent tables.

Related Objects

As documented in the ETRM metadata, BSC_TAB_INDICATORS maintains defined foreign key relationships with several other BSC tables, centralizing its role in the schema. The primary key (INDICATOR, TAB_ID) is referenced by child tables for default settings and display configurations. The documented relationships are:

• BSC_KPIS_B: The INDICATOR column in BSC_TAB_INDICATORS references BSC_KPIS_B.INDICATOR, ensuring every assigned indicator is a valid KPI.
• BSC_KPI_DEFAULTS_B: This table holds default values for KPIs per tab and references the composite key of BSC_TAB_INDICATORS (TAB_ID, INDICATOR).
• BSC_SYS_KPI_COLORS: This table, which likely manages threshold-based color coding for indicators, also references the composite key (TAB_ID, INDICATOR) from BSC_TAB_INDICATORS.

These relationships confirm that BSC_TAB_INDICATORS serves as a master junction table, linking KPIs to tabs, with subsidiary tables then storing tab-specific configurations for those KPI assignments.