My Oracle Support Banner

E-BIP/XMLP: BI Publisher Report Designed with Excel Template Fails with the Error "ArrayIndexOutOfBoundsException -1" when Previewing the Excel Output Format (Doc ID 3035931.1)

Last updated on JULY 23, 2024

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a BI Publisher report designed with Excel Template the following error occurs and no fields are displayed in the Excel output report:

The issue can be reproduced at will with the following steps:
1. Navigate to Reporting Tools > Connected Query > Connected Query Manager.
2. Search by a particular Connected Query.
3. Download the xml file.
4. Open Oracle BI Publisher Desktop installed on User's machine.
5. Create a new Excel Template based on the xml file downloaded.
6. From MS Excel select the BI Publisher menu.
7. Load the XML file.
8. Run the report to Excel.
9. The error occurs.

Cause

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
Symptoms
Cause
Solution


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