Results for “dbms_streams_adm_utl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SYS.DBMS_STREAMS_ADM_UTL is an Oracle-supplied internal PL/SQL package body that provides the underlying utility layer for the DBMS_STREAMS_ADM administrative interface used by Oracle Streams. In Oracle E-Business Suite 12.1.1 and 12.2.2, this package is part of the database kernel infrastructure shipped under the SYS schema and is wrapped, meaning its PL/SQL source is obfuscated and not readable in cleartext.

Oracle Streams provides the capture, propagation, and apply engine used historically by EBS for data replication, distributed deployments, and certain Advanced Queuing and workflow propagation scenarios. DBMS_STREAMS_ADM_UTL encapsulates the low-level helper logic invoked by the public DBMS_STREAMS_ADM procedures, including validation of rules and rule sets, construction of internal Streams metadata, and manipulation of the dictionary objects that define capture and apply processes. Because it is an internal utility body, it is not intended for direct invocation by application code; EBS calls the supported DBMS_STREAMS_ADM entry points, which in turn dispatch to this utility package.

The ETRM classification of this object is OTHER, confirming that it is infrastructure rather than a documented EBS application API. No EBS-owned procedures or functions are individually documented, and there are no APPS synonym table references recorded.

Key Procedures and Functions

The ETRM metadata documents zero named procedures or functions for this package body. This is consistent with the object being a wrapped internal utility package: Oracle does not publish the internal subroutine signatures of DBMS_STREAMS_ADM_UTL in the EBS technical reference repository, and no supported public interface is exposed through it.

Functionally, the package serves as the shared implementation backend for the DBMS_STREAMS_ADM administrative operations. These include creation and alteration of Streams rules, rule sets, capture processes, propagation jobs, and apply processes, together with the validation and metadata lookups those operations require. Because the routines are internal and wrapped, they must not be called directly; doing so bypasses validation performed by the public administrative layer and is unsupported by Oracle.

No parameter lists are recorded in the source metadata, and none are reproduced here.

Tables Accessed

The ETRM metadata lists no tables referenced through APPS synonyms. This is expected, because DBMS_STREAMS_ADM_UTL belongs to SYS and operates on fixed internal Streams dictionary tables rather than on EBS application tables. Its work is performed against the Streams data dictionary views and base tables that store rule definitions, rule sets, capture and apply configuration, and propagation schedules.

Consequently, no EBS business tables such as those in the AP, GL, or ONT schemas are read or written by this package. Any data manipulation occurs within the Streams metadata repository, and access is controlled by the privileges granted to the invoking user.

Usage Notes

DBMS_STREAMS_ADM_UTL is not invoked directly from EBS forms, concurrent programs, or custom code. It is reached transitively when a supported Streams administrative procedure in DBMS_STREAMS_ADM executes. The ETRM metadata shows the package is referenced by 35 other packages, reflecting its central role as shared infrastructure for Streams administration and related replication features.

Because the body is wrapped, its logic cannot be inspected or modified, and it should be treated as read-only Oracle kernel code. In EBS 12.1.1 and 12.2.2, it is normally exercised only during database-level setup or maintenance of Streams replication, or when Oracle internal components that depend on Streams perform their configuration. Customers and integrators should use only the documented DBMS_STREAMS_ADM procedures; reliance on this internal package is unsupported and may break across database patch sets.