Results for “secondary_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The OLAPSYS.CWM$UTILITY package is an Oracle-provided PL/SQL utility that belongs to the OLAPSYS schema, the repository owner for Oracle's OLAP and Common Warehouse Metamodel (CWM) metadata services. In Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package operates as an internal infrastructure component rather than as a business-facing API. It supports the metadata layer that describes OLAP analytic workspaces, cubes, dimensions, hierarchies, levels, and measures, all of which underpin the analytic capabilities surfaced through EBS operational reporting and Business Intelligence integrations.

Within the ETRM classification, CWM$UTILITY is recorded as an OTHER API type with a status of VALID in both 12.1.1 and 12.2.2. The object is not exposed to end users, forms, or concurrent programs; it exists to be invoked by other OLAPSYS packages during metadata validation, export, and cleanup operations. Its presence in a search for a term such as "PROTAIN SERVICE UTILITY" reflects a user-driven lookup of low-level PL/SQL objects rather than a supported EBS feature.

Key Procedures and Functions

The package exposes twenty documented procedures and functions. From the ETRM metadata, the following are notable:

• GET_VERSION — returns the version identifier of the installed CWM utility code, used for compatibility checks across OLAPSYS components.
• GET_FUNCTION_ID — resolves an internal identifier for a function usage record.
• VALIDATE_DIMENSION and VALIDATE_CUBE — perform structural validation of OLAP dimension and cube metadata definitions.
• GET_FIRST_VALIDATE_ERROR and GET_NEXT_VALIDATE_ERROR — iterate over validation errors collected during a validation pass.
• GET_OBJECT_IN_ERROR and SET_OBJECT_IN_ERROR — track which metadata object is currently in an error state.
• DUMP_ERROR and GET_LAST_ERROR_DESCRIPTION — surface diagnostic text for the most recent failure.
• COLLECT_GARBAGE — reclaims orphaned or stale metadata records from the CWM repository.
• CREATE_FUNCTION_USAGE, DROP_FUNCTION_USAGE, ADD_ARGUMENT, and SET_ARGUMENT — manage function usage and argument metadata for CWM expressions.
• EXPORT_ALL, EXPORT_CATALOG, and EMPTY_ALL_METADATA — bulk export and metadata-clearing operations used for deployment or refresh.
• IS_OLAP_DBA — returns whether the current session holds OLAP DBA privileges, gating sensitive operations.

Tables Accessed

The ETRM metadata lists the following tables referenced through APPS synonyms: ALL_CONSTRAINTS, DBA_ROLES, DBA_ROLE_PRIVS, DBA_USERS, DBMS_OUTPUT, and PLITBLM. These are used to verify schema privileges, enumerate role grants, resolve user identity for SECURITY checks, and emit diagnostic output. PLITBLM is an Oracle-internal index-organized table employed by PL/SQL for bulk collection and Boolean handling. No EBS application tables are touched.

Usage Notes

CWM$UTILITY is invoked exclusively by other OLAPSYS packages, including CWM$CLASSIFY, CWM$EXPORT, the CWM$OLAP$* family, CWM$UTIL, and itself. It is also referenced by the public synonym CWM_UTILITY. It is not called directly from EBS forms, concurrent programs, or supported customizations. Direct invocation is not recommended in a 12.1.1 or 12.2.2 production environment, since the package is an internal Oracle implementation detail subject to change without notice. Administrators encountering it during troubleshooting should treat it as a supporting object only.