Search Results dbms_aw_xml

Overview

DBMS_AW_XML is a SYS-owned PL/SQL package body that forms part of Oracle's OLAP and Analytic Workspace infrastructure delivered with the database and surfaced within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack. Its principal business function is to provide an XML-based interface for reading and executing Analytic Workspace metadata and XML definition files. In EBS deployments, the package is most commonly encountered as an underlying engine invoked by OLAP-related components and database utilities rather than by end-user applications directly. The package holds VALID status in the data dictionary and is classified under the generic OTHER API classification, indicating that it is not a public EBS application programming interface but an internal database service package.

Key Procedures and Functions

The ETRM metadata documents four callable units within the package body. Each is described below by purpose; parameter signatures are intentionally not enumerated.

• EXECUTE — The general-purpose entry point for executing Analytic Workspace XML commands or definitions. It is the primary mechanism by which input XML content is parsed and dispatched for processing.
• READAWMETADATA — Reads Analytic Workspace metadata, typically from the data dictionary or an associated OLAP catalog, and returns it in an XML representation suitable for downstream consumption or transport.
• READAWMETADATA1 — A companion or variant routine to READAWMETADATA, used for the same metadata extraction purpose where a secondary or alternate processing path is required, such as handling a specific metadata scope or output shape.
• EXECUTEFILE — Executes an XML definition supplied as a file reference rather than inline content, enabling batch processing of Analytic Workspace definitions stored on the database server file system.

Tables Accessed

The ETRM documentation for this object does not enumerate specific application tables accessed through APPS synonyms. As a SYS-owned OLAP utility, its persistence interaction is directed at the Oracle OLAP catalog and Analytic Workspace metadata views rather than at EBS transactional tables. Where reads or writes to metadata occur, they are routed through the OLAP dictionary structures that record analytic workspace definitions. EBS implementers should therefore treat DBMS_AW_XML as a metadata-layer utility and not expect it to touch core EBS business tables.

Usage Notes

DBMS_AW_XML references several supporting objects, including DBMS_LOB for large object handling, GENRAWSEQUENCE and GENWSTRINGSEQUENCE for sequence generation, and STANDARD. Importantly, the ETRM metadata states that DBMS_AW_XML is not referenced by any database object while it is itself referenced by one other package, indicating it sits low in the dependency chain and is called by a single consuming component. In practice it is invoked programmatically during OLAP administrative operations, workspace provisioning, and XML-driven metadata loads, rather than from EBS forms or concurrent programs directly. Custom code should avoid direct invocation unless performing advanced OLAP administration, and any use should be tested carefully because the package is unsupported as a public API and its behavior may change with database patch levels. Rationale: preserve documented facts and clearly flag the absence of table and parameter detail.