Picking and Auto Detail Of OPM Batch Doesn't Always Reserve or Pick In Correct FIFO Order (Doc ID 1502866.1)

Last updated on AUGUST 16, 2023

Applies to:

Goal

When receiving the same lot into the same subinventory and locator a second time after having received it earlier, the moqd.orig_date_received is not the same as for the original receipt, and because of this, FIFO picking does not always select the oldest inventory.

The customer noticed this in a scenario in which inventory was inadvertently consumed in a batch with a WIP Issue, but then was put back using a WIP Return. The inventory now has a moqd.orig_date_received equal to the transaction date of the WIP Return instead of the date the inventory was originally received. This does not make sense from a business perspective. This is the most troublesome part of this issue. Note that although this was noticed using a WIP Issue and WIP Return in a batch, this can happen in other scenarios also, it is not specific to WIP transactions in OPM batches.

This is a result, though, of a broader issue. Receive a lot, let's say LOTA, into inventory, through a misc receipt, a WIP Completion, a WIP Return, whatever. The moqd.date_received and moqd.orig_date_received are set to the transaction date, for example, April 11. Receive more of the same lot, even into the same subinventory and locator, with a later transaction date, for example, May 11. This creates a new row in moqd, with both the date_received and orig_date_received set to May 11, even though the original date that the lot was received was April 11. Because of this, once the row in moqd from April 11 is used up, FIFO picking (or AutoDetail Batch based on FIFO picking rules) will select lots that were received between April 11 and May 11 even though LOTA is actually an older lot. This does not really make business sense; it is one lot in one subinventory and locator, it is not really two different "inventories" and so it should all be treated the same, using the same date, in regards to FIFO and picking or OPM batch AutoDetail (which uses the Picking code to create detailed reservations). Note that this happens regardless of the setting of the profile INV: FIFO for Original Receipt Date. That profile only controls whether the orig_date_received is updated when material is moved or transferred.

From a business perspective it seems that picking rules with the FIFO option for Lot should use the lot origination date (that is, mtl_lot_numbers.origination_date), not the moqd date received, since lot origination date in R12 is set to the date the lot is first received into inventory, not the date the lot record was created. If you want to use the date received instead of the lot origination date, there is an option of Receipt Date Asc under the Subinventory and Locator fields on picking rules. FIFO should use lot creation date, but it does not.
 

Solution

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