Creating OPM Batch, Ingredient Qty Is Incorrect If It Has An Item Substitution
Last updated on FEBRUARY 24, 2017
Applies to:Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Batches
Problem with Item Substitution when creating an OPM Batch and the substitution occurs. The original item and the substituted item have primary UOM of KG, and the UOM in the formula is KG. The item substitution rules are set so that 1 KG is replaced by 1 KG. However, when the batch is created, the quantity for the substituted item has been multiplied by 2.20462; that is, it has been converted to LB, although the UOM still shows as KG. The quantity should not be getting converted. LB is the base UOM for the UOM class containing KG and LB, but that should not matter.
This is happening only when the item substitution is defined in KG. This is working when it is LB. The problem is the ingredient qty is calculated in LB and displayed as KG.
Expect the ingredient quantity and UOM to be correct when there is an item substitution
The issue can be reproduced at will with the following steps:
1. Responsibility -> Formulator
2. Define the Item Substitution for an ingredient.
3. Define the Formula with Ingredient in multiple lines in formula.
4. . Responsibility -> Production Supervisor ->Create a batch and notice that substituted items are not replaced with correct quantity and unit of measure
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