Search Results dbms_defer_enq_utl

Overview

SYS.DBMS_DEFER_ENQ_UTL is an Oracle-supplied PL/SQL package that forms part of the Advanced Replication deferred transaction infrastructure delivered with the Oracle Database. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package is owned by the SYS schema and carries a status of VALID. Its role is to support the enqueue and propagation of deferred remote procedure calls (RPCs) that Oracle's deferred transaction queue depends upon.

Within EBS, Advanced Replication is most commonly encountered through Multi-Org and Multi-Org Access Control configurations, distributed deployment topologies, and database-level materialized view refresh mechanisms. The DBMS_DEFER_ENQ_UTL package provides the internal utility layer that constructs and validates deferred call entries before they are handed to DBMS_DEFER for queuing. It is not an application-facing API and is never invoked directly from EBS forms or concurrent programs; it functions purely as infrastructure plumbing within the database kernel's replication stack.

Key Procedures and Functions

The ETRM 12.2.2 documentation records an API classification of OTHER and lists zero documented procedures or functions for this package. All routines contained within DBMS_DEFER_ENQ_UTL are therefore considered internal and unsupported for direct invocation.

Based on the documented dependency graph, the package's members operate as utility helpers that prepare argument payloads — including ANYDATA typed values — for submission into the deferred queue. The absence of published signatures in the ETRM catalogue reinforces that these routines are consumed exclusively by sibling packages in the replication subsystem rather than by external callers.

Tables Accessed

The ETRM dependency metadata does not enumerate any tables accessed through APPS synonyms. This is consistent with the package's architecture: as a SYS-owned utility within the deferred transaction framework, its data interactions are mediated through the DBMS_DEFER package and the underlying SYS.DEF$_* deferred queue dictionary tables rather than through EBS application tables.

No EBS transactional or setup tables are read or written by this package. Its scope is confined to the replication metadata layer that governs how queued calls are serialised, validated, and stored pending propagation to remote master sites.

Usage Notes

SYS.DBMS_DEFER_ENQ_UTL is normally invoked implicitly. It is referenced by DBMS_DEFER, DBMS_DEFER_DEFINER, DBMS_DEFER_INTERNAL_SYS, and internally by itself, meaning that any EBS operation causing a deferred RPC to be enqueued will transit this package without the calling application being aware of it.

Forms and concurrent programs: Not called directly. Indirect invocation occurs when replication-enabled database links or materialized view refresh processes enqueue deferred calls.
Custom code: Direct calls are unsupported and should be avoided. Customisations should use the documented DBMS_DEFER API or, in EBS context, the supported Multi-Org replication utilities.
Troubleshooting: When investigating deferred transaction queue errors such as DEFERRED_RPC failures, verify the VALID status of this package alongside DBMS_DEFER and its dependents, since invalidation of any node in this chain will break enqueue operations.
Patching: The package is refreshed only by Oracle Database patch sets or release upgrades, not by EBS AD patch cycles.

Administrators should treat this object as read-only kernel infrastructure and restrict diagnostic access accordingly.

PACKAGE: SYS.DBMS_DEFER_ENQ_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_ENQ_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_ENQ_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_ENQ_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_ENQ_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_ENQ_UTL, status:VALID,
PACKAGE: SYS.DBMS_DEFER 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER, status:VALID,
PACKAGE: SYS.DBMS_DEFER_ENQ_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_ENQ_UTL, status:VALID,
PACKAGE: SYS.DBMS_DEFER 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER, status:VALID,
LIBRARY: SYS.DBMS_DEFER_ENQ_UTL_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_DEFER_ENQ_UTL_LIB, status:VALID,
LIBRARY: SYS.DBMS_DEFER_ENQ_UTL_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_DEFER_ENQ_UTL_LIB, status:VALID,
PACKAGE: SYS.DBMS_DEFER_ENQ_UTL 12.1.1
PACKAGE: SYS.DBMS_DEFER_ENQ_UTL 12.2.2
PACKAGE BODY: SYS.DBMS_DEFER 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_INTERNAL_SYS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_INTERNAL_SYS, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_ENQ_UTL 12.1.1
PACKAGE BODY: SYS.DBMS_DEFER_ENQ_UTL 12.2.2
PACKAGE BODY: SYS.DBMS_DEFER_DEFINER 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_DEFINER, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_DEFINER 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_DEFINER, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFER_INTERNAL_SYS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFER_INTERNAL_SYS, status:VALID,
TYPE: SYS.ANYDATA 12.1.1
owner:SYS, object_type:TYPE, object_name:ANYDATA, status:VALID,
TYPE: SYS.ANYDATA 12.2.2
owner:SYS, object_type:TYPE, object_name:ANYDATA, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
SYS.DBMS_DEFER_ENQ_UTL dependencies on DBMS_DEFER_ENQ_UTL 12.2.2
SYS.DBMS_DEFER_INTERNAL_SYS dependencies on DBMS_DEFER_ENQ_UTL 12.1.1
SYS.DBMS_DEFER dependencies on DBMS_DEFER_ENQ_UTL 12.1.1
SYS.DBMS_DEFER_INTERNAL_SYS dependencies on DBMS_DEFER_ENQ_UTL 12.2.2
SYS.DBMS_DEFER_DEFINER dependencies on DBMS_DEFER_ENQ_UTL 12.1.1
SYS.DBMS_DEFER dependencies on DBMS_DEFER_ENQ_UTL 12.2.2
SYS.DBMS_DEFER_DEFINER dependencies on DBMS_DEFER_ENQ_UTL 12.2.2
SYS.DBMS_DEFER_ENQ_UTL dependencies on DBMS_DEFER_ENQ_UTL 12.1.1
SYS.DBMS_DEFER_ENQ_UTL dependencies on DBMS_DEFER 12.2.2
SYS.DBMS_DEFER_ENQ_UTL dependencies on DBMS_DEFER 12.1.1
SYS.DBMS_DEFER_ENQ_UTL dependencies on DBMS_DEFER 12.2.2
SYS.DBMS_DEFER_ENQ_UTL dependencies on DBMS_DEFER 12.1.1
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,