Update OPP Java Memory XML Report Publisher Fails With java.lang.OutOfMemoryError

XML Report Publisher Fails With java.lang.OutOfMemoryError
In order to Update Oracle EBS R12 OPP (Output Post Processor) Memory usage you need to run the below update statement :
- To find the current parameter value use the below SELECT statement:
SELECT service_id, service_handle, developer_parameters  FROM fnd_cp_services WHERE service_id = (SELECT manager_type                     FROM FND_CONCURRENT_QUEUES                     where concurrent_queue_name = 'FNDCPOPP');

Output: J:oracle.apps.fnd.cp.gsf.GSMServiceController:-Xmx512M

to update the OPP to use 2G RAM using the below UPDATE statement:

J:oracle.apps.fnd.cp.gsf.GSMServiceController:-Xmx2048M

update fnd_cp_servicesset developer_parameters ='J:oracle.apps.fnd.cp.gsf.GSMServiceController:-Xmx2048M'where service_id = (select manager_type from fnd_concurrent_queues                    where concurrent_queue_name = 'FNDCPOPP');

*) Increase the values for these profiles for at least 2 hours each (7200):
Concurrent:OPP Process Timeout
Concurrent:OPP Response Timeout

*) Restart the concurrent managers
Best Regards,