Getting Excel Upload Error 'Please Select the Proper Excel File'
Last updated on MAY 16, 2012
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 to 7.2.12 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.2, if you try to upload data from an Excel spreadsheet using an *.xls file whose name does not match the name of the file used when creating the Excel-Entity Mapping, the upload fails. The following error appears:
 Please select the proper Excel file and the corresponding Mapping
For example, you create the Excel-Entity Mapping using a file called STG_ADJ.xls. Then, you go to Excel Utilities > Excel Upload, select the Mapping you created previously, and select an Excel File named TEST.xls. This file fails to load.
Note: If you do not get the error message, you may get the following script error instead:
Error: Syntax error
You expect to be able to load data from an Excel file whose name is different from the file used to create the Excel-Entity Mapping.
Steps to Reproduce:
- Go to Unified Metadata Manager > Data Entry Forms and Queries > Excel Upload
- Go to Excel Utilities > Excel-Entity Mappings and create a Mapping using FILE1.xls
- Go to Excel Utilities > Excel Upload
- Select the Mapping created in Step 2 and select Excel FILE2.xls
The upload fails.
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