Results for “dbms_aqadm_sys”

50+ results




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

Overview

SYS.DBMS_AQADM_SYS is the internal, wrapped implementation package that underpins the Oracle Advanced Queuing administrative interface for Oracle E-Business Suite Release 12.1.1 and 12.2.2. The public-facing DBMS_AQADM package exposes administrative primitives such as queue table creation, queue creation, start and stop of queues, and subscriber management, and DBMS_AQADM_SYS supplies the underlying code used to execute those operations within the database instance hosting the EBS schema. In the EBS context this package is a component of the database server rather than a standard EBS product feature; it is not owned by the APPS schema and is not part of the ETRM functional catalog for any individual EBS application. Its API classification in ETRM is recorded as OTHER, reflecting its role as an Oracle-supplied infrastructure package rather than a business API.

Key Procedures and Functions

The ETRM extract for this object documents no exposed procedures or functions of its own. The package body is stored in wrapped form, meaning the PL/SQL source is obfuscated and cannot be read directly from the data dictionary. All administrative functionality is invoked through the wrapper package DBMS_AQADM, which in turn delegates to DBMS_AQADM_SYS across the supported DBMS_AQADM calls: creating and altering queue tables, creating, altering, starting and stopping queues, granting and revoking queue privileges, and managing subscribers, propagation schedules, and queue-to-queue and queue-to-destination propagation jobs. Because ETRM provides no parameter signatures for this package, no argument lists should be assumed beyond those published for the public DBMS_AQADM interface. Direct invocation of DBMS_AQADM_SYS entry points is not a supported development pattern.

Tables Accessed

No tables are documented as being accessed through APPS synonyms for this package. Oracle Advanced Queuing administrative routines operate exclusively against the fixed AQ data dictionary, including the queue table metadata, queue and subscriber registration, recipient, and propagation schedule views and base tables maintained in the SYS schema. EBS application data tables are not read or written by DBMS_AQADM_SYS through the APPS synonym layer; any interaction with EBS business data occurs only when application logic enqueues or dequeues messages against queues configured by the AQ administrator.

Usage Notes

DBMS_AQADM_SYS is typically invoked indirectly whenever EBS components configure or administer Advanced Queuing. This includes concurrent programs and one-off database scripts that create and maintain AQ objects for workflow mailer processing, Business Event System queues, Oracle XML Gateway messaging, and other integration facilities built on AQ. In Release 12.2.2 the same package underpins AQ administration for the online patching edition architecture. The package is referenced by 27 other packages as recorded in ETRM, confirming its role as a shared infrastructure dependency rather than a business-facing API. The wrapped body cannot be inspected or customized, and Oracle support policy does not permit modifications to SYS-owned AQ packages. Custom development should always call DBMS_AQADM or DBMS_AQ rather than the underlying SYS package. The search token "hdzhc,jfx" does not correspond to any documented AQ object and is unrelated to this package; it appears to be a user-specific reference with no bearing on DBMS_AQADM_SYS behavior.