My Oracle Support Banner

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

Last updated on MARCH 11, 2019

Applies to:

Oracle Utilities Meter Data Management - Version 1.6.1.0 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.

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
 Error
 Steps to Reproduce
Changes
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.