Search Results share_flag




Overview
Explore in AI Chat

Overview

BSC_TAB_IND_V is a view owned by the APPS schema in Oracle E-Business Suite, registered under the internal design data identifier BSC.BSC_TAB_IND_V. It is classified as an internal view ("View Type: Internal") and carries the Oracle Internal Use Only warning, meaning Oracle does not support direct access to it except from standard Oracle Applications programs. Its status is VALID in both 12.1.1 and 12.2.2.

Functionally, the view presents the mapping between scorecard tab definitions and the indicators (KPIs) assigned to those tabs within the Oracle Balanced Scorecard module. It exposes the tab identifier, the indicator group, the indicator code, the indicator name, the share flag, and the source indicator flag. Because it joins tab-indicator assignments with the KPI value set list, it serves as a reporting and integration surface for consumers that need to read tab-to-indicator relationships without navigating the raw intersection table directly.

Underlying Base Objects

The ETRM metadata documents the following dependencies for APPS.BSC_TAB_IND_V:

  • APPS.BSC_KPIS_VL — the KPI value set list, supplying the translated NAME value for the indicator.
  • APPS.BSC_TAB_INDICATORS — the base intersection table holding tab, indicator group, indicator, share flag, and source indicator assignments.

No database object is documented as referencing APPS.BSC_TAB_IND_V; it is a terminal consumer view within the BSC schema and is not itself a dependency for other database objects. The view therefore functions as a read-only projection over the assignment table, enriched with descriptive KPI information.

Key Columns

  • TAB_ID (NUMBER) — the tab identifier; identifies the scorecard tab to which an indicator is assigned.
  • IND_GROUP_ID (NUMBER) — the indicator group identifier, grouping related indicators within the tab context.
  • INDICATOR (NUMBER) — the indicator code, the key that links to KPI definitions.
  • NAME (VARCHAR2(150)) — the indicator name, sourced from BSC_KPIS_VL.
  • SHARE_FLAG (NUMBER) — indicates whether the indicator is shared across tabs or users.
  • SOURCE_INDICATOR (NUMBER) — identifies the originating or source indicator, used where an indicator is derived from or references another indicator.

The column the user searched for, SOURCE_INDICATOR, is exposed directly and is central to identifying derivation chains between indicators.

Common Use Cases and Queries

Typical uses include publishing tab-to-KPI mappings for reporting, auditing indicator assignments, and resolving indicator derivation chains. Because the object is internal and unsupported, queries should be limited to read-only diagnostics and used with the understanding that Oracle may change its definition without notice.

Listing all indicators for a given tab:

  • SELECT TAB_ID, IND_GROUP_ID, INDICATOR, NAME, SHARE_FLAG, SOURCE_INDICATOR FROM APPS.BSC_TAB_IND_V WHERE TAB_ID = :p_tab_id;

Identifying derived indicators using the searched column:

  • SELECT INDICATOR, NAME, SOURCE_INDICATOR FROM APPS.BSC_TAB_IND_V WHERE SOURCE_INDICATOR IS NOT NULL;

Reviewing shared indicators across tabs:

  • SELECT TAB_ID, INDICATOR, NAME FROM APPS.BSC_TAB_IND_V WHERE SHARE_FLAG = 1 ORDER BY TAB_ID, INDICATOR;

These queries support reconciliation and impact analysis, but production integrations should rely on supported Oracle Applications interfaces wherever equivalent functionality exists.