Search Results fnd_oam_dscram_dmls_pkg




Overview
Explore in AI Chat

Overview

FND_OAM_DSCRAM_UNITS_PKG is an internal Oracle E-Business Suite package belonging to the Applications (APPS) schema that forms part of the Oracle Applications Manager (OAM) Diagnostic Scripting framework. Its role is to manage the "unit" construct of the diagnostic scripting engine. Within the OAM Diagnostics architecture, a script is decomposed into tasks, tasks into SQL, PL/SQL, or DML statements, and those statements are ultimately grouped into executable units. FND_OAM_DSCRAM_UNITS_PKG encapsulates the runtime logic that defines, retrieves, and executes these units. The package is classified as OTHER in the ETRM documentation, indicating that it is not a public or supported API but an Oracle-internal utility invoked indirectly by the higher-level diagnostic scripting packages. In both Oracle EBS 12.1.1 and 12.2.2, the package status is documented as VALID, and it is a core dependency of the related DSCRAM packages that orchestrate diagnostic script execution.

Key Procedures and Functions

Nine documented procedures and functions constitute the public surface of the package:

  • GET_UNIT_ID — Returns the identifier of a diagnostic execution unit, allowing the engine to resolve a unit by its defining attributes.
  • GET_WORKERS_ALLOWED — Determines the number of worker processes permitted to execute a unit, supporting controlled parallelism within the diagnostic framework.
  • GET_BATCH_SIZE — Returns the batch size used when a unit processes its underlying statements in groups.
  • GET_UNIT_OBJECT_OWNER — Retrieves the schema owner of the database object associated with a unit.
  • GET_UNIT_OBJECT_NAME — Retrieves the name of the database object associated with a unit.
  • CREATE_WORK_ITEM — Creates a work item record representing a unit scheduled for execution.
  • FETCH_NEXT_UNIT — Advances the execution cursor to the next pending unit, driving sequential processing by the scripting engine.
  • VALIDATE_CONTINUED_EXECUTION — Checks whether execution of a unit should continue, enabling the engine to honor stop or abort conditions between units.
  • EXECUTE_UNIT — Performs the actual execution of a unit, invoking the associated SQL, PL/SQL, or DML objects through the diagnostic engine.

Tables Accessed

The package accesses FND_OAM_DSCRAM_UNITS, the base table that stores unit definitions, execution state, and control attributes. It also relies on DBMS_SQL for dynamic SQL processing and PLITBLM, the PL/SQL integer table type used for array-style data handling within the package. These references are resolved through APPS synonyms in the standard manner.

Usage Notes

FND_OAM_DSCRAM_UNITS_PKG is invoked indirectly through the OAM Diagnostic Scripting framework rather than directly by end users. The dependency metadata records that it is referenced by FND_OAM_DSCRAM_ARGS_PKG, FND_OAM_DSCRAM_DMLS_PKG (twice), FND_OAM_DSCRAM_PLSQLS_PKG (twice), FND_OAM_DSCRAM_TASKS_PKG, and itself, confirming its role as a shared runtime utility. Users searching for "fnd_oam_dscram_dmls_pkg" should note that FND_OAM_DSCRAM_DMLS_PKG is a dependent caller of this package: the DML scripting package delegates unit-level execution behavior to FND_OAM_DSCRAM_UNITS_PKG. Customizations that extend the diagnostic scripting engine must respect the internal contract between these packages, as no formal public API is documented. Any direct invocation of this package in custom code is therefore unsupported.