Search Results meas_ext_tl

Overview

APPS.BIS_MEASURES_EXTENSION_VL is a bilingual (VL, "view language") reporting view within the Oracle E-Business Suite Business Intelligence System (BIS) schema. It exposes the language-dependent and language-independent attributes of measures that extend the standard ETRM/BI measure framework. In EBS 12.1.1 and 12.2.2 the BIS schema underpins Oracle's embedded business intelligence and Daily Business Intelligence (DBI) reporting, and the BIS_MEASURES_EXTENSION family stores customer- or implementation-defined measures that supplement the seeded measure catalog.

The view's role is to present a single denormalized row per measure, combining the base table's operational columns with the translated name and description drawn from the _TL companion table. Because it filters on USERENV('LANG'), each session automatically receives translated content for the current language setting, which is essential for multilingual reporting and for integration interfaces that must display measure labels in the user's locale. The underlying objects are the standard concurrent-program and reporting structures maintained by the BIS/ETRM application, and the view is queried internally by BI dashboards, list-of-values definitions, and custom reports built in Oracle Reports, XML Publisher, or OBIEE.

Underlying Base Objects

The view is defined over two documented base tables that are joined on the measure short name and restricted to the session language:

• BIS_MEASURES_EXTENSION (aliased MEAS_EXT) — the language-independent master table holding the measure short name, functional area assignment, and standard WHO audit columns.
• BIS_MEASURES_EXTENSION_TL (aliased MEAS_EXT_TL) — the translation table holding the language-specific NAME and DESCRIPTION, keyed by measure short name and LANGUAGE.

The join predicate is MEAS_EXT.MEASURE_SHORT_NAME = MEAS_EXT_TL.MEASURE_SHORT_NAME AND MEAS_EXT_TL.LANGUAGE = USERENV('LANG'). Functional-area context is carried by FUNCTIONAL_AREA_ID, which references the BIS functional area definition rather than a denormalized name. No additional documented base objects are exposed by the ETRM metadata for this view.

Key Columns

• MEASURE_SHORT_NAME — the unique programmatic identifier for the extended measure; used as the join key and as the reference key in downstream measure-mapping tables.
• NAME — the translated display name of the measure, resolved for the session language via the _TL table.
• DESCRIPTION — the translated descriptive text describing the measure's business meaning.
• FUNCTIONAL_AREA_ID — foreign key identifying the functional area (for example, financials or order management) to which the measure belongs.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO audit columns supporting change tracking and data lineage.

Common Use Cases and Queries

Typical usage includes building multilingual measure lists for BI dashboards, validating that a custom measure has translated content before deployment, and joining the view to functional-area and measure-mapping tables to construct metadata-driven reports.

Retrieve all extended measures in the session language:

SELECT MEASURE_SHORT_NAME, NAME, DESCRIPTION, FUNCTIONAL_AREA_ID
FROM APPS.BIS_MEASURES_EXTENSION_VL
ORDER BY NAME;

Locate measures for a specific functional area:

SELECT MEASURE_SHORT_NAME, NAME
FROM APPS.BIS_MEASURES_EXTENSION_VL
WHERE FUNCTIONAL_AREA_ID = :p_functional_area_id;

Identify untranslated measures by joining the view to the translation table (measures present in the base table but absent from the current language in the _TL table will not appear in the view):

SELECT b.MEASURE_SHORT_NAME
FROM APPS.BIS_MEASURES_EXTENSION b
WHERE NOT EXISTS
(SELECT 1 FROM APPS.BIS_MEASURES_EXTENSION_TL t
WHERE t.MEASURE_SHORT_NAME = b.MEASURE_SHORT_NAME
AND t.LANGUAGE = USERENV('LANG'));

Because the view applies no security predicate beyond the language filter, custom reports should apply any required operating-unit or functional-area restrictions explicitly.