Search Results advise_rel




Overview
Explore in AI Chat

Overview

SYS.DBMS_AW is the server-side PL/SQL interface to the Oracle OLAP (formerly Express) option. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, it provides the only supported programmatic channel through which EBS sessions can interpret and execute OLAP DML commands directly against an analytic workspace. The package is declared with AUTHID CURRENT_USER, so privileges on workspace objects are evaluated against the invoking database user rather than the package owner.

Its primary business role is to support analytic workspaces embedded in the EBS database, including the Express-based planning, budgeting, and analytic components that historically depended on database-resident OLAP. Because subsequent releases of Oracle Database (12c and later) deprecated the native OLAP option, DBMS_AW is relevant in EBS environments that remain on database versions where the OLAP option is present and licensed. The metadata for 12.2.2 classifies the API as OTHER and shows it referenced by six other packages, confirming that it is a foundational utility rather than an end-user facing API.

Key Procedures and Functions

  • INITDRIVER — Initializes the OLAP driver used for the session.
  • STARTUP / SHUTDOWN — Start and stop the OLAP server session; SHUTDOWN accepts a force option to terminate unresponsive sessions.
  • TOGGLEDBCREATE — Toggles database-creation behavior during workspace operations.
  • RUN — Executes an OLAP DML command passed as a STRING or CLOB, with an optional silent flag; overloaded forms return output into a STring or CLOB.
  • EXECUTE — Executes a DML command and routes output through DBMS_OUTPUT.
  • INTERP / INTERPCLOB / INTERP_SILENT — Interpret a DML command and return the result as a character LOB; the silent variant suppresses output.
  • EVAL_NUMBER / EVAL_TEXT — Evaluate a DML expression and return a typed scalar result.
  • OLAP_ON / OLAP_RUNNING — Report whether the OLAP option is enabled and whether a session is active.
  • OLAP_ACTIVE — The function matching the search term "olap_active." It reports whether an OLAP session is currently active for the calling connection, enabling conditional logic before attempting interpreter calls.
  • ADVISE_REL / ADVISE_CUBE — Generate recommendations for relation or aggregate structure, including percentage and compression parameters.
  • ENABLE_ACCESS_TRACKING / DISABLE_ACCESS_TRACKING — Toggle access tracking on a named workspace object to support usage analysis.
  • GETLOG / PRINTLOG — Retrieve and print the OLAP server log.
  • INFILE — Read a DML script from an external file.

Tables Accessed

The ETRM metadata documents no EBS application tables referenced through APPS synonyms. The package operates on OLAP analytic workspaces and their repository objects rather than on standard EBS transaction tables. Its invocation may indirectly touch EBS interfaces via dependent packages listed in the metadata.

Usage Notes

DBMS_AW is typically invoked from custom PL/SQL or concurrent programs that require OLAP DML execution; OLAP_ACTIVE is commonly called first as a guard check. Access requires the OLAP option and appropriate workspace privileges.