My Oracle Support Banner

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 JULY 08, 2020

Applies to:

Oracle Inventory Management - Version 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


On release

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


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.