Transact Move Order Errors: The material pick release and pick confirm process completed with errors, Unexpected Error, Error in Routine WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity
(Doc ID 2817245.1)
Last updated on OCTOBER 31, 2022
Applies to:Oracle Shipping Execution - Version 12.2 and later
Oracle Inventory Management - Version 12.2 and later
Oracle Warehouse Management - Version 12.2 and later
Information in this document applies to any platform.
"Error from finalize_pick_confirm"
On Production : Post Upgrade to 12.2.10 version, WMS, Shipping & Transportation
The following errors occur upon allocating XX additional quantity while on the Transact Move Order Form
Error: The material pick release and pick confirm process completed with errors.|Unexpected Error: Error in Routine WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity, Oracle Error - 100
ORA-01403: no data found
The issue can be reproduced at will with the following steps:
1. Create Sales order with item X with qty 100
2. Book Sales Order
3. Split line from shipping transaction form to 10 & 90
4. launch pick release for Qty =10
5. in transact move order form, allocate 11
6. Transact errors above appear on the form
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