My Oracle Support Banner

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

Last updated on JANUARY 11, 2021

Applies to:

Oracle Shipping Execution - Version 11.5.10.0 to 12.2.10 [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
------------

error in handle_nonbulk_mode ORA-01403: no data found
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.