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

Symptoms

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



Cause

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
Symptoms
Cause
Solution
References


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