Search Results dbms_xstream_gg_adm




Overview
Explore in AI Chat

Overview

SYS.DBMS_XSTREAM_GG_ADM is a server-side PL/SQL package owned by the SYS schema and shipped as part of the Oracle Database kernel. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, it is an internal administrative package that supports Oracle GoldenGate (OGG) integration with Oracle Streams and Oracle XStream. It provides the programmatic layer through which capture and apply processes are configured, administered, and controlled when EBS data is replicated to or from external systems using GoldenGate-based logical replication.

The package is classified as VALID and is documented in ETRM as an OTHER-type API, meaning it is a database infrastructure package rather than a formally documented EBS application program interface. It does not implement business logic for any EBS module; instead, it underpins the data-replication and high-availability mechanisms that EBS deployments use for reporting offload, data warehousing feeds, or disaster-recovery topologies.

Key Procedures and Functions

The ETRM metadata for this package documents zero exposed procedures or functions at the EBS level. Because DBMS_XSTREAM_GG_ADM is an internal administrative package, its entry points are not published as callable EBS APIs and are not intended for direct customer invocation. Functionally, the package serves as the administrative engine that GoldenGate and XStream rely on to register capture and apply processes, manage rule sets, and coordinate the underlying Streams propagation configuration.

The absence of documented procedures in ETRM is consistent with its role as a dependency-only package: it is referenced by other internal packages rather than surfacing its own public interface. Any procedures it does contain are called indirectly through the higher-level administrative packages listed in its dependency chain.

Tables Accessed

ETRM does not document any base tables accessed directly by DBMS_XSTREAM_GG_ADM through APPS synonyms. As an SYS-owned streaming package, its data access is confined to SYS-owned Streams and XStream dictionary views and internal metadata rather than to EBS application tables. The package operates on the Streams capture, propagation, and apply metadata that Oracle maintains in the data dictionary to track GoldenGate process configuration. Because it acts at the database level, it does not read or write EBS transactional tables such as those in the AP, GL, or INV schemas.

Usage Notes

DBMS_XSTREAM_GG_ADM is referenced by eleven other packages, including DBMS_APPLY_ADM, DBMS_APPLY_ADM_INTERNAL, DBMS_CAPTURE_ADM, DBMS_CAPTURE_ADM_INTERNAL, DBMS_STREAMS_ADM_UTL_INVOK, DBMS_STREAMS_RPC, DBMS_XSTREAM_ADM_UTL, and DBMS_XSTREAM_GG_INTERNAL. It also references DBMS_UTILITY and ANYDATA. This dependency structure confirms that it functions as a shared internal building block for the Streams and XStream administrative stack, called by the higher-level packages that DBAs and GoldenGate tooling invoke.

In an EBS environment, this package is never called from a Forms-based or concurrent-program flow. It is invoked only indirectly when a DBA configures or operates GoldenGate-based replication against the EBS database. It should be treated as an internal Oracle component: custom code must not call it directly, and any dependency on it is expected to change as Oracle migrates Streams-based replication toward XStream and GoldenGate. Oracle does not support direct customer use of this package, and its documented status reflects a kernel-level dependency rather than a supported EBS extension point.