My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

Applies to:

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


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

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


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

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