Search Results destroy_dml_cache_entry




Overview
Explore in AI Chat

Overview

FND_OAM_DSCRAM_DMLS_PKG is a VALID PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle Applications Manager (OAM) "DSCRAM" subsystem, a set of internal diagnostic utilities used by Oracle Support and Applications Technology Group staff to inspect and manipulate application data during troubleshooting, data scramming, and diagnostic collection workflows. The package is the data-manipulation layer of the DSCRAM family: it accepts DML statements or ranges, tracks them as discrete DML units, executes them on demand, and manages the transient cache that holds execution context. In EBS 12.1.1 and 12.2.2 the package resides in the same technology stack as other FND_OAM_* utilities and is classified under Oracle's internal API taxonomy as OTHER, meaning it is not a public, supported extension API but rather an internal dependency of the DSCRAM framework.

Key Procedures and Functions

Eight procedures and functions are documented in the ETRM metadata. Parameter lists are not published; the descriptions below reflect documented purpose only.

  • GET_CURRENT_DML_ID — Returns the identifier of the DML record currently being processed within the DSCRAM session, allowing callers to correlate execution with the FND_OAM_DSCRAM_DMLS table row.
  • FETCH_DML_IDS — Retrieves the set of DML identifiers that qualify for the current operation, typically used to build the working list before execution.
  • EXECUTE_DML_ON_RANGE — Executes the registered DML over a defined range of identifiers or rows, supporting batched processing so that large volumes can be handled incrementally.
  • EXECUTE_DML — Performs the core execution of an individual DML statement, issuing the dynamic SQL associated with a DML record.
  • UPDATE_COMP_DML_WRITABLE_ARGS — Updates the writable argument values associated with a completed DML, reconciling the argument structures maintained by the companion package FND_OAM_DSCRAM_ARGS_PKG.
  • COMPLETE_DML — Marks a DML as finished, finalizing its status and releasing its working context.
  • DESTROY_DML_CACHE_ENTRY — Removes a single entry from the DML cache, freeing the memory associated with one completed or abandoned operation.
  • DESTROY_DML_CACHE — Clears the entire DML cache maintained by the package, typically invoked at the end of a DSCRAM session.

Tables Accessed

The package operates against FND_OAM_DSCRAM_DMLS, the repository of registered DML definitions and their execution state, accessed through an APPS synonym. It also references DBMS_SQL for dynamic statement parsing, binding, and execution, and PLITBLM, the PL/SQL table-to-index-by conversion utility used for handling collection-based arguments. Dependency metadata shows the package referencing FND_OAM_DSCRAM_ARGS_PKG and FND_OAM_DSCRAM_UNITS_PKG, with mutual references in return, indicating a tightly coupled family. The package is referenced by two other packages within the same subsystem.

Usage Notes

FND_OAM_DSCRAM_DMLS_PKG is not intended for direct invocation from forms, concurrent programs, or customer-written code. It is called internally by FND_OAM_DSCRAM_UNITS_PKG and FND_OAM_DSCRAM_ARGS_PKG as part of the DSCRAM execution flow, where units are decomposed into DML operations, executed against a target set of records, and then cached and cleaned up. Because the package is classified as OTHER and documented with no public parameter contracts, customers should treat it as an internal Oracle object. Customizations that reference or wrap it risk breakage during patching or upgrade, since the DSCRAM packages are routinely updated by Oracle Support tooling. Any observed use of "fnd_oam_dscram_args_pkg" in a search should be understood as an adjacent member of this same internal family, not as a supported integration point.