Results for “bsc_mo_helper_pkg”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.BSC_MO_HELPER_PKG is a PL/SQL helper package in the Oracle EBS Balanced Scorecard (BSC) product family, primarily supporting the Metadata Optimizer (MO) subsystem. The package is classified as an "OTHER" API in the ETRM documentation and carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2. Its core responsibility is to provide low-level utility routines shared across the metadata optimization, data generation, and information model components of the Balanced Scorecard application.
The helper package acts as a foundational service layer rather than a business-facing API. It abstracts common operations such as dynamic SQL execution, data definition language (DDL) generation, tablespace and storage clause construction, schema name resolution, and initialization of internal metadata structures. As such, it is invoked extensively by higher-level packages including BSC_METADATA_OPTIMIZER_PKG, BSC_MO_DB_PKG, BSC_MO_DOC_PKG, BSC_MO_INDICATOR_PKG, BSC_MO_INPUT_TABLE_PKG, BSC_MO_LOADER_CONFIG_PKG, and BSC_MO_UI_PKG, as well as by the DBGen (database generation) utilities BSC_DBGEN_BSC_READER, BSC_DBGEN_METADATA_READER, and BSC_DBGEN_UTILS. This dependency pattern confirms its role as a cross-cutting utility used throughout the metadata optimizer and data generation pipeline.
Key Procedures and Functions
The ETRM documentation records 169 procedures and functions within this package. Representative documented routines include:
- GETSOURCETABLE / GETPERIODICITYFORTABLE — Resolve the source table and periodicity associated with a given metadata or KPI structure, supporting the optimizer's understanding of the underlying data model.
- CHECKERROR — Centralized error inspection routine used to validate the outcome of prior operations and raise or log exceptions as appropriate.
- INITTABLESPACENAMES — Initializes tablespace name configuration used during physical object creation.
- GETTABLESPACECLAUSETBL / GETTABLESPACECLAUSEIDX — Construct tablespace clauses for tables and indexes respectively, enabling dynamic DDL generation.
- GETSTORAGECLAUSE — Builds the storage clause fragment appended to DDL statements.
- MARKINDICSFORNONSTRUCCHANGES — Flags indicators affected by non-structural metadata changes so that downstream regeneration is triggered correctly.
- GETFIELDEXPRESSION — Derives the SQL expression for a metadata field, used when generating view or query definitions.
- GET_TIME — Returns the current time value used for auditing or timestamping within the optimizer workflow.
- ADDSTACK — Manages a stack structure, typically for nested processing or error context tracking.
- INITIALIZEPERIODICITIES / INITIALIZECALENDARS — Populate periodicity and calendar metadata required by KPI processing.
- INITARRRESERVEDWORDS — Loads an array of reserved SQL words used to validate generated identifiers.
- INITIALIZEMASTERTABLES — Prepares master metadata table structures.
- DROPTABLE / DROPVIEW / DO_DDL — Perform dynamic DDL operations for dropping and creating database objects, wrapping DBMS_SQL for execution.
- GETAPPSSCHEMA / GETBSCSCHEMA — Return the schema names for APPS and the BSC product schema, used in qualified object references.
Tables Accessed
Through APPS synonyms the package reads and writes a range of Balanced Scorecard metadata tables, including BSC_DB_TABLES, BSC_DB_TABLES_COLS, and BSC_DB_TABLES_RELS for table and column definition metadata; BSC_KPIS_B and BSC_KPIS_TL for KPI definitions and translations; BSC_KPI_ANALYSIS_MEASURES_B, BSC_KPI_DATA_TABLES, BSC_KPI_DEFAULTS_B, and BSC_KPI_DEFAULTS_TL for KPI configuration; BSC_KPI_DIM_LEVELS_B for dimensional level assignments; BSC_KPI_PERIODICITIES and BSC_KPI_PROPERTIES for periodicity and property definitions; BSC_SYS_CALENDARS_B for calendar data; and BSC_MESSAGE_LOGS for logging diagnostic and error messages. It also invokes DBMS_SQL for dynamic statement execution.
Usage Notes
BSC_MO_HELPER_PKG is not intended for direct invocation from Oracle Forms or standard concurrent programs. It is invoked internally by the metadata optimizer, data generation readers, and UI packages during metadata synchronization, KPI deployment, and database object generation. The presence of FND_LOG in its dependency list indicates integration with the EBS logging framework, so diagnostic output can be captured via FND log configuration. Customizations that call this package should be aware that its routines are tightly coupled to the BSC metadata model and that signatures are not guaranteed to be backward compatible across patch levels beyond the documented ETRM version.
-
SYNONYM: PUBLIC.ALL_MVIEWS 12.1.1
-
SYNONYM: APPS.BSC_KPIS_TL 12.1.1
-
SYNONYM: PUBLIC.USER_VIEWS 12.1.1
-
SYNONYM: APPS.BSC_SYS_INIT 12.1.1
-
SYNONYM: APPS.BSC_DB_TABLES 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: PUBLIC.DBMS_STATS 12.1.1
-
12.1.1 DBA Data 12.1.1