Search Results dbms_defer_sys_part1




Overview
Explore in AI Chat

Overview

SYS.DBMS_DEFER_SYS_PART1 is a core Oracle-supplied PL/SQL package that forms part of the deferred remote procedure call (RPC) infrastructure underpinning Oracle Advanced Replication. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package belongs to the DBMS_DEFER_SYS_PART1 family of packages that collectively implement the scheduling, propagation, and administrative control of deferred transactions between master and materialized view sites. The package is owned by SYS with a status of VALID and is classified under the API classification OTHER, indicating that it is an internal, supporting component rather than a directly user-invokable public API.

The "PART1" designation reflects Oracle's practice of splitting the large DBMS_DEFER_SYS functional surface across multiple packages to manage compilation size and dependency footprint. As such, DBMS_DEFER_SYS_PART1 exposes a defined subset of the deferred-transaction scheduling and administration logic consumed by higher-level definer and internal packages.

Key Procedures and Functions

The ETRM metadata for this object documents zero procedures or functions directly under DBMS_DEFER_SYS_PART1. This is consistent with its role as an internal partition package: the public-facing entry points of the deferred RPC subsystem reside in sibling packages such as DBMS_DEFER_SYS, DBMS_DEFER_SYS_DEFINER, and DBMS_DEFER_INTERNAL_SYS, while DBMS_DEFER_SYS_PART1 supplies partitioned internal implementations. Because no procedures are documented, no parameter-level behavior can be asserted from the metadata, and any enumeration of specific signatures would be speculative. Administrators and developers seeking callable routines should reference the wrapper packages listed among the dependents rather than this partition directly.

Tables Accessed

The documentation identifies DEF$_LOB as the single table referenced through APPS synonyms. DEF$_LOB stores large object payloads associated with deferred transactions, holding the LOB columns corresponding to rows staged in the DEF$_AQCALL and DEF$_AQERROR queue tables. DBMS_DEFER_SYS_PART1 participates in reading from or writing to DEF$_LOB as part of the lifecycle of pushing and processing deferred RPC payloads. This table is intrinsic to the replication queue mechanism, where deferred transaction bodies—including those carrying LOB data—are staged before propagation to destination sites.

Usage Notes

DBMS_DEFER_SYS_PART1 is not intended for direct invocation by EBS developers or end users. It is invoked indirectly by the Oracle replication engine and by the internal packages that reference it. The metadata records that it is referenced by eight sibling and parent packages, including DBMS_DEFER_DEFINER, DBMS_DEFER_INTERNAL_SYS, DBMS_DEFER_REPCAT, DBMS_DEFER_SYS_DEFINER, DBMS_DEFER_SYS_PART1, DBMS_REPCAT_ADD_MASTER, DBMS_REPCAT_RPC, DBMS_REPCAT_SNA_UTL, and DBMS_REPCAT_UTL, and that it itself references SYS and STANDARD.

In EBS environments where multi-master or materialized-view replication is configured—common in distributed 12.1.1 and 12.2.2 deployments spanning multiple data centers—the deferred transaction scheduler and push jobs exercise this package automatically. Consequences of its operation surface through the DEF$_AQCALL, DEF$_AQERROR, and DEF$_LOB tables, which administrators monitor when diagnosing replication latency, queue backlog, or error conditions. Custom code should never call DBMS_DEFER_SYS_PART1 directly; instead, use the documented public interfaces of DBMS_DEFER_SYS and related packages, and treat this partition as an internal dependency that must be present and VALID for replication to function correctly.