My Oracle Support Banner

Internal Sales Order (ISO) Run Interfaces - Records Exist In MTL_TRANSACTIONS_INTERFACE Error : INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found *** (Doc ID 2879782.1)

Last updated on JUNE 28, 2022

Applies to:

Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to process delivery transactions in Interface Trip Stop and the following error occurs.

ERROR
InterfaceTripStop: processing stop_id nnnnn47 for INV OM DSNO
  l_inv_interface ==> 1
  l_om_interface ==> 1
  l_dsno_interface ==> 1
  l_interface_mode ==> INV OM DSNO
  l_stop_id ==> nnnnn47
  l_override_wf ==> N
  setting savepoint before_flag_change ==>
  locking row for nnnnn47 ==>
  updating pending_interface_flag to P for batch ==> nnnnn76

P_TRANSACTION_HEADER_ID ==>nnnnnn261
  No of record fetch ==> 0
  l_bulk_batch_size ==> is NULL
  l_def_inv_online ==>
  No Delivery Detail Found ==> is NULL

ug 34320723 - TRIP IS CLOSED YET DELIVERY_DETAILS NOT INTERFACED TO INVENTORY
STEPS
1. Responsibility: Order Management Super User
2. Navigate: Shipping > Interfaces > Run
3. Run Interface Trip Stop for Delivery nnnn88
4. Observe Error(s)
    [24-JUN-22 08:12:41] INV_TXN_MANAGER_PUB: -----Inside process_Transactions-------.trxhdr=nnnnn433
    [24-JUN-22 08:12:41] INV_TXN_MANAGER_PUB: Inv Batch size:40
    [24-JUN-22 08:12:41] INV_TXN_MANAGER_PUB: MTI Rows cnt before Validation=0
    [24-JUN-22 08:12:41] INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found

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


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