Pick Releasing for a Range of Orders Fails with ORA-01430: No Data Found and Exception occurred in WSH_PICK_LIST.Release_Batch_Sub (Doc ID 1321972.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
ConcurrentProgram:WSHPRS - Pick Release - SRS


Symptoms

When attempting to run Pick Release SRS for all eligible orders, the following error occurs:


ERROR
-----------------------
DELIVERY DETAIL XXXXXXXXX NOT ASSOCIATED TO ANY TRIP
CARTON GROUPING ID : XXXXXXXXX
MOVE ORDER SHIP SET MODEL ID MODEL QTY
PROCESSING DELIVERY DETAIL ==> XXXXXXXXX
DELIVERY DETAIL XXXXXXXXX NOT ASSOCIATED TO ANY TRIP
CARTON GROUPING ID : XXXXXXXXX
MOVE ORDER SHIP SET MODEL ID MODEL QTY
PROCESSING DELIVERY DETAIL ==> XXXXXXXXX
DELIVERY DETAIL XXXXXXXXX NOT ASSOCIATED TO ANY TRIP
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



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit Pick Release SRS to process all eligible orders.
2. Pick Release SRS ends in error, and nothing is pick released.

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