Search Results dbms_defergen_util




Overview
Explore in AI Chat

Overview

DBMS_DEFERGEN_UTIL is a SYS-owned PL/SQL package body classified as a utility (UTIL) API within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack. It operates in the same functional domain as DBMS_DEFERGEN, Oracle's internal infrastructure for deferred (queued) remote procedure calls in the Advanced Replication feature of the database. Whereas DBMS_DEFERGEN is responsible for generating the deferred transaction queue entries that propagate changes between replicated sites, DBMS_DEFERGEN_UTIL provides the supporting utility layer used during that generation process. In EBS deployments, this replication machinery underpins features such as multi-site data synchronization and snapshot refresh, and it is also exercised indirectly by EBS cloning, patching, and site-level data distribution routines. The object is reported as VALID in the ETRM repository, indicating it compiles cleanly against the referenced SYS objects at the documented release levels.

Key Procedures and Functions

The ETRM documentation records the package body with zero explicitly published procedures or functions. This is consistent with an internal, unsupported utility package: its entry points exist to be called by other SYS packages rather than by application code, and Oracle does not expose them as part of a public API contract. No parameter lists are documented, and none should be assumed. The package's purpose is inferred from its dependency graph and from its relationship to DBMS_DEFERGEN, which it invokes for the core deferred transaction generation work. Administrators and developers should treat DBMS_DEFERGEN_UTIL as a private implementation detail; it is not a supported extension point and Oracle Corporation does not recommend direct invocation.

Tables Accessed

The dependency metadata shows the package body resolving a small set of data dictionary and replication-internal objects: COL$, OBJ$, USER$, DUAL, DBA_OBJECTS, and GENERATOR$_S. COL$ and OBJ$ are core data dictionary tables holding column and object definitions; USER$ holds user definitions; DBA_OBJECTS provides object metadata visible to the executing user; DUAL is the standard single-row utility table. GENERATOR$_S is a System Change Number (SCN) generation table used to obtain consistent change numbers for queued transactions — the critical dependency that identifies this package as part of the deferred transaction infrastructure. The package reads these objects to resolve object identifiers, validate schema and object names, and stamp generated deferred calls with appropriate SCN values. No APPS synonym tables are documented for this package, confirming that it does not touch application data directly.

Usage Notes

DBMS_DEFERGEN_UTIL is not referenced by any database object in the ETRM dependency listing, but it is documented as being referenced by nine other packages, and it depends on DBMS_DEFERGEN, DBMS_SQL, DBMS_SYS_SQL, DBMS_UTILITY, DBMS_ASSERT, and STANDARD. This pattern places it squarely inside the replication stack invoked during deferred transaction generation. In EBS 12.1.1 and 12.2.2 it is typically exercised automatically by the database when replicated changes are queued, and indirectly during operations that depend on replication metadata, such as multi-node configurations and certain cloning or migration tasks. It is not invoked from EBS forms, concurrent programs, or supported customization points. Because it is an unsupported SYS package, custom code should never call it directly; doing so risks failures across database upgrades and patches, and any diagnostic investigation of this package should proceed under Oracle Support guidance using the documented dependency information.