Search Results dbms_repcat_conf




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_CONF is a server-side PL/SQL package body owned by the SYS schema and shipped as part of Oracle's built-in replication infrastructure. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package is present in the EBS database as a dependency of the Advanced Replication feature set rather than as an EBS application object. Its name, REPCAT_CONF, indicates that it handles the conflict resolution configuration portion of the Replication Catalog (REPCAT) API family, complementing sibling packages such as DBMS_REPCAT, DBMS_REPCAT_DECL, DBMS_REPCAT_MAS, and the DBMS_REPCAT_UTL utilities.

The object is reported as VALID in the EBS instance. It is exposed to the EBS technology stack as a SYS-owned package body and is classified under the OTHER API category because it is not an EBS-owned interface, but rather an Oracle database component surfaced through the EBS environment.

Key Procedures and Functions

The ETRM metadata for DBMS_REPCAT_CONF documents no individually named procedures or functions. This is consistent with the package being a package body whose public specification is defined by DBMS_REPCAT_DECL and invoked indirectly by the higher-level DBMS_REPCAT API. In practice, the package provides the internal logic that supports conflict resolution configuration in a replicated master group: defining resolution methods for update, delete, and uniqueness conflicts, registering resolution parameters, and maintaining resolution statistics for conflict detection and resolution columns.

Because the API surface is not individually documented in the ETRM extract, DBMS_REPCAT_CONF should be treated as an internal, subordinate implementation unit. Its routines are consumed by DBMS_REPCAT and its dependent packages rather than called directly by application developers.

Tables Accessed

The dependency listing shows DBMS_REPCAT_CONF operating primarily against the SYS schema replication catalog tables, including:

  • REPCAT$_CONFLICT, REPCAT$_RESOLUTION, and REPCAT$_RESOLUTION_STATISTICS — used to store conflict resolution definitions and runtime resolution statistics.
  • REPCAT$_RESOL_STATS_CONTROL — controls collection of resolution statistics.
  • REPCAT$_AUDIT_COLUMN, REPCAT$_COLUMN_GROUP, and REPCAT$_GROUPED_COLUMN — define the column groups against which conflicts are resolved.
  • REPCAT$_PRIORITY and REPCAT$_PRIORITY_GROUP, plus DBA_REPPRIORITY_GROUP — support priority-based resolution methods.
  • REPCAT$_PARAMETER_COLUMN, REPCAT$_REPCOLUMN, REPCAT$_REPOBJECT, and REPCAT$_GENERATED — track replicated objects, columns, and generated support objects.

In addition, the package body reads dictionary views and base tables such as ALL_CONSTRAINTS, ALL_REPOBJECT, ALL_TAB_COLUMNS, DBA_INDEXES, CCOL$, COL$, CON$, OBJ$, and USER$. These are consulted to validate constraints and column definitions when conflict resolution groups and methods are configured.

Usage Notes

DBMS_REPCAT_CONF is not referenced by any database object outside the replication catalog itself, and the ETRM metadata confirms it is not invoked directly by EBS forms, concurrent programs, or custom code. It is reached only through calls to the DBMS_REPCAT API, for example when an administrator defines or alters a conflict resolution method, enables resolution statistics collection, or modifies a column group. EBS customers who have configured multi-master or materialized-view replication will exercise this package indirectly whenever the replication catalog performs conflict resolution administration. Given the SYS ownership and internal nature of the package, its code should never be modified; all configuration changes involving conflict resolution must go through the documented DBMS_REPCAT procedures.