My Oracle Support Banner

Picking Quantity Exceeds Ordered Quantity After Splitting The Line And Changing Ordered Quantity (Doc ID 1965263.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.


In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Actual Behavior

Picking quantity exceeds ordered quantity after splitting the line and changing ordered quantity.

Expected Behavior

Picking quantity should not exceed ordered quantity after splitting the line and changing ordered quantity.

The issue started to happen after installing Patch 18618946 (Logistics Consolidated RUP9). Before it was working fine.

Example Steps

The issue can be reproduced at will with the following steps:
1. Login to “Order Management Super User” responsibilities. Create SO line with any item for qty 3200. Then book order.
2. Split order line for qty 800 and 2400
3. Cancel a new SO line 1.2 for 2400 qty. Check SO line 1.2 is cancelled
4. Change ordered quantity for SO line 1.1. Change from 800 to 3200. Save changes.
5. Define over-ship and under-ship tolerances, both 5%
6. Login to “Warehouse Manager” responsibility.
 Create simple picking rule with allocation mode=’Allocate Entire LPN Only’.
 Create simple picking strategy with Over Allocation Mode=’Using Order Line Tolerances’ and include a created rule to it.
 Activate the only one strategy in Rules Workbench form.
7. Check the availability of item before running pick releasing.
 Total available quantity = 1600+2400=4000.
 Total quantity is greater then ordered quantity 3200 even taking into account the SO over-ship tolerance.
8. Pick release SO line 1.1
 “Pick Selection List Generation “ concurrent program ends with error as only partial quantity is allocated.
9. Run Pick Release again for backordered quantity
Allocated quantity exceeds requested quantity
So total allocated quantity 4000 exceeds order quantity 3200 +5% over-ship tolerance.


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.