Search Results dbms_aq_import_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_AQ_IMPORT_INTERNAL is an Oracle-supplied, wrapped PL/SQL package that resides in the SYS schema. It is an internal component of the Oracle Streams Advanced Queuing (AQ) infrastructure and is not part of the Oracle E-Business Suite application schema layer. In the context of Oracle EBS 12.1.1 and 12.2.2, this package supports the import and export of AQ queue definitions and associated metadata. It provides the underlying implementation used by the public AQ administrative APIs when queue objects must be migrated, cloned, or propagated between database instances or schemas.

The package is classified in the ETRM repository as "OTHER," meaning it does not map to a specific EBS business flow or module such as Order Management or Payables. Instead, it operates as a database kernel utility that EBS relies upon indirectly whenever queue-based integrations, workflow background processing, or Business Event System (BUS) subscriptions depend on AQ to move messages between instances. Because the source is wrapped, the package body is obfuscated, and only the callable interface is exposed to the database engine.

Key Procedures and Functions

The ETRM metadata documents zero public procedures or functions for this package. This is expected: DBMS_AQ_IMPORT_INTERNAL is designed for internal invocation by other Oracle components rather than for direct use by developers or DBAs. Its entry points are called by the AQ export/import driver routines during a database-level import (impdp) or during replication setup, where queue tables, queues, and subscriber metadata must be recreated consistently on the target system.

No parameter lists are reproduced here, in keeping with the wrapped and undocumented nature of the package. Any documentation of specific call signatures would be speculative and is therefore omitted.

Tables Accessed

The ETRM extract does not list any tables referenced through APPS synonyms. This is consistent with the package's location in SYS and its role as a dictionary-level utility. Internally, the package interacts with AQ data dictionary views and base tables such as SYS.AQ$_QUEUES, SYS.AQ$_QUEUE_TABLES, and related subscriber and message tables. These are accessed to reconstruct queue definitions and to re-register them after an import operation. Because these objects belong to the SYS schema rather than to EBS application schemas, no APPS-synonym table references appear in the ETRM catalog.

Usage Notes

DBMS_AQ_IMPORT_INTERNAL is not invoked directly from EBS forms, concurrent programs, or custom PL/SQL. It is called by Oracle's own import utilities and by the AQ propagation and replication layer. ETRM records indicate the package is referenced by four other packages, reflecting this dependent, internal call pattern.

Administrators working with EBS 12.1.1 or 12.2.2 should treat this package as a protected Oracle component. It should not be modified, and its presence is validated by utlrp.sql and standard database health checks. When planning a clone, a Data Pump export/import of an EBS instance, or a queue migration, the package executes implicitly; no manual step is required. If a queue import fails with an internal AQ error, the failure typically originates in the wrapped body of this package, and resolution lies in verifying AQ dictionary consistency and the target database version rather than in altering the package itself.