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 19, 2018

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 backorder 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 incase 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 occured. 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)


BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot backorder this order and eventually cancel the order and line.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms