My Oracle Support Banner

Pick Selection List Generation - SRS Error: SQLCODE: 100 SQLERRM: ORA-01403: no data found (Doc ID 1303859.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Shipping Execution - Version and later
Information in this document applies to any platform.
ConcurrentProgram:WSHPRS - Pick Release - SRS


Pick Selection List Generation - SRS concurrent request errors for just one Organization.

The pick release rule being used is a few months old and has had no problems until now.
The rule has Autocreate Deliveries, Auto Pick Confirm and Auto Allocate all set to No.
Organization is WMS enabled.

Error from the log file:
SQLCODE: 100 SQLERRM: ORA-01403: no data found
Exception occurred in WSH_PICK_LIST
Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender
Entering WSH_UTIL_CORE.RESET_STOPS_FOR_LOAD_TENDER (WSHUTCOB.pls 115.120.11510.16) (03/14/2011 01:26:50 PM)
p_reset_flags ==> TRUE
Exiting WSH_UTIL_CORE.RESET_STOPS_FOR_LOAD_TENDER (03/14/2011 01:26:50 PM, 0 seconds)
l_return_status ==> S
Unexpected error has occured. Oracle error message is ORA-01403: no data found
Exiting WSH_PICK_LIST.RELEASE_BATCH - EXCEPTION:OTHERS (03/14/2011 01:26:50 PM, 9.18 seconds)
ERRBUF ==> Exception occurred in WSH_PICK_LIST




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.