My Oracle Support Banner

Issues With Quantity Calculations When Using Lot Level Conversions Along with Auto Detail Batch and MES Dispensing (Doc ID 2702119.1)

Last updated on AUGUST 18, 2020

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Batches

Have item that is set up as dual uom controlled and has lot level conversions setup.
Item is an ingredient the quantity is in secondary uom.
When auto detail line or auto detail batch is run for this ingredient item, the reservation has incorrect secondary quantity and primary reservation quantity.
Looks like code converts reservation quantity (which is secondary quantity) to primary quantity using the item level conversion. Then converting back to secondary using lot level conversion.

When the user changes the WIP Planned quantity for this ingredient line and then auto details line again, receive the following error:
In the inventory log file, see that it fails the deviation check.

Also noticed that in the materials Transaction form in OPM batches, the  transaction qty, primary qty and secondary qty are not being calculated correctly after performing auto detail and then dispensing in MES Workbench.

ERROR
-----------------------
Could not query reservation.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Production Supervisor
2. Navigation: Batch Details



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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