Search Results bsc_tab_ind_v

Overview

BSC_TAB_IND_V is a database view shipped with the Balanced Scorecard (BSC) module of Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. The view returns the indicator groups associated with a TAB, effectively joining the TAB-to-indicator mapping onto the KPI definition layer so that each TAB/indicator pairing is enriched with the group identifier, descriptive name and source-indicator attributes of the underlying KPI. In practical terms, the view answers the question "which indicator groups draw their indicators from a given TAB?"

The object sits in the BSC reporting and integration layer rather than in the transactional core. Reporting components, diagnostic queries and any custom integration that must enumerate indicator-group membership sourced from a TAB can query the view instead of re-deriving the join manually. Per the supplied ETRM metadata, the product designation carries the qualifier "Obsolete", and the view is recorded as "Not implemented in this database". Consequently, the view should be treated as a legacy artifact: it remains valuable for understanding historical data models and for interpreting documentation, but it cannot be relied upon to exist in every 12.1.1 or 12.2.2 environment.

Underlying Base Objects

The view text is defined over two objects:

• BSC_TAB_INDICATORS TK — the TAB-to-indicator association table. Its columns used here are TAB_ID and INDICATOR. This is the driving table, supplying the TAB context.
• BSC_KPIS_VL SK — the translatable (VL, "view language") KPI definition view. Its columns used here are INDICATOR, IND_GROUP_ID, NAME, SHARE_FLAG and SOURCE_INDICATOR.

The join is a simple equijoin on the indicator key: SK.INDICATOR = TK.INDICATOR. The documented "Referenced base objects" entry is empty and the owner is not recorded, so the definitive base-table lineage of BSC_KPIS_VL itself must be confirmed against the specific environment. Because BSC_KPIS_VL is a translatable view, the NAME returned is language-dependent, resolved according to the session's language settings.

Key Columns

• TAB_ID — identifier of the TAB from which the indicator is drawn; the grouping key that gives the view its purpose.
• IND_GROUP_ID — the indicator group to which the indicator belongs; this is the attribute that makes the view "return groups that have indicators from a TAB".
• INDICATOR — the KPI identifier joining the TAB mapping to the KPI definition.
• NAME — the translated display name of the indicator, sourced from BSC_KPIS_VL.
• SHARE_FLAG — flag indicating whether the indicator/group is shared across scorecards or contexts.
• SOURCE_INDICATOR — identifies the originating indicator when an indicator is derived from, or references, another indicator. This column is of particular interest to users searching for "source_indicator", since it exposes indicator provenance directly rather than requiring navigation through the KPI definition layer.

Common Use Cases and Queries

The primary use case is enumerating indicator groups and their indicators for a specific TAB, including the source-indicator lineage. A representative query is:

• SELECT TAB_ID, IND_GROUP_ID, INDICATOR, NAME, SHARE_FLAG, SOURCE_INDICATOR FROM BSC_TAB_IND_V WHERE TAB_ID = :p_tab_id ORDER BY IND_GROUP_ID, NAME;
• To isolate derived indicators: SELECT INDICATOR, NAME, SOURCE_INDICATOR FROM BSC_TAB_IND_V WHERE SOURCE_INDICATOR IS NOT NULL;
• To identify shared indicators within a TAB: SELECT IND_GROUP_ID, INDICATOR, NAME FROM BSC_TAB_IND_V WHERE TAB_ID = :p_tab_id AND SHARE_FLAG = 'Y';

Before deploying any of these queries, confirm the view's presence, since the metadata states it is not implemented in the reference database. Where BSC_TAB_IND_V is absent, the equivalent result set can be reconstructed by joining BSC_TAB_INDICATORS to BSC_KPIS_VL on INDICATOR.