Search Results dbms_repcat_common_utl




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_COMMON_UTL is an internal Oracle-supplied PL/SQL package body residing in the SYS schema. In Oracle E-Business Suite 12.1.1 and 12.2.2, this package forms part of the underlying Oracle Advanced Replication infrastructure that EBS relies upon for multi-tier and multi-node deployments. Its business function is to provide a set of shared, common utilities that support the Replication Catalog (REPCAT) administration APIs — principally the DBMS_REPCAT family — by consolidating reusable low-level operations that would otherwise be duplicated across the replication management packages.

The package is a supporting element rather than a user-facing API. It does not expose procedures intended for direct invocation by EBS developers or administrators. Instead, it is consumed by the higher-level replication administration packages, which in turn are used internally by EBS during instance configuration, multi-org setups, and the administration of replicated objects across database tiers. The ETRM metadata confirms the object status is VALID in the documented environment.

Key Procedures and Functions

The ETRM documentation for this object records no documented procedures or functions under the API classification OTHER. This is consistent with the object's role as an internal helper package body: its routines are private implementation details invoked by sibling packages rather than published entry points.

  • No public procedures or functions are documented for SYS.DBMS_REPCAT_COMMON_UTL in the ETRM metadata.
  • All behavior is encapsulated within the package body and is reachable only through the packages that depend on it.
  • Parameter lists are intentionally omitted, as no documented signatures exist to cite.

Attempts to invoke members of this package directly from custom EBS code are not supported; the package should be treated as internal to the replication subsystem.

Tables Accessed

The ETRM dependency listing documents that the package body references a specific set of data dictionary and replication catalog tables. These accesses underlie its utility role in managing replication metadata.

  • DEPENDENCY$ , OBJ$, TAB$ — core data dictionary tables used to resolve object identities, dependencies, and table attributes during replication administration.
  • DBA_OBJECTS — consulted to validate object existence, type, and status.
  • REPCAT$_CDEF — holds column definitions for replicated tables.
  • REPCAT$_EXTENSION — stores extension metadata for replication objects.
  • REPCAT$_REPSCHEMA — maintains the schema-level replication configuration.
  • REPCAT$_SITES_NEW — tracks site information relating to replication groups.
  • SYSTEM — referenced for general replication bookkeeping.

Usage Notes

SYS.DBMS_REPCAT_COMMON_UTL is not intended for direct invocation from Oracle EBS forms, concurrent programs, or custom application code. It is a component of the Oracle Advanced Replication stack and is called transparently by the replication administration packages. The ETRM metadata indicates the package body depends on DBMS_REPCAT_DECL, DBMS_REPCAT_UTL, DBMS_REPUTIL2, DBMS_SYS_ERROR, and DBMS_UTILITY, and that it is referenced by 24 other database packages — underscoring its role as shared infrastructure rather than a standalone API.

Administrators working with EBS 12.1.1 or 12.2.2 may encounter this object during replication setup, patching, or diagnostics. Remediation efforts should focus on the calling packages and the integrity of the REPCAT catalog tables, not on this package directly. Because it is a SYS-owned, Oracle-proprietary object, it must never be modified, and any recompilation should be left to supported Oracle tooling.