Getting n error when executing large xml data report in oracle apps R12

Question

Summary

Content

Template code: ERP_DEBTORS_LEDGERNEW_1 Template app:  ONT Language:      en Territory:    IN Output type:  PDF Exception in thread "REQTMGR:8249314" java.lang.OutOfMemoryError: Java heap space                 at java.util.Arrays.copyOf(Arrays.java:2882)                 at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:100)                 at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390)                 at java.lang.StringBuilder.append(StringBuilder.java:119)                 at oracle.apps.fnd.cp.opp.OPPRequestThreadManager.checkThreads(OPPRequestThreadManager.java:290)                 at oracle.apps.fnd.cp.opp.OPPRequestThreadManager.run(OPPRequestThreadManager.java:99)                 at java.lang.Thread.run(Thread.java:682) [5/30/18 10:15:11 PM] [Exception in thread "OPPServiceThread0" java.lang.OutOfMemoryError: Java heap space Exception in thread "OPPAQMON:8249314" java.lang.OutOfMemoryError: Java heap space UNEXPECTED] [OPPServiceThread1] java.lang.OutOfMemoryError: Java heap space

Brajesh Shukla-95078 · Answer

Due to exhausted heap size sometime this happened when you try to generate the pdf output for big xml data. To solve this in the concurrent program window > Option you can specify dedicated heap size as -Xms1024m -Xmx1024m this should solve the problem. Many standard xml report in R12 uses the same thing.

Shakher Sharma · Answer

If it is  a custom report, you can rename XML tags and make them smaller, that should help reducing the size of XML file. Also, Try to break down output into multiple smaller chunks for example, instead of running report for a whole year, run it for each period, or quarter instead at one time.

Vinay A Sawant · Answer

Already 2.5GB is there How much size required