Workflow error due to reservations issue

The scenario with which we are facing the issue is as described below:

Scenario: We need to book a Bill Only Order for quantity 2, let’s say for an item = ABC and Lot = 123. This issue is only when the same item-lot combinations are present in 1 quantity each in different locators L1 and L2.

 Now when we enter an order and on saving, quantity 2 is reserved and the reservation details are as below

Item=ABC     Lot=123     Qty=2

 

Now on booking the order the Standard Reservation API in Oracle checks for the existing reservation and hence updates the above reservation as below