Search Results bsc_dbgen_bsc_reader




Overview
Explore in AI Chat

Overview

APPS.BSC_DBGEN_BSC_READER is a PL/SQL package in the Oracle E-Business Suite database layer that supports the Balanced Scorecard (BSC) Designer component of Oracle Enterprise Performance Foundation / ETRM (Enterprise Territory and Resource Management lineage). The package provides read-only access to the metadata repository that describes the analytical structures deployed for a Balanced Scorecard implementation — including facts, measures, dimensions, levels, periodicities, calendars, and calculation definitions.

As the name implies, BSC_DBGEN_BSC_READER is a runtime query interface over the BSC-DB generation metadata. It allows the Designer framework to interrogate the shape of a deployed data model — for example, to determine which measures belong to a fact, which dimensions map to a level, or which periodicities apply to a given table — so that downstream generators, validators, or reporting components can produce consistent SQL and business object definitions. The package status is VALID and it is owned by the APPS schema, making its procedures accessible to other EBS code that resolves objects through APPS synonyms.

Key Procedures and Functions

The ETRM documentation records 38 procedures and functions in this package, with the following notable entries:

Because parameter lists are not documented in the ETRM excerpt, callers should inspect the package specification in the database for exact signatures.

Tables Accessed

The package reads from a series of BSC metadata tables resolved through APPS synonyms, including:

All operations are read-oriented; the package does not modify core BSC metadata.

Usage Notes

BSC_DBGEN_BSC_READER is referenced by the companion package BSC_DBGEN_METADATA_READER and by itself (internal recursion), and it depends on BSC_DBGEN_STD_METADATA plus the DBMS_SQL package. It is typically invoked from the Balanced Scorecard Designer setup and generation flows, from concurrent programs that validate or build the analytical data model, and from custom PL/SQL that needs to interrogate deployed BSC metadata. Because it uses DBMS_SQL for dynamic generation, session privileges must permit execution of dynamic SQL against the referenced BSC tables. Developers extending BSC functionality should call this package rather than querying the underlying metadata tables directly, ensuring consistency with Designer semantics.