Search Results dbms_aqadm

Overview

SYS.DBMS_AQADM is the administrative component of Oracle's Advanced Queuing (AQ) infrastructure. It is the PL/SQL package body that governs the definition, configuration, and lifecycle management of queues and queue tables within the database. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package is owned by the SYS schema and carries a VALID status, confirming its integrity within the ETRM reference model.

While DBMS_AQADM is not itself an EBS business application package, it provides the foundational messaging services upon which numerous EBS integration points depend. The package enables the creation, alteration, and removal of queue tables, queues, and subscribers, thereby supporting asynchronous and reliable message delivery between EBS modules, external systems, and middleware such as Oracle SOA Suite or Oracle Integration Cloud. Its API classification is documented as OTHER, reflecting its role as a database infrastructure utility rather than a functional application interface.

Key Procedures and Functions

The ETRM metadata documents 61 procedures and functions within DBMS_AQADM. The principal entry points include:

CREATE_QUEUE_TABLE — Establishes the underlying storage table that holds queue messages, defining payload type and storage characteristics.
ALTER_QUEUE_TABLE — Modifies the properties of an existing queue table.
DROP_QUEUE_TABLE — Removes a queue table and its associated queues.
CREATE_QUEUE — Creates a queue within an existing queue table, enabling message enqueue and dequeue operations.
CREATE_NP_QUEUE — Creates a non-persistent queue for lightweight, in-memory messaging scenarios.
ALTER_QUEUE — Adjusts queue parameters such as retention, retry, and delay settings.
START_QUEUE / STOP_QUEUE — Enable or disable enqueue and dequeue activity on a queue.
DROP_QUEUE — Removes a queue from its queue table.
ADD_SUBSCRIBER / ALTER_SUBSCRIBER / REMOVE_SUBSCRIBER — Manage the subscriber list for a queue, controlling which consumers receive messages.
QUEUE_SUBSCRIBERS — Returns the current subscriber registry for a queue.
GRANT_QUEUE_PRIVILEGE / REVOKE_QUEUE_PRIVILEGE — Administer per-queue privileges for enqueue and dequeue operations.
GRANT_SYSTEM_PRIVILEGE / REVOKE_SYSTEM_PRIVILEGE — Administer system-level AQ privileges such as MANAGE_ANY.
GRANT_TYPE_ACCESS — Grants type access required for payload handling.
CREATE_SHARDED_QUEUE / DROP_SHARDED_QUEUE — Manage sharded queue configurations in partitioned environments.

Tables Accessed

The documented dependency information indicates that DBMS_AQADM references internal fixed objects, including AQ$_AGENT and AQ$_SIG_PROP. These dictionary-managed structures store agent definitions and signal propagation metadata associated with queue subscriptions and notification behavior. No application-level tables are listed as direct dependencies within the ETRM record; queue tables created through this package are stored in the schema of the invoking user, and their contents are managed via the AQ dictionary views. The package also depends on supporting packages rather than application data tables, reinforcing its infrastructure role.

Usage Notes

DBMS_AQADM is typically invoked by database administrators, integration developers, and EBS technical consultants when configuring advanced queuing for asynchronous workflows, workflow mailer processing, or inter-application messaging. It is rarely called directly from EBS Forms; instead, it is executed through SQL*Plus scripts, concurrent program wrappers, or custom PL/SQL routines during setup and configuration of queuing infrastructure. The package is referenced by 18 other database objects, indicating its central position within the AQ dependency chain. Because the package is owned by SYS and the ETRM record shows it is not referenced by any database object within the documented scope, changes to queue definitions should be treated as database-level administrative operations subject to standard change-control procedures.

PACKAGE BODY: SYS.DBMS_AQADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQADM, status:VALID,
PACKAGE BODY: SYS.DBMS_AQADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQADM, status:VALID,
PACKAGE: SYS.DBMS_AQADM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQADM, status:VALID,
PACKAGE: SYS.DBMS_AQADM 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQADM, status:VALID,
PACKAGE BODY: GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN 12.1.1
owner:GSMADMIN_INTERNAL, object_type:PACKAGE BODY, object_name:DBMS_GSM_CLOUDADMIN, status:VALID,
PACKAGE BODY: GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN 12.2.2
owner:GSMADMIN_INTERNAL, object_type:PACKAGE BODY, object_name:DBMS_GSM_CLOUDADMIN, status:VALID,
SYNONYM: PUBLIC.DBMS_AQADM 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_AQADM, status:VALID,
PACKAGE: SYS.DBMS_AQADM_SYS 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQADM_SYS, status:VALID,
SYNONYM: PUBLIC.DBMS_AQADM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_AQADM, status:VALID,
TYPE: SYS.AQ$_SIG_PROP 12.2.2
owner:SYS, object_type:TYPE, object_name:AQ$_SIG_PROP, status:VALID,
VIEW: SYS.ALL_INT_DEQUEUE_QUEUES 12.1.1
PACKAGE: SYS.DBMS_AQADM_SYS 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQADM_SYS, status:VALID,
PACKAGE BODY: APPS.JTF_IH_BULK_Q_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_IH_BULK_Q_PKG, status:VALID,
TYPE: SYS.AQ$_SIG_PROP 12.1.1
owner:SYS, object_type:TYPE, object_name:AQ$_SIG_PROP, status:VALID,
VIEW: SYS.ALL_INT_DEQUEUE_QUEUES 12.2.2
TYPE: SYS.AQ$_AGENT 12.1.1
owner:SYS, object_type:TYPE, object_name:AQ$_AGENT, status:VALID,
TYPE: SYS.AQ$_AGENT 12.2.2
owner:SYS, object_type:TYPE, object_name:AQ$_AGENT, status:VALID,
PACKAGE BODY: APPS.WF_HA_MIGRATION 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_HA_MIGRATION, status:VALID,
PACKAGE BODY: APPS.FND_CP_OPP_IPC 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FND_CP_OPP_IPC, status:VALID,
LIBRARY: SYS.DBMS_AQ_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_AQ_LIB, status:VALID,
PACKAGE BODY: APPS.WF_BES_CLEANUP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_BES_CLEANUP, status:VALID,
PACKAGE BODY: APPS.FND_CP_OPP_IPC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FND_CP_OPP_IPC, status:VALID,
PACKAGE BODY: APPS.FA_ASSET_TRACE_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FA_ASSET_TRACE_PUB, status:VALID,
PACKAGE BODY: APPS.FND_CP_GSM_IPC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FND_CP_GSM_IPC, status:VALID,
PACKAGE: SYS.DBMS_AQADM_INV 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQADM_INV, status:VALID,
PACKAGE: SYS.DBMS_PRVTAQIS 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_PRVTAQIS, status:VALID,
PACKAGE BODY: APPS.WF_HA_MIGRATION 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_HA_MIGRATION, status:VALID,
PACKAGE BODY: APPS.FND_CP_GSM_IPC 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FND_CP_GSM_IPC, status:VALID,
PACKAGE BODY: APPS.WF_BES_CLEANUP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_BES_CLEANUP, status:VALID,
VIEW: SYS.ALL_QUEUE_TABLES 12.2.2
PACKAGE: SYS.DBMS_AQIN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AQIN, status:VALID,
PACKAGE BODY: APPS.WF_CLONE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_CLONE, status:VALID,
PACKAGE BODY: APPS.AMV_AQ_UTILITY_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMV_AQ_UTILITY_PVT, status:VALID,
PACKAGE BODY: SYSTEM.AD_APPS_PRIVATE 12.1.1
owner:SYSTEM, object_type:PACKAGE BODY, object_name:AD_APPS_PRIVATE, status:VALID,
PACKAGE BODY: APPS.WF_CLONE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_CLONE, status:VALID,
PACKAGE BODY: APPS.WF_EVENT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_EVENT, status:VALID,
PACKAGE BODY: APPS.WF_SETUP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_SETUP, status:VALID,
PACKAGE BODY: APPS.JTF_IH_BULK_Q_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_IH_BULK_Q_PKG, status:VALID,
VIEW: SYS.ALL_DEQUEUE_QUEUES 12.2.2
PACKAGE BODY: APPS.AMV_AQ_UTILITY_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMV_AQ_UTILITY_PVT, status:VALID,
VIEW: SYS.ALL_QUEUES 12.2.2
PACKAGE BODY: SYS.DBMS_AQ_SYS_EXP_ACTIONS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQ_SYS_EXP_ACTIONS, status:VALID,
PACKAGE BODY: SYS.DBMS_AQ_SYS_EXP_ACTIONS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AQ_SYS_EXP_ACTIONS, status:VALID,
VIEW: SYS.ALL_DEQUEUE_QUEUES 12.1.1
VIEW: SYS.ALL_QUEUES 12.1.1
VIEW: SYS.ALL_QUEUE_TABLES 12.1.1
LIBRARY: SYS.DBMS_AQ_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_AQ_LIB, status:VALID,
PACKAGE BODY: APPS.FA_ASSET_TRACE_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FA_ASSET_TRACE_PUB, status:VALID,
PACKAGE BODY: APPS.WF_SETUP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_SETUP, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_IMP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_IMP, status:VALID,