How To Get Lots Allocated By Oracle Inventory In First Expired First Out (FEFO) Mode For Move Orders (Doc ID 1124764.1)

Last updated on MAY 15, 2016

Applies to:

Oracle Inventory Management - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
Form: INVTOTRX.FMB - Transact Move Orders
Executable: WSHPSGL - Pick Selection List Generation
Executable: WSHPSRS - Pick Selection List Generation - SRS
Report: INVTOPKL.RDF - Move Order Pick Slip

Goal

On release 11.5.10.2:

Oracle Inventory seems to allocate lots in FIFO mode (first received first out) for move orders.

This behavior is observed in Transact Move Orders form, pick release process, Move Order Pick Slip report, etc, irrespective of the move order type. (requisition move order, sales order / pick wave move order, etc.)

Need to get lots allocated according to their expiration date instead, that is in FEFO mode. (first expired first out)

How to implement this?

WMS is not enabled.

-- Steps
(example with requisition move orders)
Receive a PO line in 5 lots, each lot with a different expiration date
Create a move order
Go to Transact Move Orders form
Query the move order
Press button Allocate

Solution

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