RSS

Category Archives: E-Business Suite

compile jsp in EBS R12

compile jsp in EBS R12

Compile a jsp page:
cd $OA_HTML
$FND_TOP/patch/115/bin/ojspCompile.pl –compile -s ‘xxxx.jsp’ -log err.log –flush

Compile all jsp pages:
$FND_TOP/patch/115/bin/ojspCompile.pl –compile  –flush -p 4

Enable Automatic Compilation of JSP pages in R12
edit the $CONTEXT_FILE
Change value for the entry s_jsp_main_mode from justrun to recompile

run AutoConfig, restart the web tier services.

 

Tags:

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: , , , , , , ,

R12- Unable to Authenticate Session

this is one of the common problem with common solution

On the target “Cloned” of a E-Business Suite Release 12.1.3, the logon is failing with following error :

Unable to Authenticate Session

SOLUTION:

1. Clear the Browser cache.

2. Stop all Browser sessions.

3. Start a new Browser session and logon to the Instance.

 

Tags: , , ,

R12 after clone Error -FRM-92101 – on OEL5.7

after cloning R12 instance on OEL 5.7 64bit to TEST instance and when I started services normally, an error apprears when access the forms, getting the following error

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Please look into the web-server log file for details

 
Java Exception
oracle.forms.net.ConnectionException:Forms sessionfailed during startup:no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown source)
at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DataOutputStream.flush(Unknown source)
…………………………………………………………..

I have looked into the forms server log file which is given below

$LOG_HOME/ora/10.1.3/opmn/forms_default_group_1/formsstd.out

and found the following error

FormsServlet init():
configFileName: /u01/DEV/inst/apps/DEV_mkhots06/ora/10.1.2/forms/server/appsweb.cfg
testMode: false
Oracle Containers for J2EE 10g (10.1.3.4.0) initialized
ListenerServlet init()
Forms session <1> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Forms session <2> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Forms session <3> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Cause:

The Actual cause of this error for my test instance is that openmotif package not installed along with pre-requisites for R12 in TEST instance server.

rpm -Uhv binutils-2.17.50.0.6-6.0.1.el5.x86_64.rpm
rpm -Uhv xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
rpm -Uhv openmotif21-2.1.30-11.EL5.i386.rpm

then after that i hav relinked the frmweb executable of forms server after shutting the apps services by giving the following commands

$cd $ADMIN_SCRIPTS_HOME

$adstpall.sh apps/

Then

$cd $ORACLE_HOME/forms/lib

$make -f ins_forms.mk install

Then restarted the services using adstrtal.sh apps/

Now there is no issue of form errors and was able to access the forms from my TEST instance.

 

Tags: , ,

R12 disable all users script

regulatory after clone, you asked to close “disable/ end date/ deactivate” application “end” users

use the following script

declare cursor x is
select user_name from apps.fnd_user where LOWER(user_name) Not IN ('list some users you don't want to close');
begin
for all_user in x loop
apps.fnd_user_pkg.DisableUser(all_user.user_name);
commit;
end loop;
End;
 

Tags: ,

httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

 

Review the HTTP log file. The error is very clear about the missing soft link. It would show this error:

<physical Path>/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
<physical Path>/10.1.3/Apache/Apache/bin/httpd: error while loading shared
libraries: libdb.so.2: cannot open shared object file: No such file or directory

cd $INST_TOP/logs/ora/10.1.3/opmn

vi HTTP_Server~1.log
--------
14/03/04 00:54:51 Start process
--------
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
--------
14/03/04 00:54:53 Start process
--------
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
--------
14/03/04 10:22:12 Start process

Case:

missing prerequisite step

Solution ::

To implement the solution, please execute the following steps:

1. Shut down all Oracle Application Services.

2. As the unix root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

3. Start up all Oracle Application Services.

 

Tags: , , , , ,