Cannot Save WIP Return Transaction Because UOM on Transactions are Different from UOM on Ingredient Line (Doc ID 2898226.1)

Last updated on APRIL 11, 2023

Applies to:

Symptoms

There is an issue when you create a reservation in an OPM batch in a UOM different from the UOM used on the batch ingredient line, then transact the reservation, then try to do a WIP Return. The issue is observed with an item that is lot controlled and not dual UOM controlled although it may happen with other types of tiems.

The batch Material Transaction form defaults the UOM to the UOM used on the material detail line and does not allow the user to change this. However, if you first create a reservation, the Item Reservations Window does allow the user to change the UOM. You can then transact this reservation, creating a WIP Issue in which the UOM is the one from the reservation, not the one used on the batch line. This is inconsistent with the fact that we don't allow the user to create a transaction directly with a different UOM, but it seems to work ok, and the actual qty is correctly updated based on the transaction and UOM conversion.

For example, planned qty of an item is 10 LB, which is the item's primary UOM. Ingredient is Manual consumption.
UOM conversion is created for 1 GL = 4.24 LB.
Create two detailed reservations, one for 5 GL, one for 5 LB.
Reserved qty on Batch Details is correctly shown as 26.2 LB.
Go to batch Material Transactions and transact both reservations.
Actual Qty is correctly updated to 26.2 LB.

The problem occurs when you try to manually enter a WIP Return. On batch Material Transactions, attempt to create a WIP Return for the lot that was issued, with qty of 12 LB. The system gives the error:

ERROR
-----------
APP-GME-82902: You are not allowed to return more than what
has been consumed.

Since 26.2 LB had been consumed, 12 LB is not more than what was consumed.

STEPS
-------
1. Create a reservation for an ingredient in a batch, changing the UOM on the reservation to one that is different from the UOM used on the ingredient line (Production Supervisor > Batch Details > retrieve batch > click Reservations button).

2. Release the batch ((Production Supervisor > Batch Details > retrieve batch > Actions > Release), and if the ingredient is not Automatic Consumption, create a WIP Issue transaction from the reservation (from Batch Details > Transact Material).

3. Enter and try to save a WIP Return (from Batch Details > click Transact Material button > enter WIP Return > click Transact button).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.