Retain Unstaged Quantity during Over Shipment or Under Shipment (R12i feature)

Oracle Shipping has offered another New Long awaited feature in R12. Now in R12 you can Retain Unstaged Quantity during over shipment or under shipment.

To enable this new feature in R12i, oracle has introduced below to additional Setup.

1. Introduce a new  field(check cox)‘Retain Unstaged quantity during Over pick’  on Shipping Parameters form. To enable this feature navigate to Shipping Parameter UI and check this check box.
2. Oracle has introduced a new custom hook  WSH_CUSTOM_PUB.Cancel_Unpicked_Details_At_ITS  and to enable this feature make sure it return a value of ‘N’.
N – Do not cancel the unpicked quantity
Y – cancel the unpicked quantity.

Please refer my previous post on R11i behavior (In r11i . system cancelled the unpicked quantity for over/under shipment if tolerance met).

In this Post I will explain how System will Retain Unstaged Quantity during over shipment or under shipment even when tolerance met. This is little hard to explain in words, so let me explain that with 2 simple examples, One for Under Shipment and one for Over Shipment.

Under Shipment
1.    If you have Order quantity = 10 and Over /Under Tolerance is say 20%.
2.    Book the Sales Order.
3.    Query the Order in shipping transaction Form.
4.    Manual Split the Delivery details with Qty 9 and 1
5.    Pick Release and Ship Confirm the Delivery Details with qty 9.
6.    After ITS execution for delivery with Qty = 9, after successful execution of ITS system will create a New Order with qty = 1 (even though Tolerance of 20% easily met.)

Over Shipment

1.    If you have Order quantity = 100 and Over /Under Tolerance is say 20%.
2.    Book the Sales Order.
3.    Query the Order in shipping transaction Form.
4.    Manual Split the Delivery details with Qty 90 and 10.
5.    Pick Release Order with parameter
a.    Auto Allocate = Yes
b.    Auto Pick Confirm = Yes and
c.    Auto Create Delivery = No (because I want manual transact move order).
6.    Go to Move Transact Order, Select the line with qty = 90, and press view/Update button and change  Qty from 90 to 105, Press Transact Button
7.    Delivery details with quantity 90 will be Staged with quantity 105 and at the same time delivery details with qty = 10 not get cancelled (even though the Over Tolerance of 20% met here).
8.    Ship confirm and run ITS.
9.    A new line with order quantity = 10 got created.


Hope that helps

Important Consideration
Do not add COMMIT or ROLLBACK in the custom API - WSH_CUSTOM_PUB.Cancel_Unpicked_Details_At_ITS