ORA-01426: Numeric Overflow While Meter Read Is Being Added

(Doc ID 1329435.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Utilities Meter Data Management - Version: 1.6.1.0 and later   [Release: 1.6 and later ]
Information in this document applies to any platform.

Symptoms

When A Meter Configuration has a validation of Calculate Consumption and the DEFAULTDECIMALS field is set to 0 or 1, and a read is added for 1 hour, the following error occurs.

Error

ORA-01426: numeric overflow

Steps to Reproduce

The issue can be reproduced at will with the following steps:
  1. Meter Configuration should have a validation group with Calculate Consumption.
  2. Set the Meter Configuration's DEFAULTDECIMALS field to 0 or 1
  3. Create a Meter Read for the Logical Meter and make sure that the STOPREADTIME and STARTREADTIME difference will be 1 hour only, and STOPVAL to STARTVAL difference is greater than 0.
  4. Upon saving the read, error will be encountered.

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