Java.lang.NumberFormatException: For input string Errors Attempting to Run OFSAAI Excel Upload With Decimal Numeric Values
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
On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2.10, when attempting to load data through Excel Upload, the following error occurs:
[ETL-EXCELUPLOAD]Started to insert the records for the table STG_COUNTRY_RISKat Fri Jun 08 15:26:48 BST 2012
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
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