Search Results dbms_streams_mc




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_MC is an Oracle-supplied PL/SQL package that provides the internal messaging and capture infrastructure used by Oracle Streams, the redo-based data replication and event-propagation feature of the Oracle database. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package is not a functional EBS API in the traditional business sense; it belongs to the database kernel layer (schema SYS) and supports the underlying change-capture mechanisms on which several EBS-relevant features depend, including Oracle Streams-based replication, Advanced Queuing propagation, and certain auditing or distribution configurations.

In the ETRM 12.2.2 metadata, DBMS_STREAMS_MC is classified under API classification OTHER, with an owner of SYS and a status of VALID. It is documented as a package with both a package specification and a package body. The package is referenced by one other package, DBMS_STREAMS_ADM_IVK, indicating that it functions as a lower-level utility invoked by the administrative interface layer of Oracle Streams rather than being called directly by application code.

Key Procedures and Functions

The ETRM documentation records zero documented procedures or functions for DBMS_STREAMS_MC. This absence reflects the internal, undocumented nature of the package: its subprograms are reserved for Oracle's own use and are not published for direct invocation by developers or administrators.

By design and naming convention, the "MC" suffix denotes the management and control component within the Oracle Streams subsystem. The package operates in conjunction with DBMS_STREAMS_ADM_IVK, which is the administrative invocation layer. Because no public procedure signatures are documented, parameter lists cannot be enumerated from the ETRM metadata, and the package should be treated as an internal dependency rather than a callable API. The dependency metadata confirms that DBMS_STREAMS_MC itself depends on SYS.DBMS_UTILITY and STANDARD, consistent with a utility package that relies on shared kernel services for its operations.

Tables Accessed

The ETRM metadata identifies no tables referenced through APPS synonyms for this package. Its work is performed against fixed SYS-owned dictionary and Streams repository objects, which are not exposed through the EBS application schema. Because DBMS_STREAMS_MC is a SYS-owned kernel package referenced only by another SYS-owned package (DBMS_STREAMS_ADM_IVK), any table access it performs is confined to the database dictionary layer rather than to EBS application tables such as those in the AP, GL, or INV schemas. Consequently, no EBS business table dependencies are documented, and the package does not participate in the EBS data model directly.

Usage Notes

DBMS_STREAMS_MC is not invoked from Oracle E-Business Suite forms, concurrent programs, or standard application logic. Its invocation occurs only through Oracle Streams administrative operations executed at the database tier, most commonly when an administrator configures or manages Streams capture processes, propagations, and apply processes. Custom code should never call this package directly, as its subprograms are undocumented, subject to change between database releases, and unsupported for external use.

For EBS 12.1.1 and 12.2.2 administrators, encountering DBMS_STREAMS_MC in dependency reports or during patching typically signals the presence of Oracle Streams configuration or an internal database feature relying on it. The appropriate response is to treat the package as a read-only system component, validating only that its status remains VALID and that its dependency chain through DBMS_STREAMS_ADM_IVK, DBMS_UTILITY, and STANDARD is intact. Direct modification or recompilation outside Oracle-supplied patch mechanisms is not recommended, and any tuning of Streams behavior should be performed exclusively through the supported DBMS_STREAMS_ADM interface.