Search Results dbms_cube




Overview
Explore in AI Chat

Overview

SYS.DBMS_CUBE is a core Oracle database-supplied PL/SQL package that provides the server-side infrastructure for Oracle OLAP cube management. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, the package resides in the SYS schema and is registered in the E-Business Technology Reference Manual (ETRM) with a status of VALID and an API classification of OTHER. Although it is not an EBS application API in the traditional sense, DBMS_CUBE is a foundational element of the Oracle database stack upon which EBS installations depend whenever OLAP functionality, analytic workspace maintenance, or cube materialization is required. Within EBS, analytic workspaces and OLAP cubes are chiefly relevant to embedded business intelligence reporting, discoverer-style analytic queries, and downstream data warehouse extractions that aggregate transactional data from the EBS schema into multidimensional structures.

The package encapsulates the operational logic that Oracle OLAP uses to build, refresh, and reorganize cubes without forcing administrators to construct raw SQL against OLAP metadata structures. Because it is owned by SYS and exposed publicly, any EBS schema holding the appropriate privileges can invoke it. The ETRM records zero documented procedures or functions for this object in the 12.1.1 metadata set, meaning the callable interface is documented only through Oracle's general database documentation rather than the EBS-specific API listing.

Key Procedures and Functions

The ETRM metadata for this object lists no documented procedures or functions (0 total). This is consistent with DBMS_CUBE being a system-level utility package whose interface is published in the Oracle Database PL/SQL Packages and Types Reference rather than in EBS-specific API documentation. Administrators should therefore consult the database documentation corresponding to the installed RDBMS release for the authoritative procedure list, including the cube build, refresh, and maintenance entry points, as well as the analogous build/log routines traditionally associated with DBMS_CUBE and its companion package DBMS_CUBE_UTIL.

Tables Accessed

The ETRM extracts supplied for this object record no tables referenced via APPS synonyms, and no direct table access list is published in the metadata. Internally, DBMS_CUBE operates against the SYS-owned OLAP metadata and analytic workspace catalog views and tables rather than against EBS application tables. This separation is significant: the package does not read or write APPS schema objects such as GL balances, INV transactions, or AR invoices directly. Any EBS data reaching an OLAP cube must first be staged or extracted, after which DBMS_CUBE manipulates the multidimensional structures created within the OLAP environment.

Usage Notes

DBMS_CUBE is typically invoked from SQL*Plus or a database job, not from an EBS form. Within EBS 12.1.1 and 12.2.2 it may be called by custom PL/SQL, by scheduler jobs performing nightly cube maintenance, or indirectly by OLAP tooling. The ETRM dependency data confirms that the package references STANDARD and is itself referenced by exactly one other package, DBMS_CUBE_UTIL, which provides higher-level utility procedures built on the DBMS_CUBE foundation. Because the package is owned by SYS and exposed under a PUBLIC synonym, grants and execution privileges should be reviewed carefully before use in any EBS environment, and any scheduled invocation should be coordinated with the DBA team responsible for OLAP maintenance windows.