Search Results dbms_prvtaqip




Overview
Explore in AI Chat

Overview

DBMS_PRVTAQIP is an internal, Oracle-proprietary PL/SQL package owned by the SYS schema and shipped as part of the Oracle Database Advanced Queuing (AQ) infrastructure. The name combines the "DBMS_" prefix with "PRVT" (private) and "AQ" (Advanced Queuing), designating it a private helper package that supports the AQ administration layer rather than a documented public API. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is not part of the EBS application code base itself; it is an Oracle RDBMS component that EBS depends upon indirectly through its use of Advanced Queuing for workflow mailer, concurrent manager messaging, business event propagation, and other asynchronous integration mechanisms.

Because it is a private package, DBMS_PRVTAQIP carries no EBS-specific business logic. Its role is to provide supporting routines to the AQ administration facilities, in particular those invoked by DBMS_AQADM_SYS. EBS customers typically encounter this object only during dependency analysis, patching diagnostics, or database upgrade validation, and rarely if ever invoke it directly.

Key Procedures and Functions

The ETRM documentation for DBMS_PRVTAQIP at 12.2.2 lists zero documented public procedures or functions. This is consistent with its classification as a private (PRVT) package whose subprograms are intended for internal consumption by other SYS-owned AQ packages. No published signature, parameter list, or return type is exposed in the metadata. Practitioners should treat the package as a black box and rely on the public DBMS_AQ and DBMS_AQADM APIs for any AQ configuration or enqueue/dequeue operations.

Tables Accessed

The documented dependency information shows that DBMS_PRVTAQIP references the data dictionary table AQ$_SCHEDULES. This table stores scheduling information for AQ propagation and queue-to-queue message movement. The package reads this table as part of the internal scheduling and propagation bookkeeping performed on behalf of AQ administration. No EBS product tables or APPS synonyms are documented as being accessed by this package, confirming that its data access is confined to the AQ subsystem's own dictionary objects.

Usage Notes

DBMS_PRVTAQIP is referenced by SYS.DBMS_AQADM_SYS and, transitively, is exposed through the AQ administration stack that supports EBS business events, Workflow mailer, and advanced queueing workflows. It also appears in its own dependency list, indicating internal self-references among its private subprograms. The package additionally depends on the STANDARD package and UTL_HTTP, the latter reflecting AQ's support for HTTP-based propagation. In EBS 12.1.1 and 12.2.2 environments, it is invoked only indirectly when AQ administrative operations are performed — for example, when creating or altering queues, configuring propagation schedules, or when the AQ background processes reconcile scheduled jobs.

Custom developers should not call DBMS_PRVTAQIP directly. Because it is a SYS-owned private package, its interface may change without notice across database patch levels, and Oracle does not document or guarantee its behavior. When troubleshooting AQ-related EBS issues — such as stalled business event subscriptions, workflow notifications, or propagation backlogs — DBMS_PRVTAQIP may appear in trace files, dependency reports, and invalidation listings (for instance, following a database upgrade or a UTL_HTTP patch). Any recompilation or validation performed as part of a database patch or upgrade should be allowed to proceed normally; invalidating or altering this package manually is not supported and can corrupt AQ scheduling metadata held in AQ$_SCHEDULES.