Search Results dbms_streams_adm_ivk




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_ADM_IVK is an Oracle-supplied internal package that is technically distinct from, but functionally bound to, the public DBMS_STREAMS_ADM package. The suffix _IVK follows Oracle's internal naming convention for "invoke" or wrapper routines: the package exists so that Oracle's own administrative packages can call protected or signature-stable entry points without exposing them directly. The object is owned by SYS and reports a status of VALID in Oracle E-Business Suite environments on both 12.1.1 and 12.2.2.

In the EBS context, the package participates in the Oracle Streams and XStream replication infrastructure. Oracle Streams underpins several EBS features — logical standby, Advanced Replication coexistence, and data propagation between primary and reporting instances — and DBMS_STREAMS_ADM is the public administrative interface to configure those capture, propagation, and apply processes. DBMS_STREAMS_ADM_IVK is the internal invoke layer that DBMS_STREAMS_ADM, DBMS_XSTREAM_ADM, DBMS_XSTREAM_GG_ADM, and DBMS_XSTREAM_UTL_IVK reference when executing their operations. It does not represent a business function of EBS itself; it is part of the database kernel plumbing that EBS inherits from the Oracle home.

Key Procedures and Functions

The ETRM metadata for this object documents zero procedures or functions. No public parameter lists are exposed for DBMS_STREAMS_ADM_IVK, which is consistent with its status as an internal invoke package: its callable units are not intended for direct customer invocation and are therefore not published in the EBS object repository.

Consequently, no procedure signatures are described here. Any routine that appears in the package body should be considered Oracle-internal and subject to change between patch sets and database versions. Developers should treat the package as a black box and interact only with the documented public packages — DBMS_STREAMS_ADM, DBMS_XSTREAM_ADM — that Oracle publishes and supports.

Tables Accessed

The documented metadata does not list any tables referenced through APPS synonyms. This is expected: the package operates in the SYS schema against Oracle Streams data dictionary and queue infrastructure rather than against EBS application tables. Its dependency list shows references to DBMS_STREAMS_TABLESPACE_ADM, DBMS_UTILITY, the ANYDATA type, and the STANDARD package — all SYS-level constructs associated with Streams administration, LCR handling, and generic PL/SQL utilities.

Because the package is referenced by DBMS_STREAMS_ADM, DBMS_XSTREAM_ADM, DBMS_XSTREAM_GG_ADM, and DBMS_XSTREAM_UTL_IVK, its operations are driven indirectly whenever an administrator configures or tears down a Streams or XStream capture, propagation, or apply process. The affected persistence lives in the Streams queue tables and dictionary views, not in EBS application schema objects.

Usage Notes

DBMS_STREAMS_ADM_IVK should never be invoked directly from EBS forms, concurrent programs, or custom code. It is an internal dependency of the supported Streams and XStream administration packages and is maintained exclusively by Oracle. Customizations, patches, or scripts that call it risk breakage on upgrade, since Oracle may alter internal invoke signatures without notice.

From an EBS support perspective, the package becomes relevant chiefly during diagnostics. When Streams configuration fails during cloning, logical standby setup, or replication maintenance, DBAs may trace execution through DBMS_STREAMS_ADM and observe DBMS_STREAMS_ADM_IVK frames in the call stack. Validating the package — confirming its status is VALID and its dependencies compile — is a standard remediation step. The recommended practice is to operate only through the public Streams APIs and to leave DBMS_STREAMS_ADM_IVK untouched, treating it purely as a system-managed component of the Oracle database home.