Search Results dbms_xstream_gg_internal

Overview

SYS.DBMS_XSTREAM_GG_INTERNAL is an Oracle-supplied, wrapped PL/SQL package that forms part of the internal infrastructure supporting Oracle GoldenGate and Oracle Streams based data replication. Within Oracle E-Business Suite 12.1.1 and 12.2.2, the package resides in the SYS schema and is classified under the ETRM API classification of OTHER, indicating that it is not exposed as a supported public application programming interface for EBS developers. Its primary business function is to provide the low-level runtime mechanisms that GoldenGate and XStream capture and apply processes rely upon when interacting with an EBS database, including the management of internal metadata, session state, and bookkeeping structures needed to track change data capture activity.

The package is shipped in wrapped (obfuscated) form, which is consistent with Oracle's practice of protecting the source of internal replication components. The wrapped body prevents direct inspection of the PL/SQL logic, and Oracle does not publish a formal reference guide for its internal callable units. Consequently, the package functions as a supporting dependency rather than an integration point for customer-written code.

Key Procedures and Functions

The documented ETRM metadata for this package lists zero publicly documented procedures or functions. All callable units are internal and reserved for use by Oracle GoldenGate and XStream components. Because no parameter lists are published, specific routines should not be invoked or referenced directly from custom EBS code. Any procedure or function inside the wrapped body is subject to change between patch levels and database releases without notice from Oracle, reinforcing the position that DBMS_XSTREAM_GG_INTERNAL is a private implementation package rather than a supported API.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. This is expected, since the package resides in SYS and operates on Oracle internal data dictionary and replication metadata objects rather than on EBS application tables. Any underlying dictionary or XStream/GoldenGate metadata accessed by the wrapped body remains subject to Oracle's internal design and is not part of the documented EBS data model.

Usage Notes

DBMS_XSTREAM_GG_INTERNAL is typically invoked indirectly. It may be called during the configuration, startup, shutdown, or runtime execution of GoldenGate capture and apply processes, and by related Oracle Streams and XStream packages. EBS administrators normally encounter it only when configuring data replication or diagnosing replication-related errors, not through a form or concurrent program that references the package by name.

The package is referenced by three other packages, indicating its role as a dependency within the broader replication stack. Because it is a wrapped SYS-owned package with no documented public interface, custom EBS development should not call it directly. Instead, supported replication tasks should be performed through Oracle GoldenGate utilities, the DBMS_XSTREAM_ADM and DBMS_CAPTURE_ADM packages, or other documented Oracle interfaces. Any direct invocation carries a high risk of incompatibility following database upgrades or EBS patch application.

PACKAGE: SYS.DBMS_XSTREAM_GG_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_GG_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_GG_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_GG_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_GG_INTERNAL 12.2.2
PACKAGE: SYS.DBMS_XSTREAM_GG_ADM 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_GG_ADM, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_UTL_IVK 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_UTL_IVK, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_UTL_IVK 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_UTL_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_GG_INTERNAL 12.1.1
PACKAGE: SYS.DBMS_LOGMNR_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGMNR_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG_ADM, status:VALID,
LIBRARY: SYS.DBMS_LOGREP_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_LOGREP_LIB, status:VALID,
LIBRARY: SYS.DBMS_LOGREP_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_LOGREP_LIB, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_GG_ADM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_GG_ADM, status:VALID,
PACKAGE: SYS.DBMS_LOGMNR_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGMNR_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADM_UTL_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM_UTL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADM_UTL_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM_UTL_INVOK, status:VALID,
TABLE: SYS.APPLY$_CDR_INFO 12.1.1
owner:SYS, object_type:TABLE, object_name:APPLY$_CDR_INFO, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG_INTERNAL 12.2.2
PACKAGE BODY: SYS.DBMS_XSTREAM_GG_INTERNAL 12.1.1
TABLE: SYS.APPLY$_CDR_INFO 12.2.2
owner:SYS, object_type:TABLE, object_name:APPLY$_CDR_INFO, status:VALID,
TABLE: SYS.APPLY$_ERROR 12.2.2
owner:SYS, object_type:TABLE, object_name:APPLY$_ERROR, status:VALID,
TABLE: SYS.APPLY$_ERROR 12.1.1
owner:SYS, object_type:TABLE, object_name:APPLY$_ERROR, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_UTILITY 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_UTILITY, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_UTILITY 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_UTILITY, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
SYS.DBMS_XSTREAM_GG dependencies on DBMS_XSTREAM_GG_INTERNAL 12.1.1
SYS.DBMS_XSTREAM_GG_ADM dependencies on DBMS_XSTREAM_GG_INTERNAL 12.2.2
SYS.DBMS_STREAMS_ADM_UTL_INVOK dependencies on DBMS_XSTREAM_GG_INTERNAL 12.2.2
SYS.DBMS_XSTREAM_GG_INTERNAL dependencies on DBMS_XSTREAM_GG_INTERNAL 12.1.1
SYS.DBMS_XSTREAM_GG_INTERNAL dependencies on DBMS_XSTREAM_GG_INTERNAL 12.2.2
SYS.DBMS_XSTREAM_GG_ADM dependencies on DBMS_XSTREAM_GG_INTERNAL 12.1.1
SYS.DBMS_XSTREAM_GG dependencies on DBMS_XSTREAM_GG_INTERNAL 12.2.2
SYS.DBMS_STREAMS_ADM_UTL_INVOK dependencies on DBMS_XSTREAM_GG_INTERNAL 12.1.1
PACKAGE: SYS.DBMS_STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,