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: and later   [Release: 1.6 and later ]
Information in this document applies to any platform.


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.


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.


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