My Oracle Support Banner

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" "Oracle Error - 100" ORA-01403: no data found (Doc ID 2817245.1)

Last updated on OCTOBER 26, 2021

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"
Procedure "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

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