Exporting OA Framework Table Data To Excel Spreadsheet Throws WebADI error: BNE_CREATE_DOC_ERROR Cause: class java.lang.AbstractMethodError: org.apache.poi.xssf.usermodel.XSSFWorkbook.addToolPack/XSSFClientAnchor.setAnchorType (Doc ID 2992032.1)

Last updated on MARCH 18, 2024

Applies to:

Symptoms

Unable to export Oracle Applications (OA) Framework table data to Excel spreadsheets as the HTML page displays WebADI errors on attempting to create the Excel document. This occurs on any HTML page in the Application, being unrelated to a specific module. The same steps were tested on a 'Vision' standard instance and that also errors out.

Exporting the same data to PDF works fine, using WebADI to upload data into Oracle Applications also works with no error triggered.


ERROR
BNE_CREATE_DOC_ERROR Cause: class java.lang.AbstractMethodError: org.apache.poi.xssf.usermodel.XSSFWorkbook.addToolPack(Lorg/apache/poi/ss/formula/udf/UDFFinder;)V Please contact your system administrator for assistance.
BNE_CREATE_DOC_ERROR Cause: class java.lang.NoSuchMethodError: org.apache.poi.xssf.usermodel.XSSFClientAnchor.setAnchorType(I)V Please contact your system administrator for assistance.

The Vision instance errors similarly:
BNE_CREATE_DOC_ERROR Cause: class java.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/CellType Please contact your system administrator for assistance.



STEPS TO REPRODUCE

1. Using any Oracle Applications responsibility > Navigate to a framework (HTML) page having a list of records displayed
2. On the upper right side of the list, use the '...' button > Export > Excel
3. WebADI spreadsheet's creation starts
4. Error is displayed on the page
5. Repeat step 2. but pick PDF for the export output
6. Note that works fine and the data is exported

Changes

 Upgraded from 12.1.3 to 12.2.10, TXK Oracle Applications Technology Stack C.14.

Cause

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