Search Results dbms_aqjms_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_AQJMS_INTERNAL is an Oracle-supplied PL/SQL package that resides in the SYS schema and forms part of the Oracle Advanced Queuing (AQ) infrastructure underpinning the Java Message Service (JMS) interface. Within Oracle E-Business Suite 12.1.1 and 12.2.2, this package operates as an internal, low-level component responsible for translating between JMS message semantics and the native AQ message representation stored in the database. It is not designed for direct customer invocation; rather, it is called by the public-facing DBMS_AQJMS package to persist and retrieve JMS headers, message bodies, and message properties. The package is documented with a status of VALID and is classified as an OTHER API in ETRM metadata for 12.2.2. Because EBS 12.1.1 and 12.2.2 both depend on the underlying Oracle database AQ/JMS stack, this package is present and active in both releases, supporting the messaging backbone used by EBS integrations, workflow notifications, and Oracle Workflow Business Events.

Key Procedures and Functions

The documented ETRM metadata for SYS.DBMS_AQJMS_INTERNAL lists no publicly documented procedures or functions. This is consistent with the object's designation as an internal implementation package: its callable units are deliberately withheld from the public Oracle documentation set and are subject to change without notice. The package is referenced by the parent DBMS_AQJMS package, which supplies the supported external API surface. Administrators and developers should therefore regard DBMS_AQJMS_INTERNAL as a private helper library only, and should never bind custom code to any of its internal routines. All supported interaction with JMS messaging in EBS must be performed through DBMS_AQJMS or the native DBMS_AQ package.

Tables Accessed

The ETRM dependency listing shows that SYS.DBMS_AQJMS_INTERNAL directly references a set of AQ JMS queue tables owned by SYS. These include AQ$_JMS_MESSAGES and its typed variants AQ$_JMS_BYTES_MESSAGES, AQ$_JMS_TEXT_MESSAGES, AQ$_JMS_MAP_MESSAGES, AQ$_JMS_OBJECT_MESSAGES, and AQ$_JMS_STREAM_MESSAGES, which persist the different JMS message body types. It also references AQ$_JMS_HEADER for JMS header attributes, AQ$_JMS_MESSAGE_PROPERTIES for name/value property pairs, AQ$_JMS_ARRAY_MSGIDS and AQ$_JMS_ARRAY_ERRORS for collection handling, and AQ$_SIG_PROP for signal-related properties. Finally, it depends on DBMS_AQ and the STANDARD package. These dependencies confirm that the package is dedicated to reading and writing JMS payload and metadata tables during enqueue, dequeue, and message conversion operations.

Usage Notes

In EBS 12.1.1 and 12.2.2, SYS.DBMS_AQJMS_INTERNAL is invoked indirectly whenever JMS operations are performed against AQ queues, including message propagation and transformation routines. Typical EBS scenarios include Oracle Workflow Business Event system processing and integrations that exchange messages with external JMS providers. It may legitimately appear in dependency queries, invalidation reports, or AWR/ASH output when diagnosing queue-related waits, and its presence is expected and benign. Because the package is internal and undocumented, custom development must never call it directly; doing so risks breakage on database patch application. When troubleshooting, verify the package status is VALID and, if necessary, recompile it using standard database utilities rather than ad hoc DDL.