My Oracle Support Banner

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

Last updated on MARCH 13, 2019

Applies to:

Oracle Utilities Customer Care and Billing - Version and later
Information in this document applies to any platform.


On : 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.

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
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
Table: null
Field: null

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.

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


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.