My Oracle Support Banner

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 FEBRUARY 01, 2019

Applies to:

Oracle Shipping Execution - Version 11.5.10.0 and later
Information 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

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