Last updated on MARCH 08, 2017
Applies to:Oracle Inventory Management - Version: 126.96.36.199
Information in this document applies to any platform.
Interface Trip Stop
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms