Search Results dbms_repcat_sna_utl




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_SNA_UTL is an Oracle-supplied PL/SQL package that forms part of the symmetric replication infrastructure underlying Oracle E-Business Suite Advanced Replication in release 12.1.1 and 12.2.2. The package name derives from "replication catalog — snapshot utility," and its role is to provide the low-level utility routines that create, refresh, and manage snapshot (materialized view) definitions used by the replication subsystem. Although the package resides in the SYS schema and is therefore not directly exposed to EBS application code, it is essential to the internal plumbing that allows distributed EBS deployments to synchronize configuration and reference data across database nodes.

The ETRM metadata records the package with a status of VALID and classifies it as OTHER, meaning it is an internal, undocumented Oracle kernel component rather than a published EBS API. It is activated whenever snapshot-based replication is configured, for example in multi-node EBS installations that replicate setup data between the primary and secondary application database tiers.

Key Procedures and Functions

The ETRM documentation lists no public procedures or functions for this package; it contains only a package specification, a package body, and internal SQL statements. As an undocumented internal utility, DBMS_REPCAT_SNA_UTL does not expose callable entry points that EBS developers are expected to invoke directly. Its routines are consumed exclusively by other replication packages within the SYS schema.

The dependency listing confirms this architectural role. The package references SYS.DBMS_REPCAT_DECL, the shared declaration unit that defines replication data structures, DBMS_SYS_SQL, Oracle's dynamic SQL execution facility, and the STANDARD package that underpins all PL/SQL execution. This combination indicates that the utilities rely on dynamically constructed SQL to manipulate snapshot metadata stored in the replication catalog.

Tables Accessed

The metadata records no EBS application tables accessed through APPS synonyms, which is consistent with the package's kernel-level function. Internally, the package operates against the Oracle replication catalog objects maintained in the SYS schema, including the DBA_REPCAT and related snapshot metadata views that track registered snapshot sites, refresh groups, and object definitions. These catalog structures are read and written during snapshot registration and refresh operations rather than through any EBS-facing synonym.

Usage Notes

DBMS_REPCAT_SNA_UTL is not invoked from Oracle EBS forms, concurrent programs, or supported customization points. It is called internally by higher-level replication packages, as established by the dependency chain in the ETRM record. The package is referenced by nine other SYS packages: DBMS_REPCAT_SNA_INTERNAL, DBMS_REPCAT_UTL, DBMS_REPCAT_UTL2, DBMS_REPCAT_FLA, DBMS_REPCAT_DEFINER, DBMS_REPCAT_UNTRUSTED, DBMS_OFFLINE_OG_INTERNAL, DBMS_OFFLINE_SNAPSHOT_INTERNAL, and DBMS_STREAMS_ADM_UTL. The presence of DBMS_STREAMS_ADM_UTL demonstrates that the same snapshot utilities are shared between classic Advanced Replication and Streams-based replication.

Administrators should treat this package as read-only Oracle intellectual property. Any invalidation or modification risks breaking snapshot creation and refresh across the EBS database estate. Validation status should be monitored through the standard data dictionary views, and the package should only be recompiled as part of an Oracle-supplied patch or database upgrade.