Search Results dbms_prvtaqim




Overview
Explore in AI Chat

Overview

The SYS.DBMS_PRVTAQIM package is an Oracle-supplied, internal PL/SQL package that forms part of the core Advanced Queuing (AQ) infrastructure. Its name—DBMS_PRVT AQ IM—denotes "private AQ import" functionality, and it is owned by the SYS schema rather than by the APPS schema. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is not an EBS application object; it is a database kernel component delivered with the Oracle RDBMS and merely surfaced within ETRM because EBS technical objects depend upon it. Its business function is to support the internal mechanics by which Advanced Queuing messages, queue tables, and their metadata are imported and reconstructed—most importantly during export/import, transportable-tablespace operations, and recoveries of queued data. Because AQ is heavily used by EBS workflow mailers, Business Event System, and various integration points, this package indirectly underpins reliable message delivery across the EBS estate.

Key Procedures and Functions

The ETRM documentation for Oracle EBS 12.2.2 records zero documented procedures or functions for DBMS_PRVTAQIM. This is expected: the package is an internal, private implementation package whose callable surface is not part of any public API contract and is therefore undocumented in the EBS object repository. Its subprograms are intended solely for invocation by other Oracle AQ packages and are subject to change between RDBMS patch levels without notice. Consequently, no parameter lists are published or should be assumed. Technical reviewers should treat the entire package body as opaque and unsupported for direct invocation.

Tables Accessed

The ETRM metadata does not list any tables accessed via APPS synonyms, which is consistent with the package operating in the SYS schema against AQ dictionary and queue-table structures rather than against EBS application tables. Because it is referenced by AQ administration packages such as DBMS_AQADM_SYS and by the AQ import internal packages DBMS_AQ_IMPORT_INTERNAL and DBMS_AQ_SYS_IMP_INTERNAL, its access is directed at the underlying queue metadata—principally the SYS AQ dictionary tables (for example, AQ$_QUEUES, AQ$_QUEUE_TABLES) and the appropriate AQ$_ queue-table storage for the queues being imported. These accesses support reconstruction of queue definitions and delivery of stored messages during import.

Usage Notes

DBMS_PRVTAQIM is never invoked directly by EBS forms, concurrent programs, or supported custom code. It is called internally by the AQ import and administration stack during operations such as Data Pump import of schemas containing queue tables, original export/import, and certain upgrade and recovery activities. The dependency chain documented in ETRM—SYS.DBMS_PRVTAQIM depending on STANDARD, and being referenced by DBMS_AQADM_SYS, DBMS_AQ_IMPORT_INTERNAL, DBMS_AQ_SYS_IMP_INTERNAL, and itself—confirms its position as a private helper within the AQ kernel.

For EBS administrators, the practical implication is straightforward. If DBMS_PRVTAQIM appears as INVALID in DBA_OBJECTS, remediation requires recompiling it (or, more correctly, re-running the RDBMS-supplied script dbmspvtaqim.sql as SYS), and any compilation errors almost always indicate a mismatched or partially applied RDBMS patch rather than an EBS configuration fault. Custom code must never call this package, since its signature and behaviour are undocumented and Oracle does not guarantee backwards compatibility of private packages across releases. EBS 12.2.2's online patching architecture, with its dual file systems and editioning, does not alter this relationship: the package remains a static RDBMS object, and its validity is validated during the database tier patching cycle rather than by the EBS patch driver.