Search Results bis_indicators_vl




Overview
Explore in AI Chat

Overview

BIS_INDICATORS_VL is a seeded, translated (VL) view in the APPS schema belonging to the BIS – Applications BIS product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is an Oracle-owned, dictionary-managed database object with STATUS VALID, and developers must treat it as read-only reference data. The view presents the master definition of performance indicators (KPIs) maintained by the Oracle Balanced Scorecard / BIS (Business Intelligence System) framework, joining the language-independent indicator record to its language-specific translation row for the session language.

Its role is to expose indicator metadata — short name, descriptive name, description, dataset association, measure type, and lifecycle flags — in a single, translation-aware result set that reports, concurrent programs, and personalizations can consume without performing their own language joins. Because the _VL suffix indicates a view that returns only the current session language, queries issued under different USERENV('LANG') values automatically return the appropriate localized text.

Underlying Base Objects

The view is defined over exactly two BIS base tables:

  • BIS_INDICATORS (alias IND) — the language-independent header table holding the surrogate key, short name, audit columns, dataset reference, and control flags.
  • BIS_INDICATORS_TL (alias IND_TL) — the translation table holding the localized NAME and DESCRIPTION for each indicator and language.

The join predicate is IND.INDICATOR_ID = IND_TL.INDICATOR_ID combined with IND_TL.LANGUAGE = USERENV('LANG'). This is the standard EBS multi-language (MLS) pattern: the _B (base) and _TL (translation) pair is surfaced through a _VL view. The view text exposes the base table's ROWID as the pseudo-column ROW_ID, which supports the standard OAF/Forms entity-row identification convention. There is no denormalized data and no aggregation; the view is a pure projection over the two tables.

Key Columns

  • ROW_ID — ROWID of the BIS_INDICATORS row, used for row-level identification in the framework.
  • INDICATOR_ID — Primary/foreign key of the indicator; the join column to BIS_INDICATORS_TL and the logical identifier used by dependent BIS objects.
  • SHORT_NAME — Language-independent short identifier for the indicator.
  • NAME — Localized display name sourced from BIS_INDICATORS_TL.
  • DESCRIPTION — Localized descriptive text sourced from BIS_INDICATORS_TL.
  • DATASET_ID — Reference to the dataset (data source) that supplies the indicator's underlying values.
  • ENABLED — Flag indicating whether the indicator is active and available for use.
  • OBSOLETE — Flag marking the indicator as retired; obsolete indicators should be excluded from active reporting.
  • MEASURE_TYPE — Classifies the measurement semantics of the indicator.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO columns carried from BIS_INDICATORS for auditing.

Common Use Cases and Queries

Typical uses include listing configured indicators for a Balanced Scorecard implementation, validating dataset assignments before loading scorecard definitions, and identifying disabled or obsolete indicators prior to upgrade or migration. The following query lists all currently enabled indicators in the session language:

  • SELECT indicator_id, short_name, name, dataset_id, measure_type FROM apps.bis_indicators_vl WHERE enabled = 'Y' AND NVL(obsolete,'N') = 'N' ORDER BY name;
  • SELECT v.indicator_id, v.name, v.description FROM apps.bis_indicators_vl v WHERE v.dataset_id = :p_dataset_id;
  • SELECT COUNT(*) FROM apps.bis_indicators_vl; — quick inventory of localized indicators available to the current session language.

Because the language filter is embedded in the view, callers should not add their own LANGUAGE predicate; doing so would conflict with USERENV('LANG') and may return no rows in multi-language environments.