My Oracle Support Banner

BI Publisher Excel Preview Throwing ArrayIndexOutOfBoundsException Errors When File Name Is 40 Characters or Longer (Doc ID 2793220.1)

Last updated on NOVEMBER 03, 2022

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.21.04.0 and later
Information in this document applies to any platform.
M365


Symptoms


Create a BI Publisher Report template as an Excel file and then save the file.

Rename the file to a name that has 40 characters or more.

When Previewing the Excel template with file name longer 40 characters or longer, it errors with:

ERROR
-----------------------

Preview Failed
Start Excel Preview
only open: false
mTemplate: C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\tmp\tmp.xls
mTmpTemplate: C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp/tmp.xls
java.lang.ArrayIndexOutOfBoundsException: -1
at oracle.xdo.template.excel.object.SheetObject.addComponent(SheetObject.java:179)
at oracle.xdo.template.excel.object.BookManager.collectAllNameObjects(BookManager.java:265)
at oracle.xdo.template.excel.object.BookManager.process(BookManager.java:163)
at oracle.xdo.template.excel.ExcelController.parseExcelTemplate(ExcelController.java:335)
at oracle.xdo.template.excel.ExcelController.generateXSL(ExcelController.java:290)
at oracle.xdo.template.excel.ExcelController.process(ExcelController.java:265)
at oracle.xdo.template.ExcelProcessor.process(ExcelProcessor.java:244)
at ExcelPreview.runXDO(ExcelPreview.java:110)
at ExcelPreview.main(ExcelPreview.java:87)



Tested the report name with 20, 25, 30, 35, and 39 characters and they all worked fine.
But when the file name is 40 or more characters it errors with the java.lang.ArrayIndexOutOfBoundsException error.


No issues when using RTF, it works fine.

 

STEPS TO REPRODUCE:
--------------------
Create a BI Publisher Report template as an Excel file.
Open this Excel file in your Excel 365 version:
Load sample data.
Then preview the report in Excel.
This should work ok.

Close the Excel Preview version
Then save "Save As" the original file with a name more than 40 characters, something like:
Copy of ORACLE_EXP_Outstanding_OneCard_Transactions_TMP

Now, preview the new file, with the name longer than 40 characters, in Excel and it errors when using Microsoft Excel for Microsoft 365 MSO.

 

Changes

 Customer is using Microsoft 365 Apps for enterprise > Microsoft Excel for Microsoft 365 MSO

 

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
Changes
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.