Cannot Backorder From Transact Move Orders/Interface Trip Stop Error: Error in Routine WSH_INTERFACE.Lock_Delivery_Detail
(Doc ID 790448.1)
Last updated on APRIL 22, 2024
Applies to:
Oracle Shipping Execution - Version 11.5.10.0 and laterInformation in this document applies to any platform.
Oracle Shipping Delivery Based - Version: 11.5.10
Symptoms
On 11.5.10 in Production:
When attempting to back order line from Transact Move Orders,
the following error occurs. The delivery detail is released to warehouse. Cancelling of order and
line is ultimate goal.
ERROR
Error in Routine WSH_INTERFACE.Lock_Delivery_Detail, Oracle Error - 100
ORA-01403: no data found
STEPS
The issue can be reproduced at will with the following steps:
Inventory->Move Orders->Transact Move Orders->Pick wave(T)-> Sales Order NUmber->
Find(B)->Select(C)->Tools(M)->Back Order Line
Similar error occurs in case of Interface Trip Stop. Interface Trip Stop errors out on Order Management Interface process.
Error showing in Interface Trip Stop log file :
msg_buffer ==> Error in Routine WSH_INTERFACE.Lock_Delivery_Detail,
Oracle Error - 100
ORA-01403: no data found
Exiting WSH_UTIL_CORE.ADD_MESSAGE (02/19/2005 05:57:38 PM, 0 seconds)
Exiting WSH_UTIL_CORE.DEFAULT_HANDLER (02/19/2005 05:57:38 PM, 0 seconds)
Unexpected error has occurred. Oracle error message is ORA-01403: no data found
Exiting WSH_INTERFACE.LOCK_DELIVERY_DETAIL - EXCEPTION:OTHERS
(02/19/2005 05:57:38 PM, 0 seconds)
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 |