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 DECEMBER 10, 2024
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterOracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
Interface Trip Stop (ITS) completes successfully, however, the delivery detail/s are still showing in a status of shipped with next step as 'Run Interfaces.
The inventory interface flag in the wsh_delivery_details table shows as 'P' or Pending. Reviewing the log file shows the following errors:
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=xxxxxx
[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
Steps
1. Order Management Responsibility
2. Shipping > Interfaces > Run
3. Run Interface Trip Stop -SRS for Problematic Delivery
4. On completion of concurrent program, Go to View>Requests
5. Query the Interface Trip Stop Program submitted
6. Click on View log and notice the error mentioned above in the log file
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |