Search Results cleanup_partial_putaway_lpn

Overview

APPS.WMS_TASK_DISPATCH_PUT_AWAY is the core Warehouse Management System (WMS) task dispatch package responsible for directing material into its final storage location after receipt. Within Oracle EBS 12.1.1 and 12.2.2 it underpins the put-away and directed task execution flow used by Warehouse Management, Mobile Supply Chain Applications (MSCA), and the Receiving and Work in Process integrations. The package header carries an AUTHID CURRENT_USER declaration and is versioned at 120.2.12020000.2 (WMSTKPTS.pls), indicating it has been maintained across the R12.x releases, with bug fixes such as 14176228 reflected in the source. The package creates move order lines, generates move orders, evaluates directed put-away suggestions against warehouse rules, and completes the put-away transaction once the operator confirms placement. It also validates LPN, lot, and serial attributes and manages partial put-away conditions, including the specific cleanup routine that concerns partial LPN put-aways. It is classified as an OTHER API and is referenced by eleven other packages, confirming its role as a shared service within the WMS task layer.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions:

• CLEANUP_PARTIAL_PUTAWAY_LPN — removes or reconciles residual LPN put-away records that arise when a partial quantity is put away, preventing orphaned or duplicate task data.
• CREATE_MO_LINE and CREATE_MO — build move order lines and the parent move order used to move material to the suggested location; CREATE_MO_LINE returns the created line identifier for R12 move order line consolidation.
• SUGGESTIONS_PUB and CREATE_USER_SUGGESTIONS — generate and publish location suggestions based on warehouse rules and capacity.
• COMPLETE_PUTAWAY — finalizes the put-away once the operator confirms the destination.
• DISCREPANCY — records and handles discrepancies encountered during put-away.
• CHECK_LPN_VALIDITY and VALIDATE_PUTAWAY_TO_LPN — validate LPN identity and the eligibility of a put-away into an LPN.
• ARCHIVE_TASK — moves completed task records out of the active task tables.
• PUTAWAY_CLEANUP — general housekeeping of put-away task data.
• CHECK_MMTT_MTL_STATUS — verifies the status of pending material transaction interface rows.
• VALIDATE_AGAINST_RULES — tests a proposed destination against configured put-away rules.
• VALIDATE_LOT_SERIAL_STATUS — confirms lot and serial number status before dispatch.
• REVERT_LOC_SUGGESTED_CAPACITY — reverses capacity reservations held on a suggested location.
• CHECK_FOR_CROSSDOCK — determines whether material should be crossdocked rather than stored.
• INSERT_MSNI_HELPER — supports insertion of serial number interface records.

Tables Accessed

The package reads and writes a broad set of inventory and WMS tables through APPS synonyms. Location and warehouse configuration is drawn from MTL_ITEM_LOCATIONS, MTL_SECONDARY_INVENTORIES, and MTL_PARAMETERS. Item definition comes from MTL_SYSTEM_ITEMS. Transaction processing touches MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP. Reservation and capacity checks use MTL_RESERVATIONS. Lot and serial validation uses MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP, MTL_SERIAL_NUMBERS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE, and MTL_TRANSACTION_LOTS_TEMP. Transaction reason handling uses MTL_TRANSACTION_REASONS, and FND_USER identifies the operating user.

Usage Notes

This package is not normally called directly by end users. It is invoked from the WMS and MSCA task dispatch forms and mobile pages, from concurrent programs that process inbound put-away, and from Receiving (including WIP) integration points that pass the p_wms_process_flag to control allocation and processing behavior. Custom code that must replicate put-away behavior should call the public procedures rather than modify task tables directly, since the package encapsulates rule validation, capacity reservation, and cleanup logic. When partial LPN put-aways leave stale records, CLEANUP_PARTIAL_PUTAWAY_LPN is the supported entry point for remediation.