Search Results dbms_defer_internal_sys




Overview
Explore in AI Chat

Overview

SYS.DBMS_DEFER_INTERNAL_SYS is an Oracle-supplied, internal PL/SQL package that forms part of the deferred remote procedure call (RPC) infrastructure underpinning Oracle's advanced replication and distributed database facilities. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package resides in the SYS schema and is reported by ETRM with a status of VALID. Its classification is OTHER, reflecting that it is not an Applications-facing API but a kernel-level utility rather than a business-facing module such as Order Management or Payables.

The package operates as a low-level building block for the deferred transaction queue. It supports the mechanism by which changes captured on one database node are queued, propagated, and applied asynchronously at another node. In EBS deployments, this machinery is relevant wherever multi-node data synchronization, materialized view refresh, or replication of configuration and reference data is configured. It is not intended to encapsulate business logic; rather, it provides the primitive operations on which the higher-level deferred RPC packages depend.

Key Procedures and Functions

ETRM documents zero public procedures or functions for this package, which is consistent with its role as an internal implementation package. Its callable surface is exposed only to other SYS-owned replication packages and is not published as a supported application programming interface. Because the metadata lists no documented entry points, no parameter lists are asserted here. Consumers seeking deferred RPC functionality should use the supported wrapper packages documented separately in ETRM, principally DBMS_DEFER, DBMS_DEFER_SYS, and DBMS_DEFER_QUERY, rather than invoking DBMS_DEFER_INTERNAL_SYS directly.

Tables Accessed

The provided ETRM metadata records no tables referenced through APPS synonyms, which is expected given the package owner is SYS and it does not participate in the Applications schema synonym layer. Internally, a package of this nature operates against the SYS-owned deferred transaction queue dictionary tables, such as DEFCALL, DEFCALLDEST, DEFTRANDEST, and DEFERROR, which store queued calls, their destinations, transaction groupings, and error diagnostics respectively. Because the ETRM excerpt does not enumerate these objects, they are noted as the conventional underlying storage for the deferred queue rather than as confirmed references in this record.

Usage Notes

DBMS_DEFER_INTERNAL_SYS is invoked indirectly rather than from Oracle Forms, concurrent programs, or custom application code. ETRM dependency data shows it is referenced by four other packages: DBMS_DEFER_DEFINER, DBMS_DEFER_REPCAT, DBMS_DEFER_SYS_DEFINER, and DBMS_REPCAT_MIG_INTERNAL. These are the definer-rights and replication-administration packages that execute deferred queue operations on behalf of callers.

Two practical cautions follow from this dependency profile. First, the package should never be called directly from custom EBS code, since its interface is unsupported and subject to change across patch levels and database releases. Customizations requiring deferred execution should target the documented DBMS_DEFER family. Second, because the package is a dependency of core replication packages, any invalidation or recompilation affecting it can cascade to DBMS_DEFER_REPCAT and related components. Administrators reviewing invalid objects, replication errors, or deferred queue anomalies in EBS 12.1.1 or 12.2.2 should treat this package as an internal node in the dependency chain and recompile dependent packages as a group after any database upgrade or patch application.