My Oracle Support Banner

Interface Trip Stop error in handle_nonbulk_mode ORA-01403 Due to Mismatch of arrival_set_id (Doc ID 2796324.1)

Last updated on APRIL 14, 2022

Applies to:

Oracle Shipping Execution - Version 12.2 and later
Information in this document applies to any platform.


On : 12.2.5 version, Interface Trip Stop

Interface Trip Stop completed with warning.
Log file shows the following errors


----------entering handle_nonbulk_mode
request_line_rec line_id count: 0
last- 1 first- 1
extending the tables 1
1looping over ship line rec, line_id: nnnnnn
Ship_line_rec.line_id 1:nnnnnn
aa2 locked line
shippable_flag 1:Y
top_model_line_id 1:
error in handle_nonbulk_mode ORA-01403: no data found
error in handle_nonbulk_mode ORA-01403: no data found
ENTER Save_API_Messages
l_errmsg ORA-01403: no data found
EXIT Save_API_Messages
IN ship_confirm_new OTHERS ORA-01403: no data found

The issue can be reproduced at will with the following steps:
1. Login as Order Management Super User responsibility
2. Navigate to >Shipping >Interfaces >Run
Single Request
Select 'Interface Trip Stop - SRS' from LOV
enter parameters:
Delivery: Select a delivery that you want to run the process for
3. Review log for error


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

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