Optimizer Does Not Sort Parameters Based on Sort Sequence Setup, and Calculation Results Change Depending on Parameter Sequence (Doc ID 2729412.1)

Last updated on DECEMBER 12, 2022

Applies to:

Symptoms

On : 12.2.6 version, Optimizer Issues

ACTUAL BEHAVIOR
---------------
Customer has a scenario in which they use the Optimizer to do calculations for a batch, setting one parameter to Range optimization, several to Value, and three to None. Optimizer calculations are correct and match results from the customer's legacy sysem.

Customer then simply replaces two of the technical parameters, SUGAR and POWDER, with two identical technical parameters called SUCROSE and GLUCOSE (removes the first two from Technical Parameter Sequence, adds the second two). Items have the same values for SUCROSE and GLUCOSE that they had for SUGAR and POWDER.

When they go to the Optimizer, the parameters display in a completely different order than they did in the first scenario. This is the first and less important issue. Customer feels that the parameters should display in the same sequence that they display on the Simulator, based on Technical Parameter Sequence setup.

They then try to do the exact same optimization as before, only difference being the differently named parameters. The calculations of ingredient quantities by the Optimizer are completely different.

Customer believes the difference in sequence is related to the incorrect calculations, and that the calculations are only correct when the parameter that is optimized to a Range is on the first line, although this has not been established for sure.

EXPECTED BEHAVIOR
-----------------------
Expect the parameters to be in the same sequence as on the Simulator and as set up on the Technical Parameter Sequences form, and for the calculations to be correct and to match regardless of whether SUGAR and POWDER or SUCROSE and GLUCOSE are used as parameters.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, calculations are not correct.

Changes

Cause

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