Search Results unrelease_material




Overview
Explore in AI Chat

Overview

GME_UNRELEASE_BATCH_PVT is a private PL/SQL package in the APPS schema within Oracle E-Business Suite, belonging to the Process Manufacturing (OPM/GME) application family. Its principal business function is to reverse the release of a production batch that was previously released to the shop floor, returning the batch to an unreleased state so that its material issues, reservations, and pending product lot records are consistently rolled back. The package is classified as a PVT (private) API, meaning it is not intended as a public integration interface; it is called internally by the public GME_API_PUB and related orchestration packages rather than directly by customer extensions.

Unreleasing a batch is a controlled corrective operation. It is used when a released batch must be amended, cancelled, or re-planned before execution, and it forms the transactional counterpart to batch release. Because the operation touches inventory transactions and reservations, the package performs validation before mutation and coordinates its work with common OPM utilities.

Key Procedures and Functions

  • UNRELEASE_BATCH — Primary entry point. Drives the reversal of a batch release, coordinating validation and the rollback of materials and product lots for the specified batch.
  • VALIDATE_BATCH_FOR_UNRELEASE — Confirms that the target batch is in a state eligible for unrelease and that no downstream activity prevents reversal.
  • UNRELEASE_MATERIAL — Reverses the release activity recorded against individual batch material lines.
  • REVERT_MATERIAL_FULL — Performs a full reversion of material issue activity associated with the batch.
  • CREATE_MATL_RESV_PPLOT — Creates material reservations linked to pending product lots during the unrelease/revert cycle.
  • CREATE_RESV_PPLOT — Creates reservations for pending product lots.
  • CHECK_INV_NEGATIVE — Verifies whether reversal would drive inventory negative, protecting against invalid stock positions.

Tables Accessed

The package references tables through APPS synonyms. GME_BATCH_HEADER and GME_BATCH_STEPS provide the batch and step definition and status data being reversed. GME_MATERIAL_DETAILS and GME_PENDING_PRODUCT_LOTS supply material and pending product lot detail. Inventory movements are handled through MTL_MATERIAL_TRANSACTIONS, with lot information in MTL_TRANSACTION_LOT_NUMBERS. Item validation and description lookups use MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV. PLITBLM is a standard Oracle lot-interface table supporting lot processing. GME_COMMON_PVT is referenced as a shared OPM utility.

Usage Notes

GME_UNRELEASE_BATCH_PVT is invoked indirectly. It is referenced by GME_API_GRP, GME_API_MAIN, and GME_API_PUB, which expose the supported batch APIs; by GME_REVERT_BATCH_PVT, GME_TRANSACTIONS_PVT, GME_INCREMENTAL_BACKFLUSH_PVT, and GME_UNRELEASE_STEP_PVT for related reversal and backflush rollback processing; and recursively by itself. Calls typically originate from OPM batch maintenance forms, batch status change actions, or concurrent processes that cancel or re-plan released batches. Custom code should call the public GME_API_PUB wrapper rather than this private package directly. Because the package writes inventory transactions, callers should ensure the batch is validated for unrelease and that inventory would not go negative before committing.