My Oracle Support Banner

Interface Trip Stop Fails With Error In Handle_Nonbulk_Mode ORA-01403 No Data Found When Ship Sets Exist On Delivery Details But Not For Related Order Line (Doc ID 827924.1)

Last updated on JUNE 15, 2022

Applies to:

Oracle Shipping Execution - Version 11.5.10.0 to 12.2.11 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to run Interface Trip Stop(ITS) the following errors occurs:

ERROR
shown in the interface trip stop log file:

  error in handle_nonbulk_mode ORA-01403: no data found
  IN ship_confirm_new OTHERS ORA-01403: no data found
  Failed to interface Batch <batch id> to Order Management because API interface_header_to_OM failed



STEPS
The issue can be reproduced at will with the following steps:

1. Order Management Super User Responsibility
2. Shipping
3. Interfaces  

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

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