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

Last updated on JULY 10, 2017

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.

Symptoms

When waving and distributing orders and PICK_COMPLETE flag is set to 'Y' for the consumer direct orders, 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
DISTRO_NBR ITEM_ID  REQ_UNIT_QTY  DISTRIBUTED_UNIT_QTY
----------------------------------------------------------------------------------------------
A                     ITEM1       10                              0
A                     ITEM2        1                               0
B                     ITEM2         4                              0

PICK_FROM_LOC
------------------------
ZONE   ITEM        UNIT_QTY   
---------------------------------------
1            ITEM1          10
2            ITEM2           1

3.Make sure the CD Unit Pick System on Item Master is set to 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.

Changes

 

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