MDM Incorrectly Estimating Bills - Due To Insufficient Data When Historical Data Exists
(Doc ID 2212333.1)
Last updated on SEPTEMBER 21, 2022
Applies to:
Oracle Utilities Meter Data Management - Version 2.1.0.2 to 2.1.0.3 [Release 2.1]Information in this document applies to any platform.
Symptoms
On Oracle Utilities Meter Data Management version 2.1.0.2 and 2.1.0.3, Scalar Estimation VEE rule is creating estimates with 0 value when there are measurements from different contact on the same Service Point. In that case, estimation is done by considering historical data from different contact and no insufficient exception is thrown in that case, since rule was able to find the historical data from different contact.
Steps to Recreate
1. Create Device, Device Configuration, Scalar Measuring Component and Install the Device and attach a usage subscription to the service point with a contact
2. Attach Scalar Estimation VEE Rule to the MC with the following values:
| Parameter | Value |
|---|---|
| Historical Percentage Required | 100 |
| Historical Look First | Last Year |
| Exclude Prior Installations for Different Customers | Always |
| Historical Pre-Window | 30 |
| Historical Post-Window | 4 |
| Allowed Historical System Estimated Data(%) | 100 |
| Allowed Historical User Edited Data(%) | 100 |
| Interim Reading High Threshold Percentage | 300 |
| Interim Reading Low Threshold Percentage | 30 |
| Condition Value for Estimates Created | System Estimate |
3. Create Data on Scalar as follows:
| MSRMT_DTTM (MM-DD-YYYY-HH24:MI:SS) | Reading | MSMRT_VAL |
|---|---|---|
| 02-01-2015-00.00.00 | 0 | 0 |
| 03-01-2015-00.00.00 | 100 | 100 |
| 04-01-2015-00.00.00 | 200 | 100 |
| 05-01-2015-00.00.00 | 300 | 100 |
4.Remove the install event on '09-01-2015-00.00.00'.
5. Create Device, Device configuration and Scalar measuring component and install this device on the above service point with install date/time '10-01-2015-00.00.00'. Attach a new usage subscription with a different contact for the service point.
6. Submit a reading on 07-14-2016-00.00.00 on new Scalar Measuring component.
7. Now, Create an Estimation IMD on 07-15-2016-00.00.00
8. Verify that the IMD gets finalized with 0 and System Estimate even though the contact is different.
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 |
| Steps to Recreate |
| Changes |
| Cause |
| Solution |
| References |