'Java.lang.ArrayIndexOutOfBoundsException' Error in Excel Upload (Doc ID 1480309.1)

Last updated on JULY 21, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 20-Feb-2014.

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.3, you get the following error when uploading data from Excel:

[4272] Error in Excel Upload

The following error appears in the Excel Upload log in /<ftpshare>/STAGE/ExcelUpload/logs:

Exception---!
java.lang.ArrayIndexOutOfBoundsException: 17

The error prevents the data from getting loaded into the Target table.

Steps to Reproduce:

  1. Go to Unified Metadata Manager
  2. Go to Data Entry Forms & Queries > Excel Upload
  3. Go to Excel Utilities > Excel Upload
  4. Select the Excel file and the Mapping
  5. Click Upload

The error appears.

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