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 laterInformation 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 |