My Oracle Support Banner

Sales Order Line Incorrect Shipped Quantity After Reducing Line Quantity (Doc ID 2822689.1)

Last updated on NOVEMBER 29, 2021

Applies to:

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


There is an issue when updating the ordered quantity after pick release (Before perform transact move order).
Ex: Order qty is 1190 , After pick release user is updating order qty as 850.
Material transactions are created with qty 850, But quantity shipped and invoiced are 1190.

Expect correct shipped and invoiced qty.

The issue can be reproduced at will with the following steps:
1. Create Sales order and line.
2. Book Order
Order line:
Primary QTY/UOM=1190/EA
Secondary QTY/UOM=1190/EA
Shipping Transactions form:
Requested QTY/UOM = 29.75 / ST
SRC requested QTY/UOM=1190/EA
3. Pick release sales order
4. Update sales order line ordered quantity (from 1190 to 850 EA)
Shipping Transactions form:
Requested QTY/UOM = 21 / ST
SRC requested QTY/UOM=840/EA
5. Perform Transact Move order (Allocate and Transact)
On Transact Move Order form:
Required qty=21 (ST) however Requested qty still shows 29.75 which is the qty before change.
6. After transaction move order, on Shipping Transactions form:
Requested QTY = 21 (ST)
Picked QTY= 21
However Secondary picked QTY shows 1190 (EA) which is the old value.
7. Ship Confirm and run ITS. On Shipping Transactions form, the shipped qty is 21 (ST). Inventory interface errors out because the primary and secondary qty do not match.
8. Order line shows shipped qty=1190 (EA) and fulfilled qty as 1190 (EA), which is the old value.


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.