My Oracle Support Banner

Unable to Over Pick :Delivery Details Are Being Cancelled When Ship Tolerance Above Is Set (Doc ID 1579576.1)

Last updated on JANUARY 27, 2022

Applies to:

Oracle Shipping Execution - Version 12.1.2 to 12.2.10 [Release 12.1 to 12.2]
Oracle Inventory Management - Version 12.1.2 to 12.2.9 [Release 12.1 to 12.2]
Information in this document applies to any platform.



When overpicking during transacting the move order, find that the overpicked quantity gets cancelled when ship confirming.   
Overpicked with shipping tolerance to a total qty of 33 when the ordered qty is 29.

The actual quantity that gets shipped and interfaced is only 29 with sales order issue only showing a qty of 29.

At WSH_DELIVERY_DETAILS the third delivery detail shows a cancel qty of 4 .

Why is the overpicked quantity which is within the set shipping tolerance above cancelled?

The problematic order displays the following split lines in  WSH_DELIVERY_DETAILS

LINE  requested shipped
         QTY          QTY
2.1     6              6
2.1    21            21
2.1     2              2  <== Customer expects to see 6 as the shipped quantity. 
                                    customer has 14% overship tolerance on the order


The issue can be reproduced at will with the following steps:

1) Responsibility : Oracle Order Management
2) Set the profile option “WSH: Overpicking Enabled” to Yes.
3) Create sales order with an ordered qty of 29 and a 14% over ship tolerance.
4) Book the order
5) Do misc receipt for a qty of 33 (21,6,6) with 3 Lot numbers
6) Go into Shipping and Create trip.
7) Split the order line into quantities of 21, 6, and 2. (last split line would take the overship tolerance quantity).
8) Select all delivery detail lines and select Launch Pick Release from the Actions LOV.
9) Go to Inventory > Transact move order form
10) Allocate  quantities of 21,6,6(2+4) essentially overpicking the 3rd line by a quantity of 4
11) Click transact button.
12) Viewing delivery details in the shipping transaction form, it is showing 3 delivery details in a staged
pick confirmed status for the quantities of 21, 2, 6.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.