Search Results qtab_pmap_list




Overview
Explore in AI Chat

Overview

DBMS_AQ_SYS_IMP_INTERNAL is a restricted Oracle-supplied PL/SQL package owned by the SYS schema. It forms part of the internal infrastructure supporting Advanced Queuing (AQ) export and import operations, which are the mechanisms Oracle uses to move queue definitions, queue tables, and associated metadata between database instances. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package operates entirely behind the scenes as one of the low-level building blocks leveraged by the public-facing DBMS_AQ_EXP_QUEUES, DBMS_AQ_EXP_QUEUE_TABLES, and DBMS_AQ_IMP_INTERNAL packages.

The package is marked VALID in the ETRM metadata, confirming that its compiled form is present and consistent with the database version in use. Because it resides in SYS and is not documented for direct customer invocation, its principal business function is to supply the system-side import routines that reconstruct AQ objects within a target database during cloning, migration, or Data Pump-based transport of EBS schemas. It is effectively the counterpart to the AQ system-level export logic.

Key Procedures and Functions

The ETRM metadata records zero documented procedures or functions for DBMS_AQ_SYS_IMP_INTERNAL. This is characteristic of an Oracle-internal package whose callable interface is deliberately withheld from public documentation. The package is not exposed through the standard DBMS_AQ administration API, and its entry points are reserved for consumption by other SYS-owned AQ packages.

Its behavior is inferred from its dependency graph: it references the specialized SH$DEQ_PMAP_LIST, SH$QTAB_PMAP_LIST, SH$SHARD_META_LIST, and SH$SUB_META_LIST structures, indicating that it manipulates partition mapping lists, queue table metadata lists, shard metadata lists, and subscriber metadata lists during import. It also references the STANDARD package for basic PL/SQL runtime support.

Tables Accessed

The ETRM documentation identifies KU$_STATUS as the only table referenced via APPS synonyms. This is a data dictionary view used to report the status of dictionary objects, consistent with a package that validates the success or failure of import operations. The SH$ prefixed structures listed as dependencies are internal system views or tables used to reconstruct queue partitioning and metadata mappings rather than application data tables. Because the package is internal, it does not read or write EBS transactional tables directly; any such interaction occurs through the higher-level AQ packages that invoke it.

Usage Notes

DBMS_AQ_SYS_IMP_INTERNAL is never invoked directly from EBS forms, concurrent programs, or customer-written code. Oracle explicitly restricts execution privileges on the package, and the metadata confirms it is referenced by only three other packages: DBMS_AQ_EXP_QUEUES, DBMS_AQ_EXP_QUEUE_TABLES, and DBMS_AQ_IMP_INTERNAL, all within SYS. Its presence should be treated as evidence of a healthy AQ installation rather than as an integration point.

  • Invocation occurs implicitly during AQ export/import, schema cloning, and full database migrations.
  • Errors arising from this package typically surface as ORA- codes during Data Pump or AQ import, not from application transactions.
  • Validated EBS patching, such as the 12.1.1 to 12.2.2 upgrade, refreshes dependent packages; DBMS_AQ_SYS_IMP_INTERNAL should remain VALID after such patches.
  • Custom code that attempts to call it directly is unsupported and may fail after any Oracle patch or upgrade.

Consultation of this object is therefore diagnostic only, useful when troubleshooting AQ-related export and import failures in an EBS environment.