We have seen many questions how to generate BI Publisher XLSX output in EBS 12.1.3 using Excel templates.

Here are the examples:

Link1, Link2, Link3, Link4, Link5, Link6, Link7

The following MOS Documents confirms that it’s not possible generate an XLSX output in Oracle EBS:

Is There Option Of Generating Excel Output as MS Excel 2007/2010 XLSX From A Concurrent Request? (Doc ID 1604001.1)
E-Business Suite R12:- How To Create Excel Template In R12.1.3 Version? (Doc ID 2272182.1)
Can .xlsx Report Output Be Generated From RTF Template In EBS 12.2? (Doc ID 2336999.1)

You may want to use the XLS as the XLSX option is not available. But you may soon hit the 65,536 row limit for the XLS. It would be great if a new excel sheet is created in such a case. But again it doesn’t work in EBS 11i and R12.1.

Blitz report solves the both issues. It generates output files in an XLSX or CSV format. It’s also possible to generate a PDF output using a custom postprocessing option. Blitz Report can generate output files of an unlimited size and number of rows. Output files in XLSX format have an overflow to additional worksheets at every 1,048,575 rows.

Please refer to this Enginatics blog post to migrate your existing BI Publisher reports to Blitz report:

How to quickly create or modify Oracle E-Business Suite BI Publisher based reports

The tutorial video will help you to understand the process quicker: