Excel Upload Gets Spinning Hourglass When Uploading Spreadsheet from Workbook with Multiple Tabs

(Doc ID 2324784.1)

Last updated on NOVEMBER 08, 2017

Applies to:

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

Symptoms

You are getting an spinning hourglass when trying to upload spreadsheet data from a workbook with multiple spreadsheets.  When you go to Excel Upload (atomic) > Excel Upload, select the spreadsheet and mapping definition, and click on Upload, it hangs with the spinning hourglass:

The issue only occurs when you select a worksheet that is not the first worksheet.

For example, the spreadsheet has 3 worksheets:

STG_IRC_RATE_HIST
STG_PAYMENT_SCHEDULE
STG_LEASES_CONTRACTS

If you select and try to load STG_LEASES_CONTRACTS in Excel Upload, you get a spinning hourglass.  If you select STG_IRC_RATE_HIST, it uploads successfully.

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