Pick Release Error With Quantity Entered Does Not Meet Decimal Quantity Standard Causing All Lines In Batch to Not Pick
Last updated on JUNE 01, 2018
Applies to:Oracle Shipping Execution - Version 12.2.6 and later
Oracle Warehouse Management - Version 12.2.6 and later
Information in this document applies to any platform.
In an WMS enabled Org, eligible lines are not getting pick released using standard pick release-srs program.
As part of end-to-end testing for sales orders there are certain eligible lines that are not getting pick released when run as either of following:
- Standard Pick Release SRS program
- Concurrent request using the form (without order number)
Pick Release SRS or Concurrent request via form is scheduled to run every 20 minutes for a large number of orders. Daily order volume is around 3,500 which adds up to 8,000 plus order lines daily.
Every time pick release request set is run, 24 child pick release processes are running.
Each pick release child process is typically less than 1000 lines.
The profile option WSH: Pick Release Batch Size = 1000.
Example of current behavior:
Order with 4 lines where all 4 lines are eligible to pick release meaning there are no credit check holds and there is sufficient quantity on hand:
> 1st batch will pick release 2 out of 4 lines even though all 4 lines are eligible to pick release.
> 2nd batch will pick release one more line from the same order.
> A few more batches later the 4th line gets pick released.
This is a problem as the order lines that get pick released in separate batches end up getting a different delivery id created and assigned to the order lines. However when running pick release concurrent
request through the form with a specific sales order then it is pick releasing all eligible lines for that sales order. This is being used as a WORKAROUND. Expect that order lines that are eligible to pick release
having sufficient quantity, no credit check failure or holds will all be pick released at the same time when submitting the Pick Release SRS and NOT released across multiple separate batches.
In one batch, the following error was found and it caused all records in the batch to fail. Once the lines with the decimal quantity error were cancelled and pick release submitted. Eligible lines were pick released.
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
4. Pick Release SRS
Item attribute OM Indivisible checked
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