My Oracle Support Banner

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

Last updated on APRIL 01, 2020

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


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.