Intransit Shipments Fail in the Inventory Interface - SRS FAILED WITH NO DELIVERY DETAIL FOUND (Doc ID 1474076.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Inventory Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to submit the interface trip stop program for the delivery of an Intransit shipment, the following error occurs:

Interface trip stop log is completed with warning

+---------------------------------------------------------------------------+
No Delivery Detail Found
       No Delivery Detail Found ==> is NULL
     Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (06/22/2012 09:31:45 PM,  .04 seconds)
     Interface_Detail_To_Inv l_inv_inter_status ==> S
     Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 120.21.12010000.6) (06/22/2012 09:31:45 PM)
       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 (06/22/2012 09:31:45 PM,  .04 seconds)
     Entering WSH_SHIP_CONFIRM_ACTIONS.PROCESS_INV_ONLINE (WSHDDSHB.pls 120.19.12010000.12) (06/22/2012 09:31:45 PM)
       p_batch_id ==> 37603
       P_TRANSACTION_HEADER_ID ==> 2622013
       Number of rows updated ==> 0
       Current Time is  ==> 06/22/2012 09:31:45 PM
       RIGHT BEFORE CALLING MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
       TIMEOUT VALUE: 1200
       Calling program unit MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
******** New Session:18883329****22-JUN-12:09.31.45 **********
 INV_TXN_MANAGER_PUB: -----Inside process_Transactions-------.trxhdr=2622013
 INV_TXN_MANAGER_PUB: Inv Batch size:0
 INV_TXN_MANAGER_PUB: MTI Rows cnt before Validation=0
 INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found
+---------------------------------------------------------------------------+

  


Inventory debug log after setting the debug profiles per <Note 299497.1>

+---------------------------------------------------------------------------+
 INV_TRX_MGR: ErrorMsg:Receiving Transaction Manager returned an error while processing the record with Interface Id 15539. The error message returned is .
 INV_LPN_TRX_PUB: retval=1, regmsg=Receiving Transaction Manager returned an error while processing the record with Interface Id 15539. The error message returned is .
 INV_LPN_TRX_PUB: calling API to clear the picked quantity
 INV_LPN_TRX_PUB: API call to clear picked quantity successful
 INV_TXN_MANAGER_PUB: PROCESS_LPN_TRX failed for header_id 2622083
 INV_TXN_MANAGER_PUB: Error.... Receiving Transaction Manager returned an error while processing the record with Interface Id 15539. The error message returned is .
 INV_TXN_MANAGER_PUB: Deleted MSNT/MTLT/MMTT for header_id 2622083
 INVTXNB: Error from INV worker : error_code : Transaction processor error, err_expl :Receiving Transaction Manager returned an error while processing the record with Interface Id 15539. The error message returned is .
 po.src.rvtp.rvtvt.RVTVT.C.794:             RVTVT:070 src_doc_type REQ
 po.src.rvtp.rvtvt.RVTVT.C.880:             RVTVT:085 destination_type INVENTORY
 po.src.rvtp.rvtvt.RVTVT.C.1142:             RVTVT:120 interface_trx_id 287543
 po.src.rvtp.rvtoc.RVTOC.C.begin:             v--------Procedure Started-----------v
 po.src.rvtp.rvtoc.RVTOC.C.336:               RVTOC:034 enter rvtoctrl
 po.src.rvtp.rvtoc.RVTOC.C.643:               RVTOC:045 interface_trx_id 287543
 po.src.rvtp.rvtoc.RVTOC.C.707:               RVTOC:046 invalid org  
 po.src.rvtp.rvtoc.RVTOC.C.end_implicit:             ^--------Implicit Procedure Exit-----^
 po.src.rvtp.rvtoc.RVTVT.C.end_implicit:           ^--------Implicit Procedure Exit-----^
 po.src.rvtp.rvtpt.RVTPT.C.2249:           RVTPT:001 rvtptdovalidate errored out interface transaction id: 287543
 po.src.rvtp.rvtpt.RVTPT.C.4692:           RVTPT:044 last set of rows
 po.src.rvtp.rvtpt.RVTPT.C.6998:           RVTPT:054 Previous shipment_header_id -999, count of valid record=0
 po.src.rvtp.rvtpt.RVTPT.C.7077:           RVTPT:055 RHI either isn't of type ASBN or invoice already created
 po.src.rvtp.rvtpt.RVTPT.C.5103:           RVTPT:070
 po.src.rvtp.rvtpt.RVTPT.C.5167:           RVTPT:071 return FALSE

  
NOTE the error:  RVTOC:046 invalid org  


Steps:
1. Navigate to Shipping->Interfaces->Run.
2. Select the program Interface Trip Stop program.
3. Enter the delivery number and submit the program.

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