Search Results dbms_cube_exp




Overview
Explore in AI Chat

Overview

SYS.DBMS_CUBE_EXP is an Oracle-supplied PL/SQL package belonging to the SYS schema that provides export and import utilities for Oracle OLAP analytic workspaces and cubes. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack, this package is not an EBS business API in the conventional sense; it is an Oracle Database component surfaced through the EBS data dictionary because EBS schemas and the APPS synonym layer reference a very large base of SYS-owned objects. The ETRM 12.1.1 classification records its API classification as OTHER, confirming it is a database utility rather than an EBS application module. Its presence in EBS environments reflects the dependency chain created by the OLAP option and XML DB components that many Oracle Database installations include by default.

Key Procedures and Functions

The ETRM metadata documents zero application-level procedures or functions for this package. This is consistent with a package whose entry points are largely internal to the OLAP export/import infrastructure and are not exposed as documented EBS APIs. Because no procedure signatures are recorded in the ETRM repository, this entry should not be relied upon as a procedural reference. Consumers requiring callable export or import routines should consult Oracle Database documentation for the OLAP component rather than the EBS object repository. No parameter lists are reproduced here, and none should be inferred from this metadata.

Tables Accessed

The documented table access for SYS.DBMS_CUBE_EXP is via the following objects, reached through APPS synonyms: DBMS_XDB, EQUALS_PATH, RESOURCE_VIEW, and UNDER_PATH. These are not conventional relational tables. They are XML DB constructs: RESOURCE_VIEW is a public view over the XML DB repository, while EQUALS_PATH and UNDER_PATH are XML DB operators used to filter repository paths. Their presence confirms that the package's export workflow interacts with the XML DB repository for staging or retrieving exported analytic workspace artifacts. DBMS_XDB is the XML DB management package used for repository and configuration operations. The combination indicates that export and import operations write to or read from repository resources rather than from ordinary application tables, which is why no EBS transactional tables appear in the dependency list.

Usage Notes

In EBS 12.1.1 and 12.2.2, this package should be treated as an Oracle Database infrastructure object that happens to appear in the EBS dependency map. The metadata records that SYS.DBMS_CUBE_EXP references SYS.STANDARD and that it is referenced by PUBLIC and by SYS through the public synonym DBMS_CUBE_EXP. The public synonym is significant: it allows any schema with execute privileges to invoke the package without qualifying the SYS owner. Typical invocation scenarios include database-level OLAP administration scripts, Data Pump or export routines that include analytic workspaces, and custom EBS extensions that manage OLAP content.

Because the ETRM record documents zero procedures and zero dependent packages, there is no evidence of any supported EBS forms, concurrent programs, or application APIs calling this package directly. Custom code in an EBS instance should not assume the package is callable or present unless the OLAP option is installed. Validation status VALID in the ETRM snapshot indicates the object compiled successfully at the time of capture, but availability remains contingent on database option licensing and installation. Administrators reviewing dependencies for patching or cloning should note this package as an infrastructure dependency rather than an EBS application object, and should confirm the OLAP and XML DB components before relying on its export capabilities.