Excel Output File Size Generated By BI Publisher is Very Large (Doc ID 760437.1)

Last updated on NOVEMBER 01, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 5.6.3 to 11.1.1.3.0 [Release 5 to 11.1]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 11.5.10 - 12.1.3
BI Publisher Version: 10.1.3.4.1
Checked for relevance on 4-DEC-2014


Goal

The EXCEL output file size generated by BI Publisher (and XML Publisher in EBS) is very large (nearly 22 MB) and it's taking 20-30 min to view the output.
But after opening this file and saving as .xls the file size is reduced drastically (nearly 3 MB).


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms