Unable to Update Float Value with 15 Decimals

(Doc ID 1519751.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Utilities Billing Component - Version 1.6.1.1 to 1.6.1.13 [Release 1.6]
LODESTAR EIP - Version 1.6.1.1 to 1.6.1.13 [Release 1.6]
Oracle Utilities Meter Data Management - Version 1.6.1.1 to 1.6.1.13 [Release 1.6]
Oracle Utilities Quotations Management - Version 1.6.1.1 to 1.6.1.13 [Release 1.6]
Oracle Utilities Rate Management - Version 1.6.1.1 to 1.6.1.13 [Release 1.6]
Information in this document applies to any platform.

Symptoms

When attempting to save a record in data navigator GUI when there are 14 decimal places the following error occurs.


ExecuteNonQueryException: Invalid number


Steps to Recreate

  1. Create factor value record in SQL with a value of 14 decimal places
  2. Find this record in Data Navigator GUI
  3. Click save and error occurs



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