Search Results bsc_aw_utility




Overview
Explore in AI Chat

Overview

APPS.BSC_METADATA is a PL/SQL package in the Oracle E-Business Suite Balanced Scorecard (BSC) module, part of the Oracle Business Intelligence foundation shipped with EBS 12.1.1 and 12.2.2. The package maintains and exposes the structural metadata that describes the Balanced Scorecard data model: KPI definitions, dimension hierarchies, dimension levels, calendars, and the underlying database views and base tables that supply scorecard values. It functions as a metadata access layer that other BSC runtime packages call to translate an abstract scorecard definition into physical SQL constructs, level relationships, and data sources.

The package is classified as OTHER in the ETRM repository and is owned by the APPS schema. It is referenced by BSC_AW_ADAPTER, BSC_AW_BSC_METADATA, BSC_AW_CALENDAR, BSC_AW_READ, and BSC_AW_UTILITY, and it depends on BSC_AW_ADAPTER_DIM, BSC_AW_UTILITY, DBMS_SQL, and the STANDARD package. Because BSC_AW_UTILITY appears both as a dependency and as a dependent, the two packages form a mutually referencing pair within the scorecard aggregation and refresh framework; this is why the user query for "bsc_aw_utility" surfaces BSC_METADATA documentation.

Key Procedures and Functions

ETRM documents 42 procedures and functions in BSC_METADATA. The documented set falls into several functional groups:

The exact parameter signatures are not enumerated in the available metadata; only the names and functional intent are documented.

Tables Accessed

The package references the APPS synonyms DBMS_SQL and PLITBLM. DBMS_SQL is used for dynamic SQL construction — necessary because scorecard queries are generated at runtime from metadata rather than being statically coded. PLITBLM provides the PL/SQL index-by table support used to pass collection data between the metadata layer and the aggregation packages. All primary scorecard metadata tables (KPI, dimension, level, calendar, and view definitions) are reached through APPS synonyms and are normally accessed read-only by this package.

Usage Notes

BSC_METADATA is not an end-user API. It is invoked internally by the Balanced Scorecard runtime packages — BSC_AW_ADAPTER, BSC_AW_READ, BSC_AW_CALENDAR, and BSC_AW_UTILITY — during scorecard rendering, aggregation, and data refresh. Custom code that must resolve scorecard hierarchy or KPI metadata should call these documented functions rather than querying the underlying metadata tables directly, since the metadata model is internal and subject to change. No concurrent program or Oracle Form calls this package directly; it is a supporting library within the BSC execution stack.