Search Results dbms_defer_query_utl




Overview
Explore in AI Chat

Overview

SYS.DBMS_DEFER_QUERY_UTL is an Oracle-supplied PL/SQL package that forms part of the underlying deferred remote procedure call (deferred RPC) infrastructure used by Oracle Advanced Replication and, by extension, by the Oracle E-Business Suite multi-org and multi-master replication features. It is owned by the SYS schema and holds a VALID status in the EBS 12.1.1 and 12.2.2 environments documented by ETRM. Its purpose is to provide internal query and utility routines that support the deferred transaction queue: the mechanism through which changes captured at one database node are packaged, propagated, and applied at other nodes. The package operates beneath the public-facing replication APIs and is not intended for direct end-user invocation. In an EBS context, it is relevant primarily to administrators and technical consultants investigating replication, deferred queue processing, and the internal dependencies of the DBMS_DEFER family of packages.

The ETRM record classifies this object as an "OTHER" API within the SYS schema and lists no publicly documented procedures or functions. It is a supporting, internal package rather than a callable business API.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents zero externally documented procedures or functions for DBMS_DEFER_QUERY_UTL. This is consistent with its role as an internal utility package: its callable units are consumed by sibling and parent packages within the deferred RPC stack rather than by application code. No parameter lists are published, and none should be assumed.

What the metadata does establish is its position in the dependency hierarchy. The package references SYS, STANDARD, the ANYDATA type, and the REPCAT$_OBJECT_NULL_VECTOR object, indicating that its internal routines manipulate deferred call arguments and null-vector representations associated with replicated objects. Correspondingly, it is referenced by seven other packages, including DBMS_ASYNCRPC_PUSH, DBMS_DEFER_QUERY_DEFINER, DBMS_DEFER_REPCAT, DBMS_DEFER_SYS_DEFINER, DBMS_DEFER_SYS_PART1, DBMS_REPCAT_UTL, and the DEFCALL object. This dependency signature confirms that the package supplies shared query logic consumed across the deferred queue push and administration packages.

Tables Accessed

The documented dependency list does not enumerate base tables directly. The only data-bearing object explicitly named is REPCAT$_OBJECT_NULL_VECTOR, a replication catalog view/object used to represent null vectors for replicated objects during deferred transaction processing. Because the package is a query utility, it most plausibly reads the replication catalog and the deferred transaction queue tables that the DBMS_DEFER family manages. The ETRM report records no tables accessed via APPS synonyms, which is expected given the package resides entirely in the SYS schema and serves database-level replication infrastructure rather than EBS application tables.

Usage Notes

DBMS_DEFER_QUERY_UTL is not intended to be called directly from Oracle EBS forms, concurrent programs, or custom PL/SQL. It is invoked internally by the packages that reference it—principally DBMS_DEFER_QUERY_DEFINER, DBMS_DEFER_SYS_DEFINER, DBMS_DEFER_SYS_PART1, DBMS_ASYNCRPC_PUSH, DBMS_DEFER_REPCAT, and DBMS_REPCAT_UTL—as part of deferred RPC queue querying, pushing, and administrative operations. Administrators encountering this object typically do so while diagnosing replication errors, validating object dependencies, or reviewing invalid objects following an upgrade or patch application. Because it belongs to SYS and forms part of Oracle's proprietary replication framework, it must not be modified, recompiled out of sequence, or replaced; any issues should be resolved through supported Oracle patching rather than custom intervention.