Incorrect 'First Expired First Out (FEFO)' Logic in the Pick Directive Table as Per the PICK_ORDER Column (Doc ID 1611215.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Warehouse Management System - Version 13.2.3 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Warehouse Management (RWMS) 13.2.3, we note that when we run pre-planned replenishment for perishable items, there appears to be incorrect 'First Expired First Out (FEFO)' logic in the pick directive table, as demonstrated by values in the PICK_ORDER column.


Steps to Reproduce:

   Pre-Condition:  Set the expiration_days value in the ITEM_MASTER table as 10 days.

   1. The process on the item is set as BR_PICK, BT_PICK and U_PICK.
   2. Ensure the reserve/FPL locations have the same processes assigned. The FPL has inner pack qty as 1; capacity of the location is 100, UNIT_QTY = 0.
   3. Create a purchase order (PO) in Retail Merchandising System (RMS).  Receive it using appt type as FPR with details.
   4. Receive the 4 pallets in the following sequence:
     Pallet ID: PAL6042-1 Quantity: 10 BBD: 7 Dec 2013
     Pallet ID: PAL6042-2 Quantity: 30 BBD: 9 Dec 2013
     Pallet ID: PAL6042-3 Quantity: 40 BBD: 8 Dec 2013
     Pallet ID: PAL6042-4 Quantity: 20 BBD: 6 Dec 2013

   5. Create a stock order for the above item with qty as 30.
   6. Assign the stock order to a wave and run the distribution process.
   7. Once pick directives are created, review the pick order.  Pick order sequence is incorrect.

   Expected Result:  The pick order sequence should be:

     Pick Order 1:
     Pallet ID: PAL6042-4 Quantity: 20 BBD: 6 Dec 2013

     Pick Order 2:
     Pallet ID: PAL6042-1 Quantity: 10 BBD: 7 Dec 2013

     Pick Order 3:
     Pallet ID: PAL6042-3 Quantity: 40 BBD: 8 Dec 2013

     Pick Order 4:
     Pallet ID: PAL6042-2 Quantity: 30 BBD: 9 Dec 2013

 

  Actual Result:  Pick order sequence is in the order received.  This appears to be incorrect FEFO logic in the pick directive table.


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