Spreadsheet Loader Configuration - Configured Spreadsheet Fails With "Java.Lang.ArrayIndexOutOfBounds" Error (Doc ID 2031074.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle HCM Configuration Workbench - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.

Symptoms

When attempting to use HRMS Configuration Workbench for Mass Assignment Update, the following error occurs:

ERROR

Exception Name: java.lang.ArrayIndexOutOfBoundsException - 1
Log File Bookmark: 287082

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Select HRMS Configuration Workbench responsibility

2. Workbench >> Spreadsheet Loader Configuration

3. Click "Go to Task" for Function, Data and Layout Configurator >> Click Create
    a. Function details:
          Data Source: Oracle HR
          User Function Prompt: Mass Update Assignments
     b. Spreadsheet content:
          Entity Type: Person
          Select fields to Spreadsheet

4. Launch Page Security Settings :
     Check: Allow Batch Processing and Update Only

5. Finish and click test

6. Select
     a. Do you want to upload data as a batch process: N
     b. Source BG
     c. Target BG
     d. Do you want to search: Y

7. Continue >> Search for People (by person type)

8. Select all >> Launch Spreadsheet

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