Search Results dbms_propagation_adm




Overview
Explore in AI Chat

Overview

SYS.DBMS_PROPAGATION_ADM is an Oracle-supplied administrative PL/SQL package that provides the programmatic interface for managing Streams propagations at the database level. In Oracle E-Business Suite 12.1.1 and 12.2.2, the package operates within the Advanced Queueing and Streams infrastructure that underpins several EBS data-distribution and replication features, including multi-tier synchronization and the propagation of logical change records between queues. Its responsibilities are administrative rather than business-facing: it creates, alters, starts, stops, and drops propagation jobs that move captured messages from a source queue to a destination queue, typically across database links in a distributed deployment.

The package owner is SYS, and it is exposed to other schemas through a public synonym (PUBLIC.DBMS_PROPAGATION_ADM). ETRM classifies the API as OTHER, reflecting its role as an infrastructure utility rather than an application-tier API. The object is reported with a status of VALID. It depends on the STANDARD package and underlying Streams internals, and it is referenced by several other SYS packages, notably DBMS_LOGREP_IMP, DBMS_STREAMS_ADM_IVK, and DBMS_STREAMS_ADM_UTL, indicating that higher-level Streams administration routines delegate to it.

Key Procedures and Functions

The documented interface consists of five procedures:

  • CREATE_PROPAGATION — Establishes a new propagation, defining the source queue, the destination queue, and the database link used to move messages between them. It sets the scheduling and rule evaluation parameters that govern how captured messages are forwarded.
  • ALTER_PROPAGATION — Modifies attributes of an existing propagation, such as its rule set or scheduling characteristics, without removing and recreating the propagation.
  • DROP_PROPAGATION — Removes an existing propagation definition from the database, terminating the administrative configuration for that message flow.
  • STOP_PROPAGATION — Halts an active propagation, suspending the movement of messages while preserving the propagation's definition for later restart.
  • START_PROPAGATION — Activates a previously created or stopped propagation so that message flow resumes according to its configured rules.

Parameter lists are intentionally omitted here; ETRM documents only procedure names and package-level dependencies.

Tables Accessed

The ETRM metadata does not enumerate the specific tables referenced via APPS synonyms for this package. As an administrative utility, the package primarily manipulates Streams dictionary views and internal data dictionary objects rather than application tables. In practice, its work is reflected in the Streams and Advanced Queueing metadata (for example, queue and propagation definitions maintained by the Streams engine), and it interacts with the underlying SYS data dictionary structures that store propagation status and configuration. Application schemas do not directly read or write these tables through the package.

Usage Notes

Within EBS 12.1.1 and 12.2.2, DBMS_PROPAGATION_ADM is normally invoked indirectly. Higher-level packages such as DBMS_STREAMS_ADM_IVK and DBMS_STREAMS_ADM_UTL call it when performing Streams administration, and DBA or system-administrator tasks involving queue propagation may reference it directly. Custom code should treat it as a privileged infrastructure API: invocation requires the appropriate Streams and SYS-level privileges, and it should not be used in application-tier logic where a supported EBS API exists. It is typically reached from database administration scripts, Streams setup routines, or concurrent processing that configures distributed data replication, not from standard EBS forms.