Search Results purge_batch_exceptions

Overview

GME_CANCEL_BATCH_PVT is a private PL/SQL package in the APPS schema within Oracle E-Business Suite, belonging to the Process Manufacturing (GME) product family. It is classified as a PVT (private) API, meaning it is intended for internal consumption by other Process Manufacturing packages rather than direct invocation from external interfaces or custom code. Its principal business function is to manage the cancellation and purge of process manufacturing batches — reversing the transactional and material impacts of a batch, deleting pending product lots, and clearing residual exceptions left behind after batch termination. As a private package, it encapsulates logic shared by higher-level public APIs such as GME_API_MAIN and is not documented as a supported extension point. It is present in both EBS 12.1.1 and 12.2.2 with a VALID status.

Key Procedures and Functions

The ETRM metadata documents three procedures for this package:

• CANCEL_BATCH — The core routine that performs the cancellation of a process manufacturing batch. It orchestrates the reversal of batch header state, step execution, and associated material movements, and coordinates error handling and logging for the cancellation transaction.
• PURGE_BATCH_EXCEPTIONS — Removes exception records or error conditions associated with a batch that has been cancelled or terminated, ensuring that downstream processing and reporting are not blocked by stale exception entries.
• DELETE_PENDING_LOTS — Deletes pending product lots generated for a batch, clearing lot rows that were staged but never released as a result of the cancellation.

Parameter lists are not exposed in the metadata and are therefore not reproduced here; callers should refer to the package specification in the APPS schema for exact signatures.

Tables Accessed

Through APPS synonyms the package references the following tables, each serving a specific role in the cancellation workflow:

• GME_BATCH_HEADER — The batch master record; read to identify the batch and updated to reflect cancelled status.
• GME_BATCH_HISTORY — Records batch status transitions and cancellation history for audit purposes.
• GME_BATCH_STEPS — Batch step records inspected and updated during cancellation.
• GME_MATERIAL_DETAILS — Material requirements and consumption detail lines affected by the cancellation.
• GME_PENDING_PRODUCT_LOTS — Pending product lot rows removed by DELETE_PENDING_LOTS.
• MTL_MATERIAL_TRANSACTIONS_TEMP — Temporary interface table used to stage reversal transactions.
• MTL_TXN_REQUEST_HEADERS / MTL_TXN_REQUEST_LINES — Move order headers and lines used when cancellation requires inventory movements.
• PLITBLM — Standard Oracle PL/SQL character table type used internally for array processing.

Usage Notes

GME_CANCEL_BATCH_PVT is not a public interface. It is referenced by six other packages in the APPS schema, including GME_API_MAIN, GME_CONVERT_FPO_PVT, GME_TERMINATE_BATCH_PVT, and itself (recursive internal calls). Invocation typically occurs indirectly: users trigger cancellation of a process batch from the Process Manufacturing workbench (for example, the Batch Details or Batch Cancellation form), or through higher-level concurrent programs and public APIs such as GME_API_MAIN, which then call this private package to perform the low-level work. Custom code should avoid calling GME_CANCEL_BATCH_PVT directly, since its interface is neither documented nor guaranteed across patches. Instead, customizations should use the documented public APIs or supported forms. Because the package performs destructive operations on batch, material, and lot data, its use is subject to Process Manufacturing business rules governing batch status, transaction reversals, and accounting impact. Organizations should validate that no downstream inventory or cost records depend on the batch before initiating cancellation.