Pick Release Reserve quantity not the requested quantity
Summary:
We create sales orders for non primary or secondary UoM's. But Oracle transacts in inventory using primary UoM. Our UoM's conversions for certain items converts the value from the ordered quantity to Primary Unit of Measure into decimals. As an example, 1000lbs converts to 51 stacks and when sales orders are placed for 15550 lbs, it converts to 793.05 stacks. And stacks is our primary UoM. However we never transact in decimals. Instead, we would like to use either 794 stacks or 795 stacks.
Also prior to picking we set aside inventory using reservations. At this point we are able to over reserve to 795 stacks. Oracle allows this and doesn't stops us. After this we run pick release with 'Prior Reservation' flag checked. Pick wave is successful and only picks to the requested quantity. And when we try to over pick, Oracle throws the error that there is a reservation and doesn't allow us to over pick. We enabled Over pick confirm option in Organization parameters.