Creating OPM Batch, Ingredient Qty Is Incorrect If It Has An Item Substitution (Doc ID 2237671.1)

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.

Symptoms

On : 12.1.3 version, Batches

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

EXPECTED BEHAVIOR
-----------------------
Expect the ingredient quantity and UOM to be correct when there is an item substitution

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


Cause

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