Mobile Issue Ingredient Not Consuming Duplicate Reservations
Last updated on MARCH 08, 2017
Applies to:Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, OPM Mobile
When there are two reservations for the same lot, subinventory, and locator for an ingredient line, and on the Issue Ingredient page you enter that lot, subinventory, and locator and for quantity you enter the sum of the two reservation quantities, even though the Use Rsrv field autmatically changes to Y, as if it is going to consume against the reservation, what actually happens is that one WIP Issue is created for the total quantity and neither reservation is relieved, they remain.
This can actually leave reservations against inventory that no longer exists onhand.
Customer scenario is that they do Picking in a WMS org, it allocates the same lot from two different LPNs, but the supply subinventory is not LPN controlled, so when they execute the WMS tasks and move the material to the supply subinventory they end up with two reservations for the same lot, subinventory, and locator (with no LPN).
I was able to reproduce the issue without WMS by manually entering the two reservations. I had to enter DFF data on one of the reservations, because normally if you enter two reservations that differ only in quantity the form automatically combines them into one reservation line when you save.
Expect the reservations to be relieved.
The issue can be reproduced at will with the following steps:
1. Create two reservation lines for an ingredient with the same lot, subinventory, and locator.
2. On mobile Issue Ingredient, enter through the Use Rsrv field letting it default to N. Enter lot, subinventory, and locator, and for quantity enter the combined qty of the two reservations. The Use Rsrv field automatically changes to Y.
3. Enter through the qty fields and click Save.
The issue has the following business impact:
Due to this issue, reservations remain against inventory that has already been consumed..
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms