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:

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

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