Search Results dbms_repcat_utl




Overview
Explore in AI Chat

Overview

SYS.DBMS_DEFERGEN is an Oracle-supplied, internal PL/SQL package that forms part of the deferred remote procedure call (RPC) infrastructure underpinning Oracle Advanced Replication. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package supports the runtime machinery by which queued (deferred) replication transactions are stored, propagated, and applied across distributed database nodes. The package name derives from "defer generation," and its role is to generate, maintain, and manipulate the internal metadata and SQL constructs that describe deferred transactions and their associated argument queues.

Although the object resides in the SYS schema and is classified as an OTHER API type within the EBS Technical Reference Manual (ETRM), it is not an application-facing interface. It is an Infrastructure dependency of the replication stack and is exposed to the database via a PUBLIC synonym, DBMS_DEFERGEN, making it callable from any schema with the requisite privileges. Because Advanced Replication underlies several EBS multi-site and distributed deployment patterns, DBMS_DEFERGEN is relevant to administrators troubleshooting deferred transaction backlogs and replication metadata.

Key Procedures and Functions

The ETRM documentation for this package records no explicitly documented procedures or functions (0 total) against the object inventory. The dependency listing, however, identifies a substantial internal codebase. DBMS_DEFERGEN references DBMS_REPCAT_DECL, DBMS_SYS_SQL, and STANDARD, and is itself referenced by a series of internal helper packages, including DBMS_DEFERGEN_AUDIT, DBMS_DEFERGEN_INTERNAL, DBMS_DEFERGEN_LOB, DBMS_DEFERGEN_PRIORITY, DBMS_DEFERGEN_RESOLUTION, DBMS_DEFERGEN_UTIL, and DBMS_DEFERGEN_WRAP.

These subordinate packages indicate the functional decomposition of deferred transaction generation: audit handling of generated calls, internal queue management, large object (LOB) argument support, priority assignment for deferred calls, conflict resolution invocation, general utilities, and dynamic SQL wrapping. DBMS_DEFERGEN also interfaces with the higher-level replication administration packages DBMS_REPCAT_MAS, DBMS_REPCAT_UTL through DBMS_REPCAT_UTL4, DBMS_REPCAT_SNA_UTL, DBMS_REPCAT_OBJ_UTL, DBMS_REPCAT_RGT_CUST, and DBMS_REPUTIL, confirming its position within the broader replication control framework. No parameter signatures are documented in the ETRM metadata, and none should be assumed.

Tables Accessed

The supplied ETRM metadata does not enumerate the underlying tables accessed through APPS synonyms for this object. As a SYS-owned package, DBMS_DEFERGEN operates directly against the deferred transaction dictionary rather than through EBS application synonyms. In Advanced Replication, such packages read and write the DEF$_* system tables (for example, DEF$_CALL, DEF$_CALLDEST, DEF$_ERROR, and DEF$_LOB), which store deferred remote procedure calls, their destinations, errors, and large object arguments. Application-level EBS tables are not directly touched by this package; rather, they are affected indirectly when deferred calls are applied at a destination site.

Usage Notes

DBMS_DEFERGEN is an internal component and is not intended for direct invocation from EBS forms, concurrent programs, or custom application code. It is invoked indirectly by the replication agent processes, by DBMS_DEFER and DBMS_DEFER_SYS flows when queues are pushed and purged, and by replication catalog maintenance routines during object generation. Administrators diagnosing stalled deferred transaction queues or replication metadata inconsistencies in EBS 12.1.1 and 12.2.2 may encounter this package in dependency traces, but remediation should be directed at the supported replication administration APIs (DBMS_DEFER_SYS, DBMS_REPCAT) rather than at DBMS_DEFERGEN itself. Evidence of problems involving this package should prompt review of replication group status, queue backlog, and conflict resolution configuration.