Search Results dbms_repcat_utl2




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_UTL2 is an internal Oracle-supplied PL/SQL package that forms part of the Advanced Replication infrastructure underpinning Oracle E-Business Suite Release 12.1.1 and 12.2.2. It resides in the SYS schema and holds VALID status in the documented environment. The package is not an end-user API; it is an implementation-level utility invoked by higher-level replication management packages such as DBMS_REPCAT_RPC, DBMS_REPCAT_RQ, DBMS_REPCAT_CONF, and DBMS_REPCAT_FLA_MAS. Its role is to support the comparison, versioning, and metadata inspection of replicated schema objects, particularly replicated columns, object types, and referential constraints, during replication group configuration and flavor generation. In EBS terms, this package silently enables multi-org and multi-site data synchronization across distributed database instances.

Key Procedures and Functions

The ETRM metadata for DBMS_REPCAT_UTL2 documents no callable procedures or functions exposed to clients; the API classification is OTHER. The package body nevertheless contains internal routines, one of which — GET_OLDVERSION_HASHCODE2 — is explicitly listed as a dependency. This function generates a hash code representing the prior (old) version definition of a replicated object so that replication metadata changes can be detected and reconciled. Because the procedures are not published for external invocation, they should not be called directly from custom code; only the enclosing replication packages are documented consumers.

Tables Accessed

The package reads and writes a defined set of dictionary and replication catalog tables. Data dictionary objects include ATTRCOL$, COL$, COLTYPE$, OBJ$, OPQTYPE$, REFCON$, TYPE$, and USER$, which supply column attributes, datatypes, object type definitions, and referential constraint metadata. Replication-specific tables include DBA_REPFLAVOR_COLUMNS and REPCAT_REPCOLUMN_BASE, which store flavor column definitions and the base replicated column catalog used during conflict resolution and subsetting. It also invokes supporting utilities from DBMS_REPCAT, DBMS_REPCAT_COMMON_UTL, DBMS_REPCAT_DECL, DBMS_UTILITY, UTL_RAW, and STANDARD.

Usage Notes

No Oracle EBS form, concurrent program, or public API in the documented ETRM repository invokes DBMS_REPCAT_UTL2 directly. It is referenced solely by five other replication packages: DBMS_REPCAT_CONF, DBMS_REPCAT_FLA_MAS, DBMS_REPCAT_RPC, DBMS_REPCAT_RQ, and DBMS_REPCAT_UTL4 (plus a self-reference). Customers and consultants should treat it as a black box. Any customization that attempts to call its internal routines directly risks invalidating replication metadata and is unsupported. When troubleshooting replication errors in EBS, DBAs should focus on the public DBMS_REPCAT interfaces and validate that this package remains VALID after patches.