Search Results dbms_defer_definer




Overview
Explore in AI Chat

Overview

DBMS_DEFER_DEFINER is a SYS-owned PL/SQL package that forms part of Oracle's Advanced Replication infrastructure, which underpins the deferred transaction queue used throughout Oracle E-Business Suite releases 12.1.1 and 12.2.2. In the EBS architecture, deferred remote procedure calls (RPCs) are queued locally and propagated to remote masters by the replication subsystem. The DBMS_DEFER_DEFINER package exists to manage the security context in which these deferred transactions execute: specifically, it supports the "deferred definer's rights" mechanism, allowing queued deferred calls to be executed under the privileges of the original definer rather than the session that eventually pushes the queue. Within EBS, this is relevant wherever multi-tier replication or multi-org data synchronization uses deferred RPCs, and where the invoking and executing schemas differ across database links. The package is registered in ETRM as VALID with an API classification of OTHER, indicating it is an internal Oracle-supplied utility rather than an EBS application-facing API.

Key Procedures and Functions

ETRM 12.2.2 documents zero public procedures or functions for SYS.DBMS_DEFER_DEFINER, and the standard Oracle export confirms the package specification exposes no supported callable entry points to customers. The package is therefore best understood as supporting infrastructure invoked internally by the replication engine rather than as a programmable API. Its functional role relates to establishing and validating the definer identity — by consequence of its name and dependency set — that the deferred transaction queue applies when re-executing stored deferred calls. No parameter lists are documented, and none should be assumed. Developers seeking supported operations on the deferred queue should use the documented DBMS_DEFER and DBMS_DEFER_QUERY packages instead, which are the officially exposed interfaces for enqueuing, querying, and administering deferred transactions.

Tables Accessed

Per the ETRM documentation, DBMS_DEFER_DEFINER references the table DEF$_DEFAULTDEST through APPS synonyms. DEF$_DEFAULTDEST is a core Advanced Replication dictionary table that records the default destination(s) for deferred transactions originating in the local database — that is, the target masters to which queued deferred RPCs are pushed when no explicit destination is supplied. The package's access to this table is consistent with its role in resolving the execution and routing context for deferred calls: determining the correct destination before the queue push, and validating which definer privileges apply at that destination. The dependency listing further shows the package references and is referenced by DBMS_DEFER and DBMS_DEFER_QUERY, confirming it is embedded in the same replication processing chain; there is no evidence that it reads or writes EBS application tables directly.

Usage Notes

DBMS_DEFER_DEFINER is not invoked from EBS forms, concurrent programs, or supported custom code. It is called implicitly by the Oracle replication engine, principally during queue propagation performed by job queue processes or by the deferred transaction push mechanisms that reference DEF$_DEFAULTDEST. EBS administrators encounter the object only indirectly: through database-level grants and synonyms created by AD utilities, through Advanced Replication or multi-master setup, or during diagnostics of deferred transaction errors logged in the DEF$_* tables. Because ETRM documents no public subprograms, it must be treated as an internal Oracle package; direct calls from custom code are unsupported and may break across patch levels. When troubleshooting deferred transaction or replication failures in EBS 12.1.1 or 12.2.2, the appropriate diagnostic path is to inspect the deferred queue views provided by DBMS_DEFER_QUERY and the DEF$_ tables, not to call DBMS_DEFER_DEFINER directly. Object status should be verified as VALID after any database upgrade, since an invalid replication package can silently halt queue propagation.