Search Results dbms_defer_repcat




Overview
Explore in AI Chat

Overview

SYS.DBMS_DEFER_REPCAT is a core Oracle-supplied PL/SQL package that supports Oracle's advanced replication infrastructure, which underlies multi-tier and multi-master replication in Oracle E-Business Suite releases 12.1.1 and 12.2.2. In the EBS architecture, replication is used primarily to synchronize configuration and reference data across distributed nodes, and to support deployments that rely on read-only snapshots or designated master sites. DBMS_DEFER_REPCAT provides the plumbing that queues and applies deferred administrative calls against the replication catalog—operations such as creating or altering replicated objects, maintaining refresh groups, and propagating grouped-database (DDL) changes.

The package sits in the SYS schema and is marked VALID in the ETRM repository. Its classification is OTHER, meaning it is not a public EBS application API but an internal engine component. It depends on SYS.DBMS_UTILITY and STANDARD, which supply error handling, stack diagnostics, and general utilities used throughout the execution path.

Key Procedures and Functions

The ETRM metadata for Release 12.2.2 documents zero named procedures or functions for this package; its catalogue entry records only the package and package body as valid objects. This is consistent with internal packages whose callable surface is invoked by sibling replication packages rather than by application code. Based on the package's role, its members provide support for deferring and executing replication administrative requests—serializing deferred calls into the defer queue catalog, flushing pending administrative transactions, and invoking the underlying replication work specified by those transactions. Because no procedure list is published, customizations should never bind directly to these entry points; they are subject to change between patch levels.

Tables Accessed

By design, DBMS_DEFER_REPCAT operates against the replication catalogue tables owned by SYS, including the deferred transaction queue and related administrative metadata that track pending replication calls and their resolution status. Within EBS, applications interact with these structures indirectly through APPS synonyms and the higher-level replication packages rather than through direct DML. The package also maintains internal state consistent with DBMS_UTILITY error-stack reporting, ensuring failures during deferred application are logged for diagnostic review. No application-owned tables are documented as being accessed by this package.

Usage Notes

Oracle EBS customers do not invoke DBMS_DEFER_REPCAT directly from forms, concurrent programs, or custom PL/SQL. It is called internally by a set of replication management packages, as confirmed by the dependency metadata: DBMS_ASYNCRPC_PUSH, DBMS_DEFER_SYS_DEFINER, DBMS_OFFLINE_OG_INTERNAL, DBMS_REPCAT_ADD_MASTER, DBMS_REPCAT_MAS, DBMS_REPCAT_UTL, DBMS_REPCAT_UTL3, and DBMS_REPCAT_UTL4. These packages are themselves part of the EBS replication stack used during multi-master deployments, offline instantiation of replication groups, and asynchronous RPC propagation.

Practical administration centres on enabling replication, generating replication support for schema objects, and monitoring the deferred transaction queue through supported DBA views (for example, DBA_REPCAT and the DEF$_ error and destination views). If a replication operation stalls, the diagnostic trail may pass through this package, but remediation should use the documented DBMS_REPCAT and DBMS_DEFER_SYS interfaces. Direct execution against SYS.DBMS_DEFER_REPCAT is unsupported and should be avoided in all environments.