Ship Sets Causing Pick Release To Fail - Error in Routine WSH_USA_INV_PVT.Update_Inventory_Info
(Doc ID 2585486.1)
Last updated on SEPTEMBER 22, 2023
Applies to:
Oracle Shipping Execution - Version 12.2.6 and laterOracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.
Symptoms
Pick release is failing for order lines having ship sets with the following error:
ERROR
-----------------------
msg_buffer ==> Error in Routine WSH_USA_INV_PVT.Update_Inventory_Info, Oracle Error - 100
ORA-01403: no data found
U:Error in Routine WSH_USA_INV_PVT.Update_Inventory_Info, Oracle Error - 100
ORA-01403: no data found
Exiting WSH_UTIL_CORE.ADD_MESSAGE (03/13/2019 01:55:17 PM, 0 seconds)
Exiting WSH_UTIL_CORE.DEFAULT_HANDLER (03/13/2019 01:55:17 PM, 0 seconds)
Unexpected error has occured. Oracle error message is ORA-01403: no data found
ORA-01403: no data found
U:Error in Routine WSH_USA_INV_PVT.Update_Inventory_Info, Oracle Error - 100
ORA-01403: no data found
Exiting WSH_UTIL_CORE.ADD_MESSAGE (03/13/2019 01:55:17 PM, 0 seconds)
Exiting WSH_UTIL_CORE.DEFAULT_HANDLER (03/13/2019 01:55:17 PM, 0 seconds)
Unexpected error has occured. Oracle error message is ORA-01403: no data found
STEPS
-----------------------
1. Order Management Super User Responsibility
2. Navigate to MENUPATH > Shipping > Release Sales Orders
3. Pick Release Order having Ship Set associated on the Lines.
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 |