Interface Trip Stop Completes In Warning: ORA-01403: no data found in Package INV_KanbanCard_PKG Procedure Query_Row in the MTI (Doc ID 1391316.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Symptoms

When attempting to submit the Interface Trip Stop program for a trip stop and delivery, the following error can be observed in the log of the program:

ERROR
-----------------------
No Delivery Detail Found
No Delivery Detail Found ==> is NULL
Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (11/10/2011 10:41:22 AM, .01 seconds)
Interface_Detail_To_Inv l_inv_inter_status ==> S
Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 115.120.11510.13) (11/10/2011 10:41:22 AM)
P_MESSAGE_TYPE ==> W
P_MODULE_NAME ==> wsh.plsql.WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP
msg_buffer ==> Inventory Interface could not process some of the lines in the batch as they are in error status. Please query the lines using the Inventory Interface UI to correct the errors.
W:Inventory Interface could not process some of the lines in the batch as they are in error status. Please query the lines using the Inventory Interface UI to correct the errors.
Exiting WSH_UTIL_CORE.ADD_MESSAGE (11/10/2011 10:41:22 AM, 0 seconds)
l_completion_status ==> NORMAL
Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP (11/10/2011 10:41:22 AM, .03 seconds)
INTERFACETRIPSTOP: RESULT OF INVENTORY INTERFACING BATCH_ID 1128784 = WARNING

When checking MTL_TRANSACTIONS_INTERFACE (MTI) data, the table shows the following error code and explanation:

ERROR_CODE - Transaction processor error
ERROR_EXPL - ORA-01403: no data found in Package INV_KanbanCard_PKG Procedure Query_Row

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. End user deleted corresponding Kanban card
2. Navigate to Shipping->Interfaces->Run.
3. Select the program Interface Trip Stop - SRS.
4. Enter the necessary parameters and submit the program.

Changes

Cause

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