Search Results deq_pmap_list




Overview
Explore in AI Chat

Overview

SYS.DBMS_AQ_IMP_INTERNAL is an Oracle-supplied, internal PL/SQL package body that belongs to the Advanced Queuing (AQ) import infrastructure. Its role in an Oracle E-Business Suite 12.1.1 or 12.2.2 environment is to support the import of Advanced Queue objects — queues, queue tables, subscriptions, and related metadata — that have been exported from another database or schema. The package operates strictly within the SYS schema and is classified as an internal (OTHER) API, meaning it is not intended for direct invocation by application code. Oracle EBS relies on Advanced Queuing for the Workflow Business Event System, which propagates business events between modules and across systems; consequently, the import utilities underlying AQ must function correctly for event subscriptions to be transported during cloning, migration, or environment refresh operations.

The package is documented as VALID in the ETRM metadata, with a dependency set that confirms its position as a low-level implementation layer beneath the public DBMS_AQ and DBMS_AQADM interfaces. It is not referenced by any other database object, indicating that it sits at or near the top of the internal call chain and is invoked indirectly rather than through inter-package calls.

Key Procedures and Functions

The documented ETRM listing exposes no individual procedures or functions for this package body. This is consistent with its classification as an internal implementation package: its callable units are not published for customer use and are therefore omitted from the reference documentation. Practically, DBMS_AQ_IMP_INTERNAL provides the private helper routines that implement queue import semantics on behalf of the AQ import driver. All functionality is exercised through higher-level entry points rather than by naming procedures in this package directly. No parameter lists are documented for this object, and none should be assumed.

Tables Accessed

The package's dependency list identifies four fixed internal tables that are referenced indirectly by the package body:

  • SH$DEQ_PMAP_LIST — dequeue parameter mapping metadata used during import processing. This is the object most closely associated with the user's search term deq_pmap_list, and it reflects the package's role in reconstructing dequeue-time mapping definitions as part of a queue import.
  • SH$QTAB_PMAP_LIST — queue table parameter mapping metadata, supporting reconstruction of queue table attributes during import.
  • SH$SHARD_META_LIST — shard-level metadata used by the import logic.
  • SH$SUB_META_LIST — subscriber metadata used to rebuild queue subscriptions on the target database.

These SH$ tables are internal repository structures owned by SYS and are not exposed through APPS synonyms; the ETRM metadata confirms that no application-facing tables are documented for this package.

Usage Notes

DBMS_AQ_IMP_INTERNAL is never invoked from Oracle EBS forms, concurrent programs, or supported customization code. It executes only when an AQ import operation is performed — typically through the Data Pump based AQ export/import path or through DBMS_AQADM-style administrative import routines that invoke the internal implementation layer. Its notable collaborators include DBMS_AQ_IMP_ZECURITY, DBMS_AQ_SYS_IMP_INTERNAL, DBMS_LOGREP_UTIL, DBMS_STREAMS_DATAPUMP_UTIL, and DBMS_SYS_ERROR, which together provide security handling, error raising, and Data Pump integration.

For EBS administrators, the practical implication is that this package is a diagnostic rather than a functional target. If AQ import fails during a clone or migration, the validity of DBMS_AQ_IMP_INTERNAL should be verified as part of standard post-clone checks, and any errors surfaced by its supporting packages should be treated as symptoms of an underlying AQ or Data Pump problem rather than as defects in a callable EBS API.