Pick Selection List Generation - SRS Error: SQLCODE: 100 SQLERRM: ORA-01403: no data found
Last updated on JANUARY 09, 2017
Applies to:Oracle Shipping Execution - Version 184.108.40.206 and later
Information in this document applies to any platform.
ConcurrentProgram:WSHPRS - Pick Release - SRS
***Checked for relevance on 05-APR-2014***
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms