My Oracle Support Banner

ORA-01426: Numeric Overflow While Meter Read Is Being Added (Doc ID 1329435.1)

Last updated on NOVEMBER 07, 2018

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

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