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

Last updated on JANUARY 09, 2017

Applies to:

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

***Checked for relevance on 05-APR-2014***

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms