Search Results bsc_aw_dbms_aw




Overview
Explore in AI Chat

Overview

BSC_AW_DBMS_AW is an Oracle EBS database package owned by the APPS schema and classified under the OTHER API category. Its name indicates a thin wrapper layer over the Oracle OLAP option's DBMS_AW PL/SQL package, exposed within the Balanced Scorecard (BSC) application family. The package provides the scorecard module with a controlled interface for executing Enterprise OLAP (analytic workspace) statements and expressions from within the EBS database session. In Oracle EBS 12.1.1 and 12.2.2, Balanced Scorecard functionality relies on analytic workspaces to store and evaluate multidimensional performance metrics; this package supplies the runtime plumbing that allows PL/SQL code to submit those statements, interpret expression text, and initialize the session environment. The header comment ($Header: BSCAWDBS.pls 120.2) dates the source to 2005, consistent with the original 11i-era Balanced Scorecard implementation carried forward into the 12.x code lines.

Key Procedures and Functions

  • EXECUTE — Accepts a statement string and runs it against the OLAP analytic workspace engine via DBMS_AW. It is the primary entry point for DDL-like and DML-like operations against analytic workspaces, such as creating, populating, or clearing workspace objects.
  • EXECUTE_NE — A variant of EXECUTE with "NE" semantics, typically denoting execution that does not raise (or does not propagate) errors back to the caller. Callers use it when a failure should be tolerated or handled elsewhere in the scorecard load or refresh flow.
  • INTERP — A function that returns a VARCHAR2 result. It submits an expression to the OLAP engine and returns the interpreted or evaluated value as text, allowing scorecard logic to resolve dynamic OLAP expressions inside ordinary PL/SQL processing.
  • INIT_ALL — Initializes package-level state for a session. Given the package global g_debug boolean, INIT_ALL most likely resets or establishes package globals and prepares the DBMS_AW runtime context before subsequent EXECUTE, EXECUTE_NE, or INTERP calls are made.

Tables Accessed

The package references two objects through APPS synonyms: DBMS_AW and DBMS_LOB. DBMS_AW is the Oracle-supplied OLAP API that executes and interprets analytic workspace statements. DBMS_LOB is the Oracle large-object API, used here to manipulate CLOB/BLOB data that carries workspace statement text, expression definitions, or returned results, since OLAP statements can exceed the VARCHAR2 limits of the procedure signatures. These are procedural APIs rather than application tables; BSC_AW_DBMS_AW does not directly read or write scorecard base tables in the documented excerpt.

Usage Notes

Because the package is classified as OTHER rather than a public API, it is an internal utility called by other Balanced Scorecard packages. ETRM records show it is referenced by 10 other packages, confirming that it functions as a shared low-level service rather than a direct form-level or concurrent-program entry point. Typical invocation occurs indirectly: a scorecard batch process, workspace refresh routine, or other BSC package opens a session, invokes INIT_ALL to prepare context, then issues EXECUTE or EXECUTE_NE for workspace maintenance and INTERP to evaluate expressions. In Oracle EBS 12.1.1 and 12.2.2, the package requires the OLAP option to be installed in the database, and it should be treated as an internal implementation detail — customization should target the calling BSC packages rather than this wrapper, whose signature has remained stable since the 120.2 revision.