Search Results dbms_repcat_utl4

Overview

SYS.DBMS_REPCAT_UTL4 is an Oracle-supplied PL/SQL package that forms part of the internal Replication Catalog (REPCAT) infrastructure underlying Oracle's advanced replication feature set. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package resides in the SYS schema and carries a status of VALID. Its classification within the ETRM repository is OTHER, reflecting its role as an internal utility rather than a publicly documented application programming interface.

The package provides low-level helper logic consumed by the higher-level DBMS_REPCAT family of packages. These packages collectively manage multi-master and materialized-view replication used to synchronize data between EBS instances, support Multi-Org architectures, and propagate configuration and transactional changes across distributed deployments. DBMS_REPCAT_UTL4 does not expose business-facing functionality; instead, it encapsulates shared utility routines that the replication catalog API depends upon during object generation, deferred remote procedure call processing, and metadata maintenance.

Key Procedures and Functions

The ETRM documentation for this object does not enumerate any publicly documented procedures or functions. The recorded procedure count is zero, confirming that DBMS_REPCAT_UTL4 is an internal implementation package rather than a callable API. Customers and implementation teams are not expected to invoke its members directly, and no supported parameter lists are published.

Consistent with its dependency graph, the package's internal routines are used in three broad areas:

Assisting DBMS_REPCAT_UTL3 and DBMS_REPCAT_UTL4 itself by factoring out common helper logic shared between the two utility packages.
Supporting DBMS_REPCAT_RPC and DBMS_REPCAT_RQ in the assembly and dispensation of replication remote procedure calls and queued deferred transactions.
Backing master-group and master-site administration performed through DBMS_REPCAT_MAS, DBMS_REPCAT_ADD_MASTER, and DBMS_REPCAT_FLA_MAS, including the definition and definer-switching logic handled by DBMS_REPCAT_DEFINER.

Tables Accessed

ETRM does not document direct table access for DBMS_REPCAT_UTL4 through APPS synonyms, which is expected given that it is a SYS-owned internal package operating primarily on replication catalog dictionary tables rather than EBS application tables. Its functionality is exercised through the System Replication Catalog and its associated internal views and tables, which record replicated object definitions, master groups, sites, and generated replication support objects. The package also relies on dynamic SQL facilities via DBMS_SYS_SQL and DBMS_UTILITY, permitting it to construct and execute DDL and DML statements at runtime as replication metadata is created or altered.

Usage Notes

DBMS_REPCAT_UTL4 is never invoked from EBS forms, concurrent programs, or supported customization code. It is called exclusively from within the Oracle-supplied replication stack. Its position in the dependency hierarchy is well defined: it references DBMS_REPCAT, DBMS_REPCAT_DECL, DBMS_SYS_SQL, DBMS_UTILITY, and STANDARD, and it is referenced by ten packages, including DBMS_INTERNAL_REPCAT, DBMS_OFFLINE_INTERNAL, DBMS_OFFLINE_OG_INTERNAL, DBMS_REPCAT_ADD_MASTER, DBMS_REPCAT_DEFINER, DBMS_REPCAT_FLA_MAS, DBMS_REPCAT_MAS, DBMS_REPCAT_RPC, DBMS_REPCAT_RQ, and DBMS_REPCAT_UTL3, as well as recursively by itself.

Because the package is owned by SYS and is Oracle proprietary, its specification and body must not be modified. Any invalidations observed during patching, database upgrades, or replication reconfiguration should be resolved by recompiling the dependent SYS packages using standard utilities such as utlrp.sql, followed by verification that the package status returns to VALID.

PACKAGE: SYS.DBMS_REPCAT_UTL4 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL4 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE: SYS.DBMS_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL4 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL4, status:VALID,
PACKAGE: SYS.DBMS_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UTL4 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UTL4, status:VALID,
SEQUENCE: SYSTEM.REPCAT_LOG_SEQUENCE 12.2.2
owner:SYSTEM, object_type:SEQUENCE, object_name:REPCAT_LOG_SEQUENCE, status:VALID,
SEQUENCE: SYSTEM.REPCAT_LOG_SEQUENCE 12.1.1
owner:SYSTEM, object_type:SEQUENCE, object_name:REPCAT_LOG_SEQUENCE, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_FLA 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_FLA, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL2 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL2, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_OUTPUT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_OUTPUT, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL3 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_RPC 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_RPC 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_OUTPUT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_OUTPUT, status:VALID,
PACKAGE BODY: SYS.DBMS_INTERNAL_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_INTERNAL_REPCAT, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_CONF 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_CONF, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_CONF 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_CONF, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_ADMIN 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_ADMIN, status:VALID,
VIEW: SYS.DBA_OPARGUMENTS 12.2.2
owner:SYS, object_type:VIEW, object_name:DBA_OPARGUMENTS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_FLA 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_FLA, status:VALID,
PACKAGE BODY: SYS.DBMS_INTERNAL_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_INTERNAL_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_OG_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_DEFER_REPCAT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_REPCAT, status:VALID,
PACKAGE: SYS.DBMS_DEFER_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_REPCAT, status:VALID,
VIEW: SYS.DBA_OPERATORS 12.2.2
owner:SYS, object_type:VIEW, object_name:DBA_OPERATORS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL2 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL2, status:VALID,
VIEW: SYS.DBA_OPERATORS 12.1.1
owner:SYS, object_type:VIEW, object_name:DBA_OPERATORS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_MAS 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_UTL3 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_UTL3, status:VALID,
PACKAGE: SYS.DBMS_SYS_SQL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_SQL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RPC 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RPC, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_MAS 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE: SYS.DBMS_DEFER 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER, status:VALID,
PACKAGE: SYS.DBMS_DEFER 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER, status:VALID,
VIEW: SYS.DBA_OPARGUMENTS 12.1.1
owner:SYS, object_type:VIEW, object_name:DBA_OPARGUMENTS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RQ 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RQ, status:VALID,
VIEW: SYS.DBA_SOURCE 12.2.2
owner:SYS, object_type:VIEW, object_name:DBA_SOURCE, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_OG_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_OG_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SQL_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SQL_UTL, status:VALID,
PACKAGE: SYS.DBMS_IJOB 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_IJOB, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SQL_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SQL_UTL, status:VALID,
PACKAGE: SYS.DBMS_IJOB 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_IJOB, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_ADMIN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_ADMIN, status:VALID,
VIEW: SYS.DBA_INDEXTYPE_OPERATORS 12.1.1
owner:SYS, object_type:VIEW, object_name:DBA_INDEXTYPE_OPERATORS, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_COMMON_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_COMMON_UTL, status:VALID,