Search Results dbms_xstream_adm_utl




Overview
Explore in AI Chat

Overview

SYS.DBMS_XSTREAM_ADM_UTL is an Oracle-supplied PL/SQL package that resides in the SYS schema and holds a documented status of VALID in the ETRM repository for Oracle E-Business Suite 12.1.1 and 12.2.2. It is a supporting utility package for the Oracle Streams / XStream administrative framework rather than an end-user API. Its principal role is to provide internal helper logic consumed by the higher-level XStream administration packages, notably DBMS_XSTREAM_ADM, DBMS_XSTREAM_AUTH, DBMS_APPLY_ADM, and DBMS_CAPTURE_ADM_IVK. In the E-Business Suite context, this package belongs to the infrastructure tier that underpins data replication, change capture, and messaging used by advanced deployment architectures. Because it is classified as an OTHER API in the ETRM metadata and exposes no documented procedures or functions, it is treated as a private implementation layer, not as a callable interface for EBS functional or technical users.

Key Procedures and Functions

The ETRM documentation records zero publicly documented procedures or functions for SYS.DBMS_XSTREAM_ADM_UTL. The package is documented at the object level only, with both a specification and a package body registered as valid. Because no callable subprograms are catalogued, no parameter lists or signatures are published here. The package functions internally as a utility library supplying shared routines to the administrative packages that reference it. Practically, its callable surface is limited to the routines its dependent packages require, and Oracle does not expose these as supported entry points. Users should treat the package as an internal dependency and should not invoke its subprograms directly.

Tables Accessed

The ETRM metadata does not document any EBS tables or APPS synonyms accessed by SYS.DBMS_XSTREAM_ADM_UTL. The dependency listing identifies only other SYS objects, specifically ANYDATA, DBMS_UTILITY, and STANDARD. This indicates that the package operates against Oracle Streams data dictionary views and internal XStream metadata rather than against E-Business Suite application tables. Any data dictionary access performed by the package is confined to the Streams/XStream configuration and runtime views maintained by the database, which are outside the scope of EBS application schema objects.

Usage Notes

Within Oracle EBS 12.1.1 and 12.2.2, SYS.DBMS_XSTREAM_ADM_UTL is never invoked directly from forms, concurrent programs, or supported custom code. It is referenced exclusively by other SYS packages, primarily DBMS_XSTREAM_ADM and DBMS_XSTREAM_AUTH, and by internal invocation packages such as DBMS_CAPTURE_ADM_IVK, DBMS_APPLY_ADM, DBMS_LOGREP_UTIL, DBMS_XSTREAM_GG_ADM, and DBMS_XSTREAM_UTL_IVK. The metadata records eight dependent packages in total, confirming its position as a shared internal dependency rather than a top-level API. Customizations and third-party integrations should call the documented XStream administration packages instead of this utility package. Because it is an Oracle proprietary and confidential object, its internal logic is not published, and direct calls are unsupported and may change without notice across database releases.