Search Results dbms_streams_mt




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_MT is an Oracle-supplied PL/SQL package that forms part of the Oracle Streams replication infrastructure. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package provides the low-level "maintenance" layer that underpins the higher-level Oracle Streams administrative APIs. Its principal business function is to support the configuration, capture, propagation, and apply processes that move data changes between EBS database instances — most notably in advanced replication, data guard-style change propagation, and the change-capture mechanisms used by certain EBS integration and reporting solutions.

The package is owned by the SYS schema and is reported with a status of VALID in the ETRM metadata. It is classified under the "OTHER" API category rather than as a functional EBS application API, reflecting its role as an Oracle database kernel utility rather than an EBS business interface. Because it operates at the database infrastructure tier, it is largely transparent to EBS application users but is leveraged indirectly whenever Streams-based replication is configured on an EBS database.

Key Procedures and Functions

The ETRM metadata documents no public procedures or functions for SYS.DBMS_STREAMS_MT; the package body is marked as protected and its callable routines are not enumerated in the reference documentation. This is consistent with its status as an internal Oracle Streams maintenance package, whose members are considered Oracle proprietary and are not exposed as supported public APIs.

Functionally, the package serves as the maintenance engine invoked by the Streams administration packages. Its responsibilities include management of Streams metadata objects such as rules, rule sets, capture processes, propagation jobs, and apply processes, as well as the internal bookkeeping required to keep those components consistent. Because no member signatures are documented, callers should treat this package as reserved for Oracle internal use rather than as an integration surface.

Tables Accessed

The ETRM metadata does not list tables accessed through APPS synonyms for this package. As a SYS-owned Oracle Streams component, DBMS_STREAMS_MT works primarily with the underlying Streams dictionary and metadata views and tables that reside in the SYS schema — the persistent structures that record rule sets, capture and apply configurations, and propagation status. In an EBS environment, the package therefore does not directly read or write EBS application tables (such as those in AP, GL, or INV); any EBS data it touches is handled indirectly through the change capture streams configured on those schemas.

Usage Notes

SYS.DBMS_STREAMS_MT is referenced by seven other packages, including DBMS_STREAMS_ADM_IVK, DBMS_STREAMS_ADM_UTL, DBMS_STREAMS_DATAPUMP_UTIL, DBMS_STREAMS_MC, DBMS_RECO_SCRIPT_INVOK, and DBMS_STREAMS_TABLESPACE_ADM, as well as by itself. This inbound dependency chain confirms that it is an internal dependency of the Streams administration and management packages rather than a directly invoked API.

In typical EBS 12.1.1 and 12.2.2 deployments, DBMS_STREAMS_MT is not called from Oracle Forms, concurrent programs, or custom application code. Instead, it is invoked indirectly when a DBA or Oracle-supplied script configures Oracle Streams using DBMS_STREAMS_ADM or related administrative packages. Support and development teams generally interact with the higher-level Streams APIs; direct calls to DBMS_STREAMS_MT are unsupported and should be avoided. It depends on DBMS_STANDARD, DBMS_UTILITY, DBMS_STREAMS_TABLESPACE_ADM, UTL_FILE, and STANDARD, and its presence in a valid state is a prerequisite for Streams-based replication features in the EBS database tier.