RSS

Monthly Archives: September 2014

Unable to determine SMTP server to use: set FND_SMTP_HOST

Problem:
Unable to determine SMTP server to use: set FND_SMTP_HOST

Symptoms:
– report ends with Warning
-the report log file shows ==> 1) PUBLISH ————-+ Emailing output to xx@xxx.xxx
– with consulting OPP log file shows ==> [UNEXPECTED] [51410:RT648550] oracle.apps.fnd.cp.opp.PostProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST

Solution:
Change the profile option :
FND: SMTP Host –-> Give your smtp server name or IP
FND: SMTP Port –-> give your smtp server port (By default – 25).

 
1 Comment

Posted by on September 3, 2014 in Action_Plan, apps_dba, E-Business Suite

 

Tags: , , , ,

XML Report Publisher Fails With java.lang.OutOfMemoryError

Problem:
XML publisher completing in Warning when data size is big. One or more post processing actions failed java.lang.OutOfMemoryError

Symptoms:
– report ends with Warning
– with consulting OPP log file shows ==> Caused by: java.lang.OutOfMemoryError: Java heap space

Solution:
1. First test how much memory you can create in OS using the following command
$java -mx2700m -version

2. 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’);

3. Increase the Heap Space per Process to 1024 or to maximum result of OS command:
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’);
commit;

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

5. Restart the concurrent managers
 

Tags: , , , , , , ,