Bi Publisher report completed warning for huge data - java.lang.OutOfMemoryError: Java heap space

Hi All,

We have a custom employee timecard BI report which runs for smaller range of period parameters, but when running for larger range it runs for long time and completes with warning with no output.

We tried different options referring to metalink, but still facing the same issue. 

 

The current value is for the below query is : "J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m"

Query: select developer-parameters from FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

 

Under FO Processing, set:

 

  o Use XML Publisher's XSLT processor set to True