Order Remains At Ready To Release Status

(Doc ID 2382944.1)

Last updated on APRIL 05, 2018

Applies to:

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

Symptoms

Sales orders that were submitted through the pick release program remains at a status of "Ready to Release". The following messages are found in the log file.

  DELIVERY DETAIL LINE NOT FOUND: xxxx
  NO_DATA_FOUND exception has occured.
  Exiting WSH_PR_CRITERIA.GET_DETAIL_LOCK - EXCEPTION:NO_DATA_FOUND
  GET_DETAIL_LOCK RETURNED WITH WARNING
  Exiting WSH_PR_CRITERIA.INSERT_RL_ROW
  WARNING: SKIPPING THE ORDER LINE

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
Exiting WSH_PICK_LIST.RELEASE_BATCH_SUB
Return from Release_Batch_Sub
retcode ==> 1
errbuf ==>

EXPECTED BEHAVIOR
-----------------------
The expectation is for sales orders that were pick released to progress to the next status such as "Released to Warehouse" or "Staged/Pick Confirmed".


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