Search Results measure_group_id




Overview
Explore in AI Chat

Overview

The BSC_DB_MEASURE_GROUPS_VL view is a public, language-sensitive reporting object within the Balanced Scorecard (BSC) module of Oracle E-Business Suite. It is owned by the APPS schema and carries a VALID status in both 12.1.1 and 12.2.2 deployments. The view exists to expose translated descriptive text associated with measure groups — the logical containers that organize the measures and key performance indicators tracked in a Balanced Scorecard implementation.

The _VL suffix follows the standard Oracle EBS multilingual convention, indicating a view that joins a translated table (_TL) against the session's language environment. In practice, this view provides a convenient, language-filtered projection of measure group metadata for reporting, dashboards, and integration interfaces that must render descriptive text in the user's preferred language.

Underlying Base Objects

Per the documented ETRM metadata, BSC_DB_MEASURE_GROUPS_VL is defined directly over BSC_DB_MEASURE_GROUPS_TL, the translation table that stores language-specific attributes for measure groups. The view text as documented is:

SELECT MEASURE_GROUP_ID, HELP
FROM BSC_DB_MEASURE_GROUPS_TL
WHERE LANGUAGE = USERENV('LANG')

The WHERE clause restricts rows to the language returned by USERENV('LANG'), ensuring each query returns only the translation appropriate to the current session. Note that other EBS _VL views conventionally union the base (_B) table with translations for untranslated rows; the ETRM excerpt for this object documents only the _TL source, and no additional base objects are enumerated in the 12.2.2 metadata. This discrepancy should be verified against the live view definition in any specific instance, as the view text may have been extended in later patches.

Key Columns

  • MEASURE_GROUP_ID — The primary identifier for a measure group. This is the column most commonly used in joins to other BSC tables such as measure assignments, indicator definitions, and scorecard configuration. It is the search term that most frequently leads users to this view.
  • HELP — The translated help or descriptive text associated with the measure group, stored at the language level in the _TL table. This is typically the field surfaced in the user interface to guide scorecard authors.

Because the documented VIEW TEXT exposes only these two columns, the view is a narrow, purpose-built projection rather than a full descriptive record. The measure group's untranslated or primary attributes (such as NAME and other base columns) reside in the corresponding base table, BSC_DB_MEASURE_GROUPS_B, if present in the schema.

Common Use Cases and Queries

Typical uses include retrieving help text for display, resolving a MEASURE_GROUP_ID to its session-language description, and joining to other BSC objects for scorecard reporting. A simple lookup for a specific measure group:

SELECT MEASURE_GROUP_ID, HELP
FROM   APPS.BSC_DB_MEASURE_GROUPS_VL
WHERE  MEASURE_GROUP_ID = :p_measure_group_id;

Integration or interface code frequently performs a language-aware join back to the base table to obtain both the name and the translated help:

SELECT g.measure_group_id,
       g.name,
       v.help
FROM   apps.bsc_db_measure_groups_b g,
       apps.bsc_db_measure_groups_vl v
WHERE  g.measure_group_id = v.measure_group_id
AND    g.measure_group_id = :p_measure_group_id;

Analysts should confirm the actual column list and _B table name against the dictionary before deploying such joins, since the ETRM metadata documents only the two columns named above.