Search Results dbms_aw




Overview
Explore in AI Chat

Overview

SYS.DBMS_AW is an Oracle-supplied, SYS-owned PL/SQL package that provides the programmatic interface to the OLAP Analytic Workspace (AW) engine embedded in the Oracle database. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, it is not an Applications product API but a database kernel utility that ships with the RDBMS release on which the EBS database tier is certified. Its principal role is to start, drive, and shut down the OLAP worksheet session, to interpret and execute OLAP worksheet statements (including the DBCREATE dialect), and to expose session logging and runtime status to callers. The ETRM repository records the package as VALID in schema SYS, classified as OTHER, with the package body contributing 70 documented procedures and functions. No EBS object references it directly; DBMS_AW is instead an infrastructure dependency that EBS components may reach indirectly through the APPS synonym layer and through other OLAP-aware packages.

Key Procedures and Functions

The documented interface is grouped by function:

  • Session lifecycle: STARTUP establishes the OLAP session, SHUTDOWN terminates it, and INITDRIVER prepares the driver state required before OLAP statements can be processed. TOGGLEDBCREATE enables or disables the DBCREATE interpretation mode used for creating analytic workspaces from worksheet scripts.
  • Statement execution and interpretation: RUN and EXECUTE submit OLAP worksheet operations, while INTERP, INTERP_SILENT, and INTERPCLOB interpret worksheet text, including large CLOB-based scripts. INTERP_SILENT suppresses echoed output. INFILE directs interpretation of statements read from an operating-system file rather than from an inline string.
  • Expression evaluation: EVAL_NUMBER and EVAL_TEXT evaluate OLAP expressions and return numeric or textual results respectively, allowing host PL/SQL code to retrieve computed OLAP values.
  • Status and diagnostics: GETLOG and PRINTLOG retrieve and display the session log; OLAP_ON, OLAP_RUNNING, and OLAP_ACTIVE report whether the OLAP option is installed and whether a session is currently running or active.
  • Advisory and tuning helpers: ADVISE_REL and ADVISE_CUBE provide recommendations for relational and cube structures, and ENABLE_ACCESS_TRACKING turns on access tracking to support aggregate and cube maintenance decisions.

Parameter lists are intentionally not documented here, as ETRM metadata records signatures only for the packaged interface.

Tables Accessed

The package body references data dictionary views rather than application tables. ALL_AWS identifies the analytic workspaces visible to the session; ALL_TABLES and ALL_PART_TABLES describe relational sources that may be materialized into OLAP objects; DBA_TABLESPACES supports placement and storage decisions during workspace creation. These are read to resolve names, validate storage, and translate worksheet statements into dictionary operations. DBMS_AW additionally depends on DBMS_AW_LIB, DBMS_ASSERT, DBMS_LOB, DBMS_OUTPUT, DBMS_STANDARD, DBMS_STATS, STANDARD, PLITBLM, and its own internal collection types DBMS_AW$_COLUMNLIST_T, DBMS_AW$_DIMENSION_SOURCES_T, and DBMS_AW$_DIMENSION_SOURCE_T. No EBS application tables are accessed through the package body itself.

Usage Notes

DBMS_AW is invoked from SQL*Plus or another PL/SQL client, typically during database or BI-related setup rather than from EBS forms. In an EBS 12.1.1 or 12.2.2 environment it may be used by DBAs to load or refresh OLAP analytic workspaces that support reporting and planning, and it is referenced by six other database packages recorded in the dependency metadata. Because the package is owned by SYS and is not referenced by any database object, custom EBS code that needs OLAP functionality should call it only under DBA supervision, granting EXECUTE explicitly and using the OLAP worksheet syntax appropriate to the database version. Any customization must account for the OLAP option licensing and for the fact that OLAP is not a core EBS schema component.