Java.lang.NumberFormatException: For input string Errors Attempting to Run OFSAAI Excel Upload With Decimal Numeric Values (Doc ID 1474496.1)

Last updated on OCTOBER 18, 2012

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.11 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2.10, when attempting to load data through Excel Upload, the following error occurs:

ERROR
[ETL-EXCELUPLOAD]Started to insert the records for the table STG_COUNTRY_RISKat Fri Jun 08 15:26:48 BST 2012
Exception---!
java.lang.NumberFormatException: For input string: "100.8

The row is successfully uploaded if a decimal number (i.e. 102) is used instead of "100.8".


Steps to Reproduce:

1. Attempt to upload data from Template___Country_Risk_Exposure.xls in Excel Upload
==> see error in the log file and data is not loaded

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