Search Results dbms_aq_inv

Overview

DBMS_AQ_INV is an Oracle-supplied PL/SQL package owned by the SYS schema that forms part of the Advanced Queuing (AQ) infrastructure shipped with the Oracle database. The package name reflects its role as the AQ "inventory" or internal support package that underpins the Advanced Queuing administrative and operational layers. In an Oracle E-Business Suite environment — whether 12.1.1 or 12.2.2 — the package is present because EBS relies extensively on Oracle Advanced Queuing for asynchronous business events, workflow background processing, Business Event System messaging, and interface/integration queues.

Within ETRM the object is registered as a VALID package with owner SYS and an API classification of OTHER, indicating that it is not an EBS-owned API and is not intended to be called directly by application code. Its business function in the EBS stack is therefore infrastructural rather than functional: it supports the queue management operations that allow EBS modules to enqueue and dequeue messages reliably.

Key Procedures and Functions

The documented ETRM metadata for DBMS_AQ_INV lists zero public procedures or functions, and no signature information is exposed. This is consistent with the package being an internal, undocumented Oracle component rather than a supported application programming interface.

Because no callable procedures are documented, no parameter lists can be stated. From its name and its placement in the AQ dependency chain, the package is understood to provide internal helper logic consumed by the AQ administrative layer, specifically DBMS_AQADM_SYS. Any invocation is therefore expected to occur indirectly through the supported Advanced Queuing APIs — principally DBMS_AQ, DBMS_AQADM, and the EBS wrappers that call them — rather than by direct reference to DBMS_AQ_INV.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. This is expected: as a SYS-owned dictionary-level component, DBMS_AQ_INV operates against Oracle's internal AQ dictionary and queue tables rather than against any EBS application schema objects exposed via APPS synonyms.

Consequently, no EBS business tables (for example, interface or event tables) are documented as being read or written by this package. Any queue storage it touches resides in the Oracle data dictionary and in the queue tables created and managed through DBMS_AQADM.

Usage Notes

DBMS_AQ_INV is referenced by exactly one other package, DBMS_AQADM_SYS, and it references STANDARD. This dependency profile confirms it sits beneath the AQ administration layer and is never the entry point for an EBS process. It should not be invoked directly from Forms, concurrent programs, or custom code.

In day-to-day EBS 12.1.1 and 12.2.2 operation, this package is exercised implicitly whenever Advanced Queuing administration activity occurs, such as queue creation, alteration, or maintenance executed by AQADM. Troubleshooting efforts should therefore focus on the supported AQ packages and on the queue configuration itself, treating DBMS_AQ_INV purely as an internal dependency. Its presence and VALID status in ETRM merely confirm that the underlying Oracle AQ installation is intact.

PACKAGE: SYS.DBMS_AQ_INV 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQ_INV, status:VALID,
PACKAGE: SYS.DBMS_AQ_INV 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQ_INV, status:VALID,
PACKAGE BODY: SYS.DBMS_AQ_INV 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQ_INV, status:VALID,
PACKAGE BODY: SYS.DBMS_AQ_INV 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQ_INV, status:VALID,
PACKAGE: SYS.DBMS_AQ_INV 12.1.1
PACKAGE: SYS.DBMS_AQ_INV 12.2.2
PACKAGE: SYS.DBMS_AQ 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQ, status:VALID,
PACKAGE: SYS.DBMS_AQ 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQ, status:VALID,
PACKAGE: SYS.DBMS_AQADM_SYS 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQADM_SYS, status:VALID,
PACKAGE BODY: SYS.DBMS_AQADM_SYS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQADM_SYS, status:VALID,
PACKAGE: SYS.DBMS_AQADM_SYS 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQADM_SYS, status:VALID,
PACKAGE BODY: SYS.DBMS_AQADM_SYS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQADM_SYS, status:VALID,
PACKAGE BODY: SYS.DBMS_AQ_INV 12.2.2
PACKAGE BODY: SYS.DBMS_AQ_INV 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_AQ_INV dependencies on DBMS_AQ_INV 12.2.2
SYS.DBMS_AQ_INV dependencies on DBMS_AQ_INV 12.1.1
PACKAGE: SYS.PLITBLM 12.2.2
owner:SYS, object_type:PACKAGE, object_name:PLITBLM, status:VALID,
PACKAGE: SYS.PLITBLM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:PLITBLM, status:VALID,
PACKAGE: SYS.DBMS_ASSERT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
SYS.DBMS_AQADM_SYS dependencies on DBMS_AQ_INV 12.2.2
SYS.DBMS_AQADM_SYS dependencies on DBMS_AQ_INV 12.1.1
PACKAGE: SYS.DBMS_ASSERT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
SYS.DBMS_AQ_INV dependencies on DBMS_AQ 12.2.2
SYS.DBMS_AQ_INV dependencies on DBMS_AQ 12.1.1
TABLE: SYS.DUAL 12.2.2
owner:SYS, object_type:TABLE, object_name:DUAL, status:VALID,
TABLE: SYS.DUAL 12.1.1
owner:SYS, object_type:TABLE, object_name:DUAL, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,