Getting Error '1516 Please upload right excel file' Trying to Use Excel to Import Static Table Driver Definition
(Doc ID 2671523.1)
Last updated on MAY 03, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.7 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Symptoms
In PFT 8.0.7, in the Static Table Driver definition screen, when attempting to import definition data from an Excel spreadsheet, the upload fails and the following message appears:
1516 Please upload right excel file
Additionally, the following error exists in the pftapp.log from the Web Server's OFSAA logs directory:
[21-11-19 18:24:50,452 GMT PM] [INFO ] [WEB] Inside importDataFromExcel
[21-11-19 18:24:50,454 GMT PM] [ERROR] [WEB] Error in uploading file
java.lang.ClassCastException: java.io.FileInputStream cannot be cast to java.io.ByteArrayInputStream
at com.ofs.fsapps.pft.action.ClsActTableId.importDataFromExcel(ClsActTableId.java:3019) [PftApp.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_212]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_212]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_212]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_212]
As a result, you cannot import the Static Table Driver definition from Excel.
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 |
Cause |
Solution |
References |