BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"

Summary

BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"

Content

Hello Everyone,

 

We are on Oracle Cloud Application 20B. I was trying to run a BIP excel report and it completed successfully but when I tried to open it somehow it crashed. So I downloaded the xml file and tried to run it on my local PC, but it failed with "java.lang.OutOfMemoryError: Java heap space" error. I found few support documents regarging the issue, but all of them are for Oracle E-Business Suite. Any help/ pointer is appreciated. 

 

The complete error message I got is;