My Oracle Support Banner

Mobile Issue Ingredient Not Consuming Duplicate Reservations (Doc ID 2034437.1)

Last updated on FEBRUARY 27, 2019

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..




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.