My Oracle Support Banner

E1: 46L: R46171 Picking with Tiebreaker 2 Not Working with Allowed Lot Status Group (Doc ID 2863689.1)

Last updated on NOVEMBER 01, 2023

Applies to:

JD Edwards EnterpriseOne Warehouse Management - Version 9.2 and later
Information in this document applies to any platform.


When Picking Tiebreaker (MLS2) is set to equal 2 - Pick Fewest with Best Fit and there are multiple Picking requests/suggestions for the same item and lot number in a License Plate Branch then it is picking the wrong location and issuing error 3448 - Quantity remains even though ample availability exists in other locations. The problem appears to occur when there are 2 orders and the first order has been suggested which created a hard commitment on the best fit location. When another order for the same item and lot is suggested it picks the same location again, which has some quantity remaining available, but not enough to full fill the second order. As a result error 3448 - Quantity Remains is issued as it fails to resolve any of the other locations that have enough quantity available. Issue only happens when R46171 processing options are set up with a Allowed Lot status Group and with Picking Tiebreaker 2, Tiebreaker 1 and 3 are working fine.
In BSFN B4600330 - F46095SelectPickingLocation when allowed lot status group has a value it appears to calculate the quantities incorrectly and then passes On-hand instead of available quantity to B4600250 - CacheLocationTieBreaker resulting in the selection of the incorrect location.

Steps to Duplicate:
1) P46095 Set up Random Picking instructions with Tiebreaker = 2 - Pick Fewest with best Fit
2) Set up license plate item with 1 PL = 120 EA
3) Set up 3 locations and adjust quantity all with the same Lot number
2. - 360 EA (3 LPN / PL)
2.A - 240 EA (2 LPN / PL)
2.B - 200 EA (1 full and 1 partial LPN )
4) P4210 enter 2 orders creating Pick requests, each order/request for 1 PL = 120 EA
5) P41081 Set up Allowed Lot status Group and Populate Allowed Lot status group in R46171 processing option
6) R46171 process first order/pick request and suggestion is correctly created for location 2.B with the least quantity
7) Availability after first suggestion has location 2.B with 120 EA committed and 80 available
8) R46171 process second order/pick request and suggestion is incorrectly created again for location 2.B which does not have enough quantity
The result is that 80 EA are suggested and error 3448 - Quantity remains is issued for the remaining 40 EA
9) Cancel the suggestion for the second order and re-run R46171 with Allowed Lot Status Group blanked out and it correctly picks location 2.A which had 240 EA available


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.