My Oracle Support Banner

Pick Releasing For 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 JULY 25, 2018

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. Order Management Super User Responsibility
2. Shipping
3. Release Sales Orders
4. Submit Pick Release SRS to process all eligible orders.

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.