EBS: OPP Out of memory issue...

FO Processor is little more hungry for memory compare to other Java process. If XSLT scalable option is not set and the same time your RTF template is not well optimized definitely you are going to hit Out of memory exception while working with large volume of data. If the memory requirement is not too bad, you can set the OPP Heap size using following SQL queries.


Check the current OPP JVM Heap size using following SQL query

SQL> select DEVELOPER_PARAMETERS from FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP'

DEVELOPER_PARAMETERS
-----------------------------------------------------
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

Set the JVM Heap size using following SQL query

SQL> update FND_CP_SERVICES
set DEVELOPER_PARAMETERS = 'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m'
where SERVICE_ID =
(select MANAGER_TYPE
from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

SQL>Commit;
.
You need to restart the Concurrent Manager to make it effective.

If this does not resolve the issue, You need to optimize RTF template and set the XSLT scalable option true.

Comments:

Ashish, Whats the difference between setting the Java heap space through a DML and setting it in the Options field in concurrent program definition? Thanks, Kavipriya.

Posted by Kavipriya on September 25, 2010 at 12:24 PM PDT #

Hi Kavipriya, As per my understanding, setting the heap size through "option" only apply for main Concurrent Process. It does not apply to OPP and we know these are two separate process. Each CP program/process initializes a separate JVM, but OPP has common JVM for all the OPP process. Thanks

Posted by ashish.shrivastava on September 28, 2010 at 04:11 PM PDT #

Hi,
I am using Oracle Bi tool to generate reports in my project,now i had a requirement to generate a report of having 1,00,000 records..after changing the heap memory and changing the XSLT scalable option as true also i am getting the same error ..the report is generating for 10,000 records only...please do help and suggest me if you have any solution for this.

Posted by guest on May 15, 2013 at 06:14 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today