Search Results shard_meta_list




Overview
Explore in AI Chat

Overview

DBMS_AQ_IMP_INTERNAL is an Oracle-supplied internal PL/SQL package owned by the SYS schema and shipped as part of the core Advanced Queuing (AQ) infrastructure. It is not an Oracle E-Business Suite product-specific package; rather, it is a database kernel component that EBS 12.1.1 and 12.2.2 rely upon indirectly because EBS uses Oracle Streams Advanced Queuing for several of its asynchronous and workflow-related messaging mechanisms. The package performs low-level import and materialization work for AQ queue tables, principally around the internal metadata structures that track sharded and non-sharded queue table partitions and their propagation maps.

In the EBS context, the package is present in every database that hosts an EBS schema because it is created by the database itself, not by AutoConfig or AD utilities. Its presence and VALID status are therefore baseline expectations rather than an EBS configuration artifact.

Key Procedures and Functions

The ETRM metadata documents zero public procedures or functions for this package. This is consistent with its classification as an internal implementation package: it exposes no documented API surface for developers to call. The procedures and functions it contains are private to the package body and are invoked exclusively by other SYS-owned AQ components, such as DBMS_AQ, DBMS_AQADM, and the AQ import/export utilities.

Because no callable specification is published, the package must be treated as opaque. Any attempt to invoke entries directly would be unsupported and could corrupt AQ dictionary state.

Tables Accessed

The dependency information shows that DBMS_AQ_IMP_INTERNAL references a small set of SYS-owned internal tables:

  • SH$DEQ_PMAP_LIST — dequeue propagation map list, used to track propagation scheduling metadata during import.
  • SH$QTAB_PMAP_LIST — queue table propagation map list, storing per-queue-table propagation mappings.
  • SH$SHARD_META_LIST — shard metadata list, supporting sharded queue table definitions.
  • SH$SUB_META_LIST — subscriber metadata list, holding subscription definitions associated with queue tables.

These are internal, undocumented data dictionary-adjacent structures rather than EBS application tables. No APPS-synonym tables are referenced, confirming that the package does not touch EBS business data directly. STANDARD is referenced as a language dependency only.

The package is referenced by PUBLIC and by SYS itself, indicating it is a dependency of the public AQ synonym layer and of other SYS packages.

Usage Notes

DBMS_AQ_IMP_INTERNAL is invoked implicitly whenever AQ import operations are performed, for example during database-level export/import of schemas containing queue tables, or when Oracle Streams capture and apply processes materialize queue metadata. In EBS 12.1.1 and 12.2.2, administrators may encounter it indirectly through:

  • Database export/import (Data Pump) of EBS schemas that include AQ queue tables.
  • Cloning operations via Rapid Clone or AD utilities, where database-level export and import occur.
  • Oracle Workflow and Business Event System mailer or deferred processing that depends on AQ.

The package must never be modified, recompiled by hand, or called from custom code. If it becomes INVALID, the standard remedy is to recompile it as SYS or to re-run the relevant AQ installation script supplied by Oracle Support. EBS-specific diagnostics such as ETRM report the package and its dependencies for reference only; no EBS concurrent program or form invokes it directly.