Results for “dbms_defer_internal_sys”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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 underlying Oracle Advanced Replication. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 technical stacks, this package is installed in the SYS schema and is delivered in wrapped (obfuscated) form; the ETRM metadata confirms the source is a wrapped package body with no readable procedure signatures. The package name follows Oracle's DBMS_DEFER_* naming convention, indicating membership in the family of packages that manage the deferred transaction queue: the capture of queued calls at the originating site, the storage and propagation of those calls, and the eventual execution of the deferred RPCs at the destination site. DBMS_DEFER_INTERNAL_SYS specifically provides the low-level, unsupported entry points that the supported DBMS_DEFER and DBMS_DEFER_SYS APIs call into. In EBS environments it is therefore not a business-facing utility but a kernel component that supports multi-site data synchronization and materialized view refresh, most notably in deployments that rely on Oracle Advanced Replication for distributing reference and setup data across instances.
Key Procedures and Functions
The ETRM metadata documents zero procedures or functions for this object; the package body is fully wrapped and no public callable specification is exposed for customer use. Consequently, no parameter lists can be reproduced or inferred, and none should be assumed. By convention and by its position within the DBMS_DEFER family, DBMS_DEFER_INTERNAL_SYS supplies internal helper routines that: resolve and validate deferred call arguments against their target object types; write and maintain rows in the deferred call queue; manage deferred transaction identifiers and destination bookkeeping; and support the purge and administrative operations invoked through the documented DBMS_DEFER_SYS interface. All of these entry points are considered private to the replication engine. Oracle explicitly classifies such internal packages as not for direct invocation, and the ETRM classification of OTHER reflects that this object is neither an EBS public API nor a documented integration point.
Tables Accessed
The ETRM metadata lists no tables referenced via APPS synonyms, which is consistent with the package operating entirely within the SYS schema against replication dictionary objects rather than EBS application tables. Its working data resides in the system-level deferred transaction tables — the DEF$_CALL, DEF$_CALL_DESTINATION, DEF$_DESTINATION, DEF$_ERROR, DEF$_ORIGIN, DEF$_AQCALL, DEF$_TEMP$LOB and related DEF$_ and REPCAT$_ objects — that together constitute the deferred RPC queue and its administration. Because these objects are owned by SYS and are not synonymed into APPS, EBS applications never address them directly; they are touched only through the replication and refresh machinery.
Usage Notes
DBMS_DEFER_INTERNAL_SYS is never invoked from Oracle EBS forms, concurrent programs, or custom application code. It is called implicitly by DBMS_DEFER, DBMS_DEFER_SYS, DBMS_DEFER_QUERY and the materialized view refresh and push/purge jobs that EBS administrators configure for multi-tier or multi-site replication topologies. The ETRM record notes that the package is referenced by four other packages, confirming its position as a lower-level dependency rather than a standalone interface. The search term "tera,omd" does not correspond to any documented feature of this object and likely reflects a tangential or misspelled query; administrators encountering the package during tracing, AWR analysis, or wait-event investigation should treat it as expected replication kernel activity and should direct any tuning or diagnostic effort to the supported DBMS_DEFER_SYS API instead of this internal body.
-
TABLE: SYSTEM.DEF$_ORIGIN 12.1.1
-
VIEW: SYS.DEFPROPAGATOR 12.2.2
-
TABLE: SYSTEM.DEF$_CALLDEST 12.1.1
-
TABLE: SYSTEM.DEF$_CALLDEST 12.2.2
-
VIEW: SYS.DEFPROPAGATOR 12.1.1
-
TABLE: SYSTEM.DEF$_ORIGIN 12.2.2
-
TABLE: SYSTEM.DEF$_ERROR 12.1.1
-
TABLE: SYSTEM.DEF$_ERROR 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2