Interface Trip Stop Errors With No Delivery Detail Found INV_TXN_MANAGER_PUB: SQL Error ORA-01403: No Data Found
(Doc ID 1994535.1)
Last updated on FEBRUARY 29, 2024
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterOracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
When attempting to run the interface trip stop, it shows that it completes successfully.
However, the log file shows an error and the delivery details are fully interfaced to OM, but show as Pending interface to Inventory.
ERROR
-----------------
WSHINTERFACES module: Interface Trip Stop - SRS
Interface trip stop is completed successfully
However, the log shows the following:
No Delivery Detail Found
No Delivery Detail Found ==> is NULL
Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (03/18/2015 03:41:29 PM, 0 seconds)
Interface_Detail_To_Inv l_inv_inter_status ==> S
Entering WSH_SHIP_CONFIRM_ACTIONS.PROCESS_INV_ONLINE (WSHDDSHB.pls 120.19.12010000.9) (03/18/2015 03:41:29 PM)
p_batch_id ==> <batch_id>
Calling program unit MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
******** New Session:92595662****18-MAR-15:03.41.29 **********
[18-MAR-15 15:41:29] INV_TXN_MANAGER_PUB: -----Inside process_Transactions-------.trxhdr=133236592
[18-MAR-15 15:41:29] INV_TXN_MANAGER_PUB: Inv Batch size:0
[18-MAR-15 15:41:29] INV_TXN_MANAGER_PUB: MTI Rows cnt before Validation=0
[18-MAR-15 15:41:29] INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found
Current Time is ==> 03/18/2015 03:41:29 PM
l_outcome ==> TRUE
Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS (WSHDDSHB.pls 120.19.12010000.9) (03/18/2015 03:41:29 PM)
p_batch_id ==> <batch_id>
No Delivery Detail Found ==> is NULL
Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (03/18/2015 03:41:29 PM, 0 seconds)
Interface_Detail_To_Inv l_inv_inter_status ==> S
Entering WSH_SHIP_CONFIRM_ACTIONS.PROCESS_INV_ONLINE (WSHDDSHB.pls 120.19.12010000.9) (03/18/2015 03:41:29 PM)
p_batch_id ==> <batch_id>
Calling program unit MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
******** New Session:92595662****18-MAR-15:03.41.29 **********
[18-MAR-15 15:41:29] INV_TXN_MANAGER_PUB: -----Inside process_Transactions-------.trxhdr=133236592
[18-MAR-15 15:41:29] INV_TXN_MANAGER_PUB: Inv Batch size:0
[18-MAR-15 15:41:29] INV_TXN_MANAGER_PUB: MTI Rows cnt before Validation=0
[18-MAR-15 15:41:29] INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found
Current Time is ==> 03/18/2015 03:41:29 PM
l_outcome ==> TRUE
Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS (WSHDDSHB.pls 120.19.12010000.9) (03/18/2015 03:41:29 PM)
p_batch_id ==> <batch_id>
STEPS
-----------------
- Go to Order Management Responsibility>Shipping>Interfaces >Run
- Run Interface Trip Stop -SRS for Problematic Delivery
- On completion of concurrent program, Go to View>Requests> query the Interface Trip Stop Program submitted
- Click on View log and notice the error mentioned above in the log file
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |