Error: oracle.apps.xdo.XDOException: Java heap space in OPP reports


Error:

EBS R12.1.3  all reports started going into a warning.

Logs of opp were showing oracle.apps.xdo.XDOException: Java heap space


Solution 1:

Restart OPP services

Solution 2:


1. Determine what the heap size per OPP process is currently:

select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');


2. The default should be:
 
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m


3. Increase the Heap Space per Process to 1024: ( 1024 = If you want to increase the Heap Memory to 1GB) 
 
update FND_CP_SERVICES
set DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
 
4. Bounce the Concurrent services.




If you like please follow and comment