Search Results dbms_xstream_gg




Overview
Explore in AI Chat

Overview

SYS.DBMS_XSTREAM_GG is a core Oracle Database PL/SQL package that underpins the Oracle Streams and GoldenGate capture, propagation, and apply infrastructure. Within an Oracle E-Business Suite 12.1.1 or 12.2.2 environment, it is not an EBS application-layer API. It belongs to the SYS schema, is marked VALID, and is classified under the ETRM as an "OTHER" API — meaning it is not an EBS product-owned interface such as an FND or AR package, but a database-supplied utility that EBS relies upon indirectly through the replication and change-data-capture features of the underlying RDBMS.

Its business function in EBS is to expose the low-level primitives that Oracle Streams and Oracle GoldenGate use to manage the apply process, rule sets, and subscriber configuration. It is the plumbing layer that DBMS_APPLY_ADM and related administrative packages call into, rather than an interface that an EBS functional user or form invokes directly.

Key Procedures and Functions

The ETRM metadata for this object reports zero documented procedures or functions, and the dependency listing does not enumerate a callable surface. This is consistent with the package's role as an internal, SYS-owned implementation package whose entry points are consumed by other Oracle-supplied packages rather than published for application developers.

Because the documented procedure list is empty, no specific routine names or parameter signatures are asserted here. Attempting to name individual procedures would require inventing signatures, which the ETRM data does not support. Readers should treat DBMS_XSTREAM_GG as an internal component and consult Oracle's own GoldenGate and Streams documentation for the supported, externally callable API — typically DBMS_XSTREAM_ADM, DBMS_CAPTURE_ADM, and DBMS_APPLY_ADM.

Tables Accessed

The ETRM excerpt does not list any tables referenced through APPS synonyms, which is expected given the package's SYS ownership and internal scope. DBMS_XSTREAM_GG operates on Oracle Streams dictionary objects — the apply, capture, and propagation metadata maintained in the database's SYS-owned views and tables — rather than on EBS application tables. In an EBS context, any downstream effect on EBS data occurs because those Streams processes replicate or apply changes to EBS schemas, not because DBMS_XSTREAM_GG itself targets APPS synonyms.

Usage Notes

DBMS_XSTREAM_GG is referenced by four other packages per the documented metadata: DBMS_APPLY_ADM, DBMS_APPLY_ADM_INTERNAL, DBMS_APPLY_HANDLER_INTERNAL, and DBMS_LOGREP_UTIL, with DBMS_XSTREAM_GG also appearing as a self-reference. This dependency chain confirms its position beneath the apply administration layer.

  • It is not invoked from EBS Forms, OAF pages, or standard concurrent programs.
  • Custom code should never call it directly; Oracle does not document it as a public API, and its contract may change across database versions.
  • It becomes visible in EBS troubleshooting when Streams or GoldenGate replication is configured against an EBS database, particularly for apply-process diagnostics.
  • Because it is a SYS-owned, VALID package, any invalid state or compile failure in a dependency can surface as a broader Streams outage affecting EBS-integrated replication.

In summary, DBMS_XSTREAM_GG is internal RDBMS replication infrastructure supporting Oracle Streams and GoldenGate within EBS 12.1.1 and 12.2.2, and it should be regarded as a dependency to be aware of rather than a callable EBS interface.