My Oracle Support Banner

PICK_COMPLETE Flag Results In Incorrect Stock Order Selection With Zone (Doc ID 2066170.1)

Last updated on APRIL 15, 2021

Applies to:

Oracle Retail Warehouse Management System - Version 14.1 to 14.1.1 [Release 14.1]
Information in this document applies to any platform.


When waving and distributing orders ,and PICK_COMPLETE flag is set to 'Y' for the consumer direct orders, Retail Warehouse Management System(RWMS) does not restrict the creation of picks to a specific zone that was specified in the wave query.

Steps to Recreate:

1.Create Unit pick locations in two different zones for the two items and make such that there is inventory for one and no inventory for the other .
2.Create Consumer Direct Orders for both skus with PICK_COMPLETE flag as Y.
Example for stock allocation records
A                     ITEM1       10                              0
A                     ITEM2        1                               0
B                     ITEM2         4                              0

ZONE   ITEM        UNIT_QTY   
1            ITEM1          10
2            ITEM2           1

3.Make sure the CD Unit Pick System on Item Master is set to Less Than Case(LTC) for the item used.
4.Run an adhoc wave query for one or more orders and ensure the wave query includes selection of one of the zones for the item setup previously.
               Example for  filter criteria in build query should be as follows:
               DISTRO_NBR = 'A' AND
               ZONE = 1 OR
               DISTRO_NBR = 'B' AND
               ZONE = 2
5.Build query fetches only distro_nbr 'A' and item 'ITEM1' and distro_nbr  'B' and item 'ITEM2'.This is correct. Distro_nbr  'A' and item 'ITEM2' will not be fetched as 'ITEM2' is not part of the zone 1.
6.Distribution should not take place as ITEM2 is only partially distributed and since PICK_COMPLETE is set to to Y, none of the distros should be distributed for that wave.




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

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