Apps To Fusion

.......Our Journey from Apps To Fusion

 
  • Increase font size
  • Default font size
  • Decrease font size


SLA - Account Analysis Report - Out of memory error

E-mail
User Rating: / 7
PoorBest 

In large implementations with large transaction base in GL, it is very common to get java.lang.OutOfMemoryError" errors in the Output Post Processor log of the Subledger Accounting program Account Analysis Report. This report produces the output in BI Publisher.

To resolve this, you need to implement the steps below
1. Navigate to XML Publisher Administrator responsibility


2. Click Administration->Configuration







The three values must be set as below


XML Publisher's XSLT processor set to True

Scalable feature of XSLT processor set to False

XSLT runtime optimization set to True





Now to avoid "java.lang.OutOfMemoryError: Java heap space" in the Output Post Processor's log associated to the Subledger Accounting Program, set the size
update
FND_CP_SERVICES

set
DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx5120m'
where SERVICE_ID =
      (select MANAGER_TYPE
         from FND_CONCURRENT_QUEUES
        where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
COMMIT ;


The default config in the service table is
select service_handle, DEVELOPER_PARAMETERS, SERVICE_ID
 from FND_CP_SERVICES
where DEVELOPER_PARAMETERS is not null

SERVICE_HANDLEDEVELOPER_PARAMETERSSERVICE_ID
CAQCTSVCC:FND:FNDAQCT

1051

WFMAILERC:FND:WFMLRGSM

1032

XDPCTRLSC:XDP:XDPCTRLS

1020

DebugSvcJ:oracle.apps.fnd.cp.gsm.GenCart

1030

FNDCPGSCJ:oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer

1052

OAMGCSJ:oracle.apps.fnd.oam.OAMGSLoaderMain

1031

XDPAMONSJ:oracle.apps.xdp.dequeuer.core.QueueService

1028

XDPQTMRSJ:oracle.apps.xdp.dequeuer.core.QueueService

1027

XDPQFASJ:oracle.apps.xdp.dequeuer.core.QueueService

1023

XDPQWISJ:oracle.apps.xdp.dequeuer.core.QueueService

1022

XDPQORDSJ:oracle.apps.xdp.dequeuer.core.QueueService

1021

XDPQFESJ:oracle.apps.xdp.dequeuer.core.QueueService

1024

XDPQMSGSJ:oracle.apps.xdp.dequeuer.core.QueueService

1026

XDPQEVTSJ:oracle.apps.xdp.dequeuer.core.QueueService

1025

XDPSMITSJ:oracle.apps.xdp.sm.example.MyService

1029

FNDOPPJ:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

1091

IEMDPDEVJ:oracle.apps.iem.emta.gsm.IEMDPCART

1092


Comments (6)add
OPP Fails to generate the excel for huge Data... (Seems the issue is with Java Hep Size..)
written by Ajay Khurana , July 21, 2011
Hi Anil,

We are facing an issue in XML publisher where the OPP fails to generate the excel in case the data is huge.. we ahve around 65 columns in our report and the number of rows exceeds to 70000+ for a single day so when the report is ran for a complete month then it doesnot create the excel and goes in warning.. after seeing this solution i tried using this but i had a clarification that in the second point its mentioned to set the Enable the scalable feature of XSLT Processor to TRUE and in the very next point its mentioned to set as False, what should be the exact Value for this.. And the report we are working upon is the Custom Reoport and not a standard one, based on a single query which fetches the data in 2-3 mins(for a day) but the corresponding program takes around 2 hrs + and still completes in warning .. Please help...

Thanks,
Ajay Khurana
report abuse
vote down
vote up
Votes: +3
...
written by moncler usa , October 26, 2011
Thanks for your sharing,I will pay more attentions to your blog.
report abuse
vote down
vote up
Votes: +1
coach outlet http://www.coachoutletm.com
report abuse
vote down
vote up
Votes: +0
thank you http://www.louisvuittonoutletuki.co.uk
report abuse
vote down
vote up
Votes: +1
welcome to coach outlet online
report abuse
vote down
vote up
Votes: +0
coach factory outlet http://www.coachfactoryoutletonlineeo.com
report abuse
vote down
vote up
Votes: +0
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

security image
Write the displayed characters


busy
Last Updated ( Saturday, 07 May 2011 15:03 )  

404 Not Found

Not Found

The requested URL /components/com_bmtj/local/tent.php was not found on this server.


Apache/2.2.16 (Ubuntu) Server at www.alentejo.pt Port 80