0

The xml report generates a huge file (xls) of arounf 800 MB- 1 GB. The system hangs when trying to open the file. Tried opening a 400 MB xls file and saved it as xlsb which reduced the file size to 4.5 MB. Is there a way to generate the output in xlsb format instead of default xls. Oracle Apps version is 12.2.6.

kfinity
  • 8,581
  • 1
  • 13
  • 20
little_amb
  • 84
  • 5
  • It sounds like you're using Oracle E-Business Suite, and trying to get more compressed Excel reports using XML Publisher (ie, BI Publisher). Is that right? – kfinity Feb 08 '19 at 15:12
  • Sounds like your query is collecting too much data. Have you made sure it’s correct? – EdHayes3 Feb 09 '19 at 04:18

2 Answers2

1

You can use E-text templates to produce a comma separated value (csv) file. It’s usually used for EFT transfers for banks. But you can make it do whatever you want. Since it’s only text, it won’t have any of the formatting markup that an BI publisher would add to an Excel file. You can then open it up in Excel and do what you wish with it.

EdHayes3
  • 1,777
  • 2
  • 16
  • 31
  • Tried printing the text output ,pipe separated columns. Notepad crashed while opening the file which had around 0.5 million rows. – little_amb Feb 09 '19 at 14:27
  • Microsoft notepad is not good for large files. Try notepad++ (https://notepad-plus-plus.org) if you want to open the file you created. Else, you can open in Excel too. How's the file size? – EdHayes3 Feb 10 '19 at 19:31
0

As far as I'm aware, BI Publisher can not do it and Oracle has an enhancement request logged for this: Bug 24545689 : BI PUBLISHER EXCEL .XLSX TEMPLATE

For large data exports from Oracle EBS into native .xlsx format, you can use a third party solution such as our Blitz Report: www.enginatics.com/faq/#how-does-blitz-report-compare-with-oracle-bi-publisher

It is free for limited use.

Andy Haack
  • 429
  • 3
  • 6