While Using FIFO, Serials Are Not Allocated Correctly After They Are Sub Inventory Transferred (Doc ID 879924.1)

Last updated on APRIL 18, 2025

Applies to:

Symptoms

-- Problem Statement:

In Oracle Inventory, when 'INV: FIFO for Original Receipt Date' profile is set to Yes, allocation of Sub-Inventory transferred serial numbers does not happen on the basis original date received. Instead, it happens on the basis of date of Sub-Inventory transfers.

Steps

---------

1. Set 'INV: FIFO for Original Receipt Date' profile to Yes.

2. Create serial controlled item.

3. Perform Misc Receipt of Serial S1 on 01-JAN-09

4. Perform Misc Receipt of Serial S2 on 02-JAN-09

5. Perform Sub Transfer of Serial S2 on 03-JAN-09 to Stores.

6. Perform Sub Transfer of Serial S1 on 04-JAN-09 to Stores.

7. Create a move order for quantity 1 Ea from Stores to FGI.

8. Query the MO in Transact Move Order and click allocate button.

9. Now goto view/update allocations -lot/serial

Observed Behavior:

Serial S2 is picked up.

Expected Behavior:

Serial S1 should be picked up.

Cause

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