EEX 9.2: "Fetching Array Element 0: Index is Not in Range 1 to 6. (180,252)" Error When Trying View Expense Reports Under Old Workflow. (Doc ID 2017899.1)

Last updated on FEBRUARY 20, 2023

Applies to:

Symptoms

On : 9.2 version, Expense Report

User gets PeopleCode error when trying to View Expense Report approved under old workflow.

Error:
-------
"Fetching array element 0: index is not in range 1 to 6. (180,252) EX_UI.ExpenseSubmit.ApprovalTrain.OnExecute Name:PopulateApprovalTrain PCPC:7384 Statement:115
Called from:EX_EXPENSE_SUBMIT.Activate Statement:66

While fetching the value of an array element, the index was not within the length of the array."
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Setup 
----------
1. Create clone of the ERApproval Process Definition.
2. Change the stage number of Pre Pay Auditor to 80.
3. Inactivate the new Process Definition (Make sure there are multiple ERApproval Process Definitions, out of which the latest effective dated row is Inactive)
4. Enable HR Supervisor & Pre Pay Auditor for Expense Report Approval for the ERApproval Process Definition which is Active.

Replication Steps:
--------------------------
1. Go to Employee Self-Service > Travel and Expenses > Expense Reports > View

2. Open the Expense Report approved under OLD workflow and note that the above error message is displayed. 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view the expense report created with old workflow.

Changes

Cause

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