My Oracle Support Banner

Is There a Way to Setup a Picking Rule to Allocate Only From a Single Lot and From the Lot With the Smallest Onhnad Quantity Meeting the Demand? (Doc ID 2459016.1)

Last updated on AUGUST 11, 2022

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.


Is there a way to allocate only from a single lot and from the lot with the smallest on-hand quantity (available units) meeting the demand?

The business requirement is ship the full order line quantity, all from the same and smallest possible Lot.
Mixing Lots in one order line is not allowed.

Business Requirement

Let's say you manufacture porcelain and ceramic tile, which by nature has variances in
color shade as it comes out of the kiln.  You manufacture different lots per item number
as a way of grouping product with similar shade variances, and re-fill and
re-use of those Lots.  As the product comes out the kiln, the product is inspected and
added to the corresponding Lot.

Sales Orders are then processed. The order must allocate product only from a single and
from the first lot having the smallest quantity to meet the demand quantity.
In addition, partial orders cannot be shipped.

Therefore, the desired behavior is for the picking rule to allocate the full (order line) demand quantity from a single Lot.


1. Demand = 624 units
    SORT Lots by available units, ascending.
    We would want to allocate the first lot that can meet the full demand quantity.

    Lot A available 125 units, do NOT allocate
    Lot C available 600 units, do NOT allocate
    Lot B available 850, allocate 624 units
    Lot 9 available 2500 units, do NOT allocate

In this example, Lot B is the first lot having the minimum quantity to fill the order in its entirety.
Lot B balance after processing would be: 850 = 624 = 226 units

2. Another example if you just had on-hand for a single lot (LOTA)

Case 1:
Demand: 1000
LOTA: 1200
LOTA will allocate 1000 units

Case 2:
Demand: 1000
LOTA: 1000
LOTA will allocate 1000 units

Case 3:
Demand: 1000
LOTA: 800
No allocation will occur


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.