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:

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

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