Overpick & Overship with Indivisible Lots: Pick Wave Backorders Despite Reservation and Tolerance

Hi Oracle Community,

We are trying to solve an interesting scenario and would appreciate insights from anyone who has implemented a similar process.

Our requirement is to:

• Use lot-controlled items
• Keep Lot Divisible = No
• Keep Negative Inventory = Not Allowed
• Allow overpicking based on reservation
• Allow overshipment within a 10% tolerance
• Pick and ship the entire indivisible lot when the lot quantity is slightly higher than the Sales Order demand

Example

Sales Order demand = 2,000 lb

Available lots:

• Lot A = 1,980 lb
• Lot B = 2,000 lb
• Lot C = 2,030 lb

We want to fulfill the 2,000 lb Sales Order using Lot C (2,030 lb) and ultimately pick and ship the full 2,030 lb, since it falls within the configured 10% overshipment tolerance.