My Oracle Support Banner

Optimizer Calculates Incorrect Quantity When Selecting Single Lot for Calculation (Doc ID 2178040.1)

Last updated on FEBRUARY 28, 2019

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, Simulator/Optimizer Issues

While using the Optimizer to calculate ingredients quantities, the calculation is done incorrectly when using the Workpad to select a single lot for calculation.

Retrieve a batch on Simulator. Allocate two lots. Go to Optimizer, go to Workpad, and bring just one of the lots over to the Calculate section. Then back on Optimizer, select Value for a parameter, and click Calculate.

Optimizer acts as if the other lot is not being used at all, and so it takes all the required qty for optimization from the one lot, but then it adds this to the qty of the other lot that had been allocated. It is as if it assumes the non-calculated lot is not being used at all to calculate how much of the calculated lot is needed, but then it goes ahead and uses both lots. Because of this, it uses more qty of that ingredient than is necessary, and no longer respects the Yield Factor. Per discussions, it should recognize that the lot not selected for Calculation is still being used, just at the fixed qty that was allocated.

Expecting the Optimizer to recognize that the lot that is not selected for calculation on the Workpad is still being used and still contributes to the final product.

The issue can be reproduced at will with the following steps:
1 Create Formula
2 Create Recipe
3 Create Inventory Lots for ingredients used in step 1
4 Create Item Specifications for items used in previous step
5 Create a Batch using Recipe created in step 2
6 Navigate Formulator>Simulator
7 Query the Batch created in step 5
8 Select the line in respect to item used in step 3
9 Menu Actions>Select Available Inventory, and select two lots
10 Using Workpad, select only one of the Lots to calculate




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.