AutoDetail Batch is Failing to Reserve the Oldest Lot Based on FIFO Picking Rule When One Lot Cannot Fulfill the Entire Planned Quantity (Doc ID 2864134.1)

Last updated on FEBRUARY 28, 2024

Applies to:

Symptoms

Picking rule is set up for FIFO with Single Lot Allocation field UNchecked, Partial Allocation Allowed field checked.

When the lot that was first in based on moqd.orig_date_received does not have enough available to completely fulfill the planned qty, the system is failing to reserve all the available of that lot first and then move on to the next lot for the rest. Instead, it is taking the full planned qty from the second lot, as if Single Lot Allocation was checked, or Partial Allocation Allowed was unchecked.

If the reservations are then deleted, the planned qty reduced to less than the available from the first lot, and Autodetail is run again, the system does reserve from the first, correct, lot. So it is clear that this lot can be reserved, and is only bypassed when it cannot completely fulfill the planned qty.

EXPECTED BEHAVIOR

-----------------------

Expect the system to reserve the full available of the first lot, and reserve the remaining required qty from the second lot.

STEPS

-----------------------

The issue can be reproduced at will with the following steps:

1. Have multiple lots with different orig_date_received, with the earliest received lot having less than the planned qty of the ingredient.
2. In the batch, run Autodetail Line (Production Supervisor > Batch Details > Inventory > Autodetail Batch.
3. Check the reservations created (from Batch Details > Inventory > Maintain Reservations).

Changes

The issue was noticed after upgrading from 12.1.3 to 12.2.11

Cause

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