My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.