My Oracle Support Banner

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

Last updated on OCTOBER 03, 2022

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.2.0 to 2.5.0.2.0 [Release 2.4 to 2.5]
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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