Search Results dbms_defergen_lob

Overview

SYS.DBMS_DEFERGEN_LOB is an Oracle-supplied PL/SQL package body that resides in the SYS schema and forms part of the Oracle RDBMS deferred transaction infrastructure underpinning advanced replication and Oracle E-Business Suite multi-tier data propagation. In the EBS 12.1.1 and 12.2.2 contexts, this package supports the generation, serialization, and queuing of Large Object (LOB) data within deferred remote procedure call (RPC) queues. Where the core DBMS_DEFERGEN package handles standard scalar and date parameter types, DBMS_DEFERGEN_LOB extends that mechanism to accommodate CLOB and BLOB payloads that frequently arise in EBS scenarios involving attachments, XML documents, interface staging tables, and other repositories that store unstructured content.

Key Procedures and Functions

The ETRM metadata for this object documents no published procedures or functions; the package body is classified as OTHER and carries no application-facing API surface. All internal entry points execute as private constructs invoked through the public DBMS_DEFERGEN layer. Based on the dependency chain documented in ETRM, DBMS_DEFERGEN_LOB relies on DBMS_ASSERT for validation of schema and object name inputs, DBMS_DEFERGEN for the surrounding deferred queue mechanics, DBMS_DEFERGEN_LOB itself for recursive or overloaded internal logic, DBMS_DEFERGEN_UTIL for shared utility routines, and DBMS_LOGREP_UTIL for logging and replication support functions. The absence of documented public routines confirms that DBMS_DEFERGEN_LOB acts strictly as an internal helper, exposing no directly callable interfaces to EBS developers.

Tables Accessed

The ETRM documentation does not enumerate any APPS-synonym tables referenced by DBMS_DEFERGEN_LOB, and none are recorded as accessed through APPS synonyms. As a SYS-owned replication utility, the package operates against the underlying DEF$_ (deferred transaction) dictionary structures and related internal LOB staging tables rather than EBS application tables. Because the package is not referenced by any database object according to the dependency metadata, its activity is confined to the internal replication call stack that materializes deferred RPC argument values.

Usage Notes

DBMS_DEFERGEN_LOB is never invoked directly from EBS forms, concurrent programs, or custom code. Instead, it is executed implicitly whenever the Oracle RDBMS processes a deferred transaction containing LOB parameters, including those generated by the EBS Multi-Org and Distributed Environment architectures used across 12.1.1 and 12.2.2. DBMS_DEFERGEN_LOB is referenced by one other package within the database, consistent with its role as a subordinate utility. Administrators encountering replication stalls, LOB argument serialization errors, or invalid LOB handle warnings in the DEF$_ queue should treat DBMS_DEFERGEN_LOB as a component of Oracle's internal replication engine rather than as an application-owned object. Validation status of VALID indicates normal operation. Troubleshooting should focus on the deferred queue tables and the associated DBMS_DEFER and DBMS_DEFERGEN layers, since this package provides no supported extension points for EBS customization.

PACKAGE BODY: SYS.DBMS_DEFERGEN_LOB 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_LOB, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_LOB 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_LOB, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_LOB 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_LOB, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_LOB 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_LOB, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_LOB 12.1.1
PACKAGE: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_LOB 12.2.2
PACKAGE: SYS.DBMS_DEFERGEN_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_UTIL, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_UTIL, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_LOB 12.1.1
PACKAGE BODY: SYS.DBMS_DEFERGEN_LOB 12.2.2
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
SYS.DBMS_DEFERGEN dependencies on DBMS_DEFERGEN_LOB 12.1.1
SYS.DBMS_DEFERGEN_LOB dependencies on DBMS_DEFERGEN_LOB 12.2.2
SYS.DBMS_DEFERGEN dependencies on DBMS_DEFERGEN_LOB 12.2.2
SYS.DBMS_DEFERGEN_LOB dependencies on DBMS_DEFERGEN_LOB 12.1.1
PACKAGE: SYS.DBMS_ASSERT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
PACKAGE: SYS.DBMS_ASSERT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
SYS.DBMS_DEFERGEN_LOB dependencies on DBMS_DEFERGEN 12.2.2
SYS.DBMS_DEFERGEN_LOB dependencies on DBMS_DEFERGEN 12.1.1
SYS.DBMS_DEFERGEN_LOB dependencies on DBMS_DEFERGEN 12.2.2
SYS.DBMS_DEFERGEN_LOB dependencies on DBMS_DEFERGEN 12.1.1
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,