Search Results dbms_aqelm

Overview

SYS.DBMS_AQELM is an Oracle-supplied PL/SQL package that resides in the SYS schema and forms part of the Oracle Advanced Queuing (AQ) infrastructure delivered with the Oracle database server. The name derives from "AQ Exception and Error Logging Mechanism," and the package provides the internal plumbing by which Oracle Advanced Queuing records, manages, and exposes error and exception information raised during enqueue and dequeue operations. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package is not an EBS application object; it is a database component that becomes relevant to EBS administrators and technical consultants because the EBS technology stack — notably Oracle Workflow, the Business Event System, and the Concurrent Manager's notification and event queues — relies on Advanced Queuing for asynchronous message propagation. As documented in the ETRM repository, the package holds a status of VALID and is owned by SYS, confirming it is a core database object rather than a customer-modifiable EBS artifact. Its API classification is recorded as OTHER, reflecting that it is a supporting infrastructure package rather than a documented application programming interface intended for direct customer invocation.

Key Procedures and Functions

The ETRM documentation metadata for SYS.DBMS_AQELM records zero documented procedures or functions exposed for customer use. The package specification and package body are present and both are reported with a VALID status, confirming the object compiles and is operational. The dependency listing shows that the package references STANDARD, the Oracle-supplied package that provides the base PL/SQL language constructs, and that it is referenced by PUBLIC and by SYS itself, indicating that other database components depend upon its internal routines. Consistent with Oracle's practice for internal AQ infrastructure packages, the callable units within DBMS_AQELM are intended for use by the Advanced Queuing engine and other Oracle-supplied packages rather than by application developers. No parameter lists should be assumed for these internal routines, and no public entry points are documented in the EBS reference material.

Tables Accessed

The ETRM metadata records no tables referenced by DBMS_AQELM through APPS synonyms, which is expected for a SYS-owned package that operates against Advanced Queuing data dictionary and queue storage structures directly rather than through EBS application tables. Any underlying queue tables would be owned by the schemas that define the queues, not accessed via APPS synonyms. Consequently, there are no EBS application tables associated with this package in the documented metadata.

Usage Notes

SYS.DBMS_AQELM is not invoked from EBS forms, concurrent programs, or standard customization points. It should never be called directly from custom EBS code, as its routines are internal and subject to change with database patch levels. The package is referenced during normal database operations whenever Advanced Queuing encounters or logs errors — for example, when Oracle Workflow's event queues or the Business Event System experience propagation failures. In practice, EBS technical consultants encounter the package name when diagnosing AQ-related errors, reviewing database dependencies, or validating the technology stack after an upgrade or patch application. Because ETRM reports it as VALID and notes that it is referenced by PUBLIC and SYS, its presence and valid compilation status serve as a health indicator for the EBS Advanced Queuing foundation. Troubleshooting should focus on the queues and subscribers configured in the EBS schemas rather than on this package itself.

SYNONYM: PUBLIC.DBMS_AQELM 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_AQELM, status:VALID,
SYNONYM: PUBLIC.DBMS_AQELM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_AQELM, status:VALID,
PACKAGE: SYS.DBMS_AQELM 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQELM, status:VALID,
PACKAGE: SYS.DBMS_AQELM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQELM, status:VALID,
PACKAGE BODY: SYS.DBMS_AQELM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQELM, status:VALID,
PACKAGE BODY: SYS.DBMS_AQELM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQELM, status:VALID,
LIBRARY: SYS.DBMS_AQELM_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_AQELM_LIB, status:VALID,
PACKAGE: SYS.UTL_TCP 12.2.2
owner:SYS, object_type:PACKAGE, object_name:UTL_TCP, status:VALID,
PACKAGE: SYS.UTL_HTTP 12.2.2
owner:SYS, object_type:PACKAGE, object_name:UTL_HTTP, status:VALID,
PACKAGE BODY: SYS.DBMS_AQELM 12.2.2
LIBRARY: SYS.DBMS_AQELM_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_AQELM_LIB, status:VALID,
PACKAGE: SYS.DBMS_AQELM 12.1.1
PACKAGE: SYS.DBMS_AQELM 12.2.2
PACKAGE: SYS.UTL_SMTP 12.1.1
owner:SYS, object_type:PACKAGE, object_name:UTL_SMTP, status:VALID,
PACKAGE: SYS.UTL_TCP 12.1.1
owner:SYS, object_type:PACKAGE, object_name:UTL_TCP, status:VALID,
PACKAGE: SYS.UTL_SMTP 12.2.2
owner:SYS, object_type:PACKAGE, object_name:UTL_SMTP, status:VALID,
PACKAGE: SYS.UTL_HTTP 12.1.1
owner:SYS, object_type:PACKAGE, object_name:UTL_HTTP, status:VALID,
PACKAGE BODY: SYS.DBMS_AQELM 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
SYS.DBMS_AQELM dependencies on DBMS_AQELM 12.1.1
PUBLIC.DBMS_AQELM dependencies on DBMS_AQELM 12.2.2
PUBLIC.DBMS_AQELM dependencies on DBMS_AQELM 12.1.1
SYS.DBMS_AQELM dependencies on DBMS_AQELM 12.2.2
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,