Search Results dbms_streams_adm_utl_invok




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_ADM_UTL_INVOK is an Oracle-supplied PL/SQL package that resides in the SYS schema and carries a VALID status in Oracle E-Business Suite 12.1.1 and 12.2.2. It is not an end-user or application-facing API. Rather, it is an internal infrastructure package that belongs to the Oracle Streams / XStream family of data replication and change-data-capture components. Its name — a contraction of "Streams Administrative Utility Invoke" — identifies it as a routing and invocation utility used by the higher-level Streams and XStream administrative packages rather than by any EBS business module.

Within the ETRM metadata the package is classified as OTHER under the SYS owner, confirming that it is a kernel-level dependency rather than a documented EBS public API. No callable procedures or functions are exposed in the ETRM documentation, underscoring its role as an internal helper invoked indirectly by other supplied packages. In EBS environments it becomes relevant chiefly because Streams underpins certain advanced replication, materialized view refresh, and data-integration scenarios that EBS installations may configure.

Key Procedures and Functions

The ETRM documentation records zero documented procedures or functions for this package. Its subprograms are internal and undocumented, and no parameter lists are published. The functionality it delivers is visible only through the packages that depend on it. Based on the dependents listed in the metadata — DBMS_APPLY_ADM, DBMS_COMPARISON, DBMS_STREAMS, DBMS_STREAMS_ADM_IVK, DBMS_XSTREAM_ADM, DBMS_XSTREAM_GG_ADM, and DBMS_XSTREAM_UTL_IVK — the package provides shared invocation and validation support for apply-process administration, Streams and XStream configuration, and comparison operations. Because the routines are not part of a supported public interface, they should never be called directly from custom code.

Tables Accessed

The metadata does not list any tables referenced through APPS synonyms, which is expected: the package operates through SYS-owned Streams dictionary objects rather than EBS application tables. As part of the Streams administrative layer it works with the underlying replication metadata — rule sets, capture and apply queues, and the associated SYS dictionary tables — but these accesses are internal and not exposed as documented dependencies. No EBS transactional or interface tables are read or written by this package.

Usage Notes

SYS.DBMS_STREAMS_ADM_UTL_INVOK is not invoked from EBS forms, concurrent programs, or supported custom code. It is called exclusively by the seven dependent SYS packages identified in the ETRM dependency listing. Its presence in the database is a structural consequence of Oracle Streams and XStream components being installed; the package becomes active only when an administrator configures or administers Streams-based replication or XStream capture and apply processes.

For EBS administrators the practical implications are threefold. First, the package must remain VALID for dependent Streams and XStream APIs to compile and execute, so any recompilation of invalid SYS objects after patching should include it. Second, because its subprograms are undocumented and carry no public interface, developers and DBAs should not call or wrap them. Third, when troubleshooting Streams or XStream errors in an EBS 12.1.1 or 12.2.2 environment, the package should be treated as a supporting component of the affected Streams API rather than as the root cause unless the package itself has been rendered INVALID. Any direct invocation falls outside Oracle's supported usage.