Pick Release Errors With DELIVERY DETAIL LINE NOT FOUND: XXXXXXXX NO_DATA_FOUND Exception Has Occured (Doc ID 2195623.1)

Last updated on NOVEMBER 21, 2016

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Pick Release

When attempting to pick release, the following error occurs:


ERROR
-----------------------

Pick selection completed with warning.
SHIP_FROM_LOC_ID ==> -1
LINE/CONTAINER ID ==> -1
DOC_SET_ID ==> -1

Entering WSH_PR_CRITERIA.SET_GLOBALS (WSHPRCRB.pls 120.17.12010000.10) (09/08/2016 11:07:05 AM)
  P_ENFORCE_SHIP_SET_AND_SMC ==> N
  P_SHIP_SET_ID ==> is NULL
  P_TOP_MODEL_LINE_ID ==> is NULL
  Exiting WSH_PR_CRITERIA.SET_GLOBALS (09/08/2016 11:07:05 AM, 0 seconds)
  DELIVERY DETAIL LINE NOT FOUND: 15321094
  NO_DATA_FOUND exception has occured.
  Exiting WSH_PR_CRITERIA.GET_DETAIL_LOCK - EXCEPTION:NO_DATA_FOUND (09/08/2016 11:07:05 AM, 0 seconds)
  GET_DETAIL_LOCK RETURNED WITH WARNING
  Exiting WSH_PR_CRITERIA.INSERT_RL_ROW (09/08/2016 11:07:05 AM, .01 seconds)
  WARNING: SKIPPING THE ORDER LINE
  v_pr_mo_line_count : , v_total_rec_fetched : 0
  v_cursorID ==> 1532172687
  FETCHED ALL LINES FOR ORGANIZATION

WSH_PR_CRITERIA.Get_Lines l_return_status ==> W
  WSH_PR_CRITERIA.Get_Lines returned with warning ==>
  Commiting...
Picking in Release_Batch_Sub is completed
  ERRBUF : RETCODE :1 l_completion_status :WARNING


In addition,  when running the Pick Release Diagnostics, the following error and action is seen:

ERROR - Batch specified delivery detail id '-1' does not match the transaction delivery detail id 'XXXXXXXX'
ACTION - Please match both deliveries


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Shipping
3. Release Sales Orders



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