Ship Confirm not Relieving Inventory on Split Delivery Details
Last updated on JANUARY 09, 2017
Applies to:Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS
Application Release: 12.1.3
In testing the 12.1.3 upgrade from 12.1 came across an issue when doing partial shipments across multiple LPN's. You ship confirm the delivery successfully and the delivery is closed. All the split delivery detail lines are shipped and show interfaced to OM and order line is closed and shows the correct qty shipped. However, only one LPN is relieved from inventory. All other LPNs are still stuck in the inventory and the mtl_reservations are hung against the closed sales order line.
The example order is 1000228:
Ordered qty is 75,000 Lbs. Shipped qty is 16,000 on 4 LPN's.
The delivery is ship confirmed successfully. All the delivery lines are interfaced to OM and the order line is closed with Qty shipped = 16000 LB and remaining qty correctly splits into second line.
Only one LPN MTH1000999 (2000 LB) is relieved from the inventory. All other LPNs (MTH1000994, MTH1000997, and MTH1000998) are stuck in ST sub-inventory. Also the closed sales order line still shows reservation of 14000 LB (This is equal to weight of other 4 stuck LPNs).
The reason that the order line still shows a reserved qty of 14,000 LB is that the
corresponding delivery details (160845, 160847, 160849) for order line 1.1 are showing X in the INI column in WSH_DELIVERY_DETAILS.
(X = Not Applicable. INI = Inventory Interface) The first detail (159838) is fine and has interfaced to OM and INV for qty 2,000 LB. Somehow the split delivery details became Not Applicable to Interface to Inventory. This is why the reservation remains.
Responsibility: OM Super User
1. Book a sales order with one line Qty = 75000 LB
2. Pick release a sales order so that more than one LPNs (Total Qty = 16000 LB) are picked for one line.
2. Pick confirm all the LPNs using WMS mobile client
3. Ship confirm the delivery via Shipping Transactions form
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms