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 laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5 version, Interface Trip Stop
Interface Trip Stop completed with warning.
Log file shows the following errors
ERROR
-----------------------
----------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
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
STEPS
-----------------------
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
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 |