Search Results dbms_xstream_utl_ivk




Overview
Explore in AI Chat

Overview

SYS.DBMS_XSTREAM_UTL_IVK is an Oracle-supplied PL/SQL package that forms part of the Oracle Streams / XStream infrastructure bundled with the database kernel. Its name reflects its role as an internal utility helper for XStream — the "UTL" prefix denotes a utility package, and the "IVK" suffix designates it as an internal invocation helper rather than a user-facing API. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is not an EBS application object. It resides in the SYS schema, is shipped with the RDBMS, and becomes visible to EBS administrators only because EBS auditing utilities such as ETRM (E-Business Suite Technical Reference Manual) enumerate all valid SYS objects that participate in the dependency graph of installed components.

The package carries a VALID status, indicating that it is compiled and operational in the database. It references DBMS_UTILITY and the STANDARD package, which confirms its role as a low-level plumbing layer rather than a business-logic component. Its consumers are the higher-level Streams administration packages, most notably DBMS_XSTREAM_ADM, DBMS_XSTREAM_GG_ADM, and DBMS_XSTREAM_GG_INTERNAL, together with a recursive self-reference. This dependency topology demonstrates that DBMS_XSTREAM_UTL_IVK is an internal support layer sitting beneath the documented XStream administrative APIs.

Key Procedures and Functions

The ETRM metadata documents zero procedures or functions for this package. This is consistent with its classification as an internal helper object: no public callable API is exposed through ETRM because the package is not intended for direct customer or application invocation. The absence of documented entry points does not imply that the package body is empty; rather, it indicates that ETRM has no exposed signature metadata to publish.

Functionally, an "invocation"-oriented XStream utility of this type exists to marshal calls between the Streams administrative layer and the underlying capture/apply engine — resolving and dispatching internal operations on behalf of the parent packages that reference it. Because ETRM lists no procedures, no parameter lists can be described, and none are inferred here.

Tables Accessed

The ETRM dependency extract for SYS.DBMS_XSTREAM_UTL_IVK documents no tables referenced via APPS synonyms, and no underlying base tables are enumerated. This is expected: the package is a code-dispatch utility operating through internal kernel interfaces rather than issuing direct DML against EBS application tables. XStream infrastructure of this class typically interacts with internal Streams dictionary views and the Streams metadata stored in the SYS schema; however, the ETRM record does not identify specific tables, and none are claimed here beyond the documented dependency on SYS.DBMS_UTILITY and STANDARD.

Usage Notes

DBMS_XSTREAM_UTL_IVK is never invoked directly by Oracle E-Business Suite forms, concurrent programs, or supported customization code. It is called indirectly whenever the referencing packages — DBMS_XSTREAM_ADM, DBMS_XSTREAM_GG_ADM, or DBMS_XSTREAM_GG_INTERNAL — execute their XStream configuration or administration logic. In EBS 12.1.1 the Streams stack is commonly associated with Advanced Queuing and data-replication features, while in 12.2.2 the online patching (adop) infrastructure and edition-based redefinition may exercise Streams-related code paths through these same administrative packages.

  • Do not grant EXECUTE on this package to application schemas; access should remain restricted to SYS and privileged DBA use through the parent XStream packages.
  • Treat the package as read-only infrastructure. Modifying or recompiling it is unsupported and may invalidate dependent XStream administration packages.
  • When troubleshooting XStream or Streams errors in an EBS database, examine invalidation status across the full dependency chain — DBMS_XSTREAM_ADM, DBMS_XSTREAM_GG_ADM, DBMS_XSTREAM_GG_INTERNAL, and this package — since an invalidity here will cascade upward.
  • Confirm existence and VALID status during post-install or post-upgrade database verification, particularly after RDBMS patch application.

In summary, SYS.DBMS_XSTREAM_UTL_IVK is an internal, ETRM-visible SYS utility that supports Oracle XStream administration. It has no documented public procedures, no documented APPS-synonym table access, and is referenced exclusively by other Streams/XStream packages. EBS administrators should recognize it as background database infrastructure rather than an application-level API.