ORA-01426: Numeric Overflow While Meter Read Is Being Added
Last updated on AUGUST 22, 2016
Applies to:Oracle Utilities Meter Data Management - Version: 22.214.171.124
Information in this document applies to any platform.
ErrorORA-01426: numeric overflow
Steps to Reproduce
The issue can be reproduced at will with the following steps:
- Meter Configuration should have a validation group with Calculate Consumption.
- Set the Meter Configuration's DEFAULTDECIMALS field to 0 or 1
- 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.
- 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
Million Knowledge Articles and hundreds of Community platforms