Search Results add_row_to_batch




Overview
Explore in AI Chat

Overview

FND_LOADER_OPEN_INTERFACE_PKG is an Oracle Application Object Library (FND) package body owned by the APPS schema. It provides the PL/SQL implementation supporting the open interface that underlies the FND Loader (FNDLOAD) utility, the standard concurrent/command-line mechanism used to migrate Oracle EBS setup and configuration data between environments. The package operates against the FND_LOADER_OPEN_INTERFACE table, which acts as a transient staging area during a loader run. Its published behavior centers on the transactional integrity of loader batches: it inserts new batch rows, deletes completed or aborted batch rows, appends individual data rows to an in-progress batch, and serializes concurrent loader execution through explicit locking. Because the package body is VALID and classified as OTHER (a supporting internal API rather than a user-facing public API), it is intended for invocation by the FND Loader infrastructure rather than by general application code. In Oracle EBS 12.1.1 and 12.2.2 the object remains functionally equivalent; the referenced objects and dependencies are consistent across both releases.

Key Procedures and Functions

  • INSERT_BATCH — Creates a new batch record in the open interface, establishing the controlling row that groups a set of loader rows processed as a single unit of work.
  • DELETE_BATCH — Removes a batch and its associated staging rows from the open interface, typically after successful consumption or upon rollback/cleanup of a failed loader run.
  • ADD_ROW_TO_BATCH — Attaches an individual data row to an existing batch, allowing the loader to accumulate multiple records under one batch identifier before processing.
  • LOCK_BATCH — Acquires an exclusive lock on a batch, using DBMS_LOCK, to prevent concurrent loader sessions from processing or mutating the same batch simultaneously.

The documented procedure list references six routines in total; the four above are the explicitly named entries in the available metadata. No parameter lists are asserted here, as the source documentation does not expose signatures.

Tables Accessed

  • FND_LOADER_OPEN_INTERFACE — The primary staging table holding batch headers and their constituent rows during a loader operation. The package inserts, deletes, and updates rows within it.
  • FND_LOADER_OPEN_INTERFACE_S — The sequence associated with the open interface, used to generate unique batch and row identifiers for newly inserted records.
  • DBMS_LOCK — Oracle's locking package, invoked by LOCK_BATCH to enforce serialized access to an in-progress batch.
  • DUAL — Used for single-row scalar operations such as sequence lookups or constant evaluation.
  • PLITBLM — An internal FND PL/SQL table-handling package referenced for collection processing within the loader logic.

Usage Notes

This package is invoked indirectly by FNDLOAD and by concurrent programs that perform configuration data migration. It is not exposed through Oracle Forms as a user-invoked API, and the metadata records no other database object referencing it, confirming its role as a low-level component internal to the loader stack. Custom code should not call these routines directly; doing so risks corrupting the staging table or bypassing the locking contract that LOCK_BATCH establishes. Administrators encountering rows left behind in FND_LOADER_OPEN_INTERFACE after an aborted load should treat them as loader residue and clear them through supported loader recovery mechanisms rather than manual deletes. Because the package depends on DBMS_LOCK, the executing database user requires EXECUTE on that package, a privilege typically granted through the standard APPS role definitions in both 12.1.1 and 12.2.2.