Incorrect Calculation Rule Works (Calculate Final Reading Values) (Doc ID 2169882.1)

Last updated on OCTOBER 03, 2022

Applies to:

Symptoms

On : 2.4.0.3.0 version, BI - Billing

When using the calculation rules "Calculate Final Reading Values" only 5 Bill Factors can be added correctly.
When one tries to add the sixth, and try to use them in a rule - it is impossible. The values of these Bill Factors is always zero.
I.e. One can add the 6-th or 7-th, but if he uses them it is always equal to zero in BF.

ERROR
-----------------------
SHSS - 438474-3108496-1 2016-06-27 18:14:06,427 [Parent Reader:Thread-51] ERROR (api.expression.ExpressionException) There is no variable defined with name 'v7'. col 1:#v7
v7
^
com.splwg.base.api.expression.ExpressionException: (Server Message)
Category: 11001
Number: 3312
Call Sequence:
Program Name: ApplyFormula_Impl
Text: There is no variable defined with name 'v7'. col 1:#v7
Description:
Table: null
Field: null

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Rate Schedule
2. Create calculation group
3. Create calculation rule
4. Bill Factor as Scalar Variable 7
5. Final reading value (selected) - is zero, but if a rule to change the formula (change V7 to V5) - the plan is executed correctly.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Incorrect calculation rule works (Calculate Final Reading Values)

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.