E1: BSFN: Calculation with Division and Multiplication in Event Rule Sometimes Gives Wrong Result. (Doc ID 2020607.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

Calculation with division and multiplication in event rule sometimes gives wrong result.

In customer specific case, the NER calculates a formula, and internally it does a multiply of the following intermediate values:
0.03785300000635627*0.88494955516593613

This results in .3349799551732115863790458484504
The expected result is .03349799551732109555584572303882
The wrong result is ten times more.

Issue can be reproduced by created an NER and multiplying the numbers 0.03785300000635627*0.88494955516593613
Note that when you remove a 1 decimal from both values, it does give the correct result again:
0.0378530000063562*0.8849495551659361 = .03349799551732109555584572303882


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