500 Internal Server Error

In R12, when attempting to log in to EBS using HTTP://HOST.DOMAIN:PORT/
,the following error occurs.

ERROR500 Internal Server Errorjava.lang.NoClassDefFoundError atoracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126) atoracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170) at com.evermind[OracleContainers for J2EE 10g (10.1.3.0.0)

The issue is caused by the following setup: Incorrect set-up of the Distributed Caching, port:12377 is not available.

To implement the solution, please execute the following steps:

Solution 1:
1. You can disable the use of "Distributed JVM cache" by disabling LONG_RUNNING_JVM- set oc4j.properties: ==> LONG_RUNNING_JVM= to "false"

Note: not usually recommended

Solution 2:

1. Assign an available port for "Distributed JVM cache" by using the following steps
a) Set the correct port in your Context File -> parameter "s_java_object_cache_port"
2. Run Autoconfig on all Middle Tiers
3. Make sure your System Profile "JTF_DIST_CACHE_PORT" has the same port specified
4. Retest the issue.

How To Change The Standard Oracle Logo in R12 Forms?

1.- Open the file $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg

2.- Check the baseHTML and baseHTMLJInitiator variables inside the file. They point to theappsbase.htm file used in the forms (ussually is the same file for both)

3.- Open the file(s) pointed by those variables

4.- Go to the "// Forms Applet Parameters" section related to the client browser you use

5.- Check if there's a line that references to "PARAM name=logo". An example of how that line mustbe for Internet Explorer is:

IEhtml += '<' + 'PARAM name=logo value="' + xlogo + '">';
add or change that line according to what you have and what you want.

6.- Go to the "// Oracle Applications default Parameters" section in the same file

7.- Add or edit the definition of xlogo variable. It must be:var xlogo = "%logo%"

8.- Save the file(s)

9.- Locate the variable "logo" in $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg file at the ";Forms Server Information: servlet, port, machine name and domain" section. If it's not there thenyou can create the line. The variable must point to the .gif file you want to add on the forms.You must put the .gif file in
$OA_JAVA/oracle/apps/media
and $OA_JAVA paths and point the "logo"variable to your file with:logo=

10.- Bounce Forms and Apache servers for the changes to take effect11.- Open a new browser window on your client desktop and test the forms.

How to create a FRD (Forms Runtime Diagnostic) Log in EBusiness Suite R12 using Forms 10g

To create a FRD (Forms Runtime Diagnostic) Log in EBusiness Suite R12 using Forms 10g, perform the following steps:
1. Make the USER value for profile option 'ICX: Forms Launcher' the same as the SITE value
2. Append the USER value of ICX: Forms Launcher with the "?record=collect" (without the quotes)
e.g. update the value of ICX: Forms Launcher for the user to be"http://testserver.oracle.com:8005/forms/frmservlet?record=collect"
3. Save this change at the USER level.
4. Logout and Log back in again, for this profile to take effect. When you login again, a message box pops up, which alerts you that Diagnostics is enabled.
5. Go to Help->About Oracle Applications, go to the section

----------------------------------------
Forms Server Environment Variables
----------------------------------------

note the value of FORMS_TRACE_DIR. If it is empty,This value can be defined by the following steps:

- Bring down the Forms server
- Open the context ile and define the "s_forms_trace_dir" context variable in the middle tier (Forms tier) to point to a valid directory.
- Run Autoconfig- bring back up the Forms sever.

6. Reproduce the Forms-Issue, which you are trying to diagnose.
7. Go to the directory specified in the FORMS_TRACE_DIR variable. List the latest files. The FRD Log is the one with the string "collect" in its name.

R12 OA framework: common questions

1)How to enable log in R12?

Since there is no Jserv as in 11i, there is no more dependency on jserv.properties file for enabling of log.Here are the details how to enable log on R12:

In R12,Goto $ORA_CONFIG_HOME/10.1.3/opmn/conftake the backup of opmn.xmledit opmn.xml for data id="java-options" and add the following:-DAFLOG_ENABLED=true -DAFLOG_LEVEL=statement-DAFLOG_MODULE=fnd%-DAFLOG_FILENAME=/tmp/aflog.txt -Djbo.debugoutput=console

The log message should get written in,

$INST_TOP/logs/ora/10.1.3/opmn/oacore_default_group_1/oacorestd.out

2)How to add custom classpath in OC4J server classpath ?

Add an entry in,
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/orion-application.xml

prepending the existing library path.


4)Steps for Manual compilation of jsp in R12.

> cd $FND_TOP/patch/115/bin
> ojspCompile.pl --compile -s hello.jsp

5)DBC file location in R12:

$INST_TOP/appl/fnd/12.0.0/secure

6)Bouncing OC4J server, for OAF to pick latest class and xml files.

In R12, there are two scripts which need to run to bounce the HTTP server and make OC4J container pick latest class files instead of one as in 11i, we only need to run adapcctl.sh shell script to bounce Apache Jserv.
Since in R12 Jserv is replaces by OC4J container, we need to run two scripts:

1)Script which is responsible for bouncing Oracle HTTP Server (powered by Apache).(adapcctl.sh)

2)Script which responsible for bouncing OC4J container (adoacorectl.sh)
So basically, here is the sequence of steps you need to do :
1)adapcctl.sh stop
2)adoacorectl.sh stop
3)adapcctl.sh start
4)adoacorectl.sh start

All these scripts are in $ADMIN_SCRIPTS_HOME

Rapidwiz error while installing Applications Release12

When attempting to install Oracle Applications Release 12, the following error occurs during rapidwiz post-installation checks


ERROR LOGIN PAGE
-------------------------
checking URL = http://.:8000/OA_HTML/AppsLogin
RW-50016: Error: - {0} was not created:

Processing DriverFile = /stage/StageR12/startCD/Disk1/rapidwiz/template/adriapps.drv
Executing service control script:
/oracle/R12/inst/apps/TWO_oraclesvr05/admin/scripts/adoacorectl.sh start
ERROR : Timed out( 100000 ): Interrupted Exception
You are running adoacorectl.sh version 120.11


The issue is caused by a wrong setup in /etc/hosts file. The local host and server are setup in the same line in the hosts file.

To resolve this, backup the hosts file and make the following change.

127.0.0.1 localhost
'IP' 'host.domain' 'host'

Blank login page in Oracle applications Release 12

When the apps URL is entered in the web browser, A blank login page is returned. The application.log under $INST_TOP//logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1 shows the following error message similar to the one below.
====================================================================================
javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException:
Missing class: _AppsLocalLogin
Dependent class: oracle.jsp.runtimev2.JspPageInfo Loader: oc4j:10.1.3 Code-Source: /u02/oracle/RE12/apps/tech_st/10.1.3/j2ee/home/lib/ojsp.jar Configuration: in META-INF/boot.xml in /u02/oracle/RE12/apps/tech_st/10.1.3/j2ee/home/oc4j.jar
====================================================================================
To solve the issue, Recompile the JSP’s by issuing the following command the the linux prompt.
perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 20

Enable Enterprise Manager on the Oracle E-Business Suite Release 12

- Keep the database and listener running. It is not necessary that any other Application services to be running for this process to complete.

- As the owner of the 10gR2 ORACLE_HOME, run the following command to create the Enterprise Manager repository:

$ emca -config dbcontrol db -repos create

When the command is run, EMCA prompts for the following values

Database SID: OBAIND
Listener port number: 1617
Password for SYS user: xxxxxxxxxx
Password for DBSNMP user: xxxxxxxxxx
Password for SYSMAN user: xxxxxxxxxx
Email address for notifications (optional):Outgoing Mail (SMTP) server for notifications (optional):
- Enter the values

- EMCA shows a summary of the entered values

—————————————————————–
You have specified the following settings

Database ORACLE_HOME ……………. /u11/oracle/OBAIND/db/tech_st/10.2.0 Database hostname ……………. xxxxxxxxx.newgen.com
Listener port number ……………. 1617
Database SID ……………. OBAIND
Email address for notifications ……………Outgoing Mail (SMTP) server for notifications —————————————————————–

Do you wish to continue? [yes(Y)/no(N)]: Y

- Type ‘Y” to start the configuration.
The configuration will take anywhere between 10 to an hour depending on the machine configuration and database size.

Once it gets completes Enterprise manager can be accessed from the URL

http://localhost.domain.com:1158/em

Configuring R12 Workflow Mailer’s SMTP server to send mails to all domains through telnet

1. Unable to send to the mails for any domain except the client’s domain

2. When looked into the log file FNDCPGSC***.txt ($APPLCSF/$APPLLOG), found out the following error,

Oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[["ADDRESS.DOMAIN.COM.AMERICAN" ]]} -> javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 Unable to relay
oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:SendFailedException -> [["ADDRESS@DOMAIN.COM.AMERICAN" ]] javax.mail.SendFailedException: Invalid Addresses; nested exception is: class Javax.mail.SendFailedException: 550 5.7.1 Unable to relay

3. Confirmed the same by checking the wf_notifcations table and the mails sent to the id’s outside the clients domain failed with status “FAILED” (Testes Purchase Orders to Suppliers, Workflow Test Mail, Forgot Your Password Functionality)

4. Tried to login the user through telnet and got the same error and confirmed that this is something to do with SMTP server
[applprod@perp log]$ telnet webmail.domain.in 25
Trying 192.168.1.7...
Connected to webmail.domain.in (192.168.1.7).
Escape character is '^]'.
220 EXCHMAILSERVER1.domain.in Microsoft ESMTP MAIL Service ready at Fri, 2 Jan 2009 15:36:26 +0530
HELO
250 EXCHMAILSERVER1.domain.in Hello [192.168.1.40]
MAIL FROM: wfmailer@domain.in
250 2.1.0 Sender OK
RCPT TO: address@domain.com
550 5.7.1 Unable to relay

5. The issue has been given in the notes # 374804.1, 304582.1 and 753845.1, requested the mail administrator to set the SMTP mail server to allow relaying, that is sending mail to an outside domain from that server (192.168.1.40)

6. Restarted the “Workflow Notification Mailer” through Oracle Applications Manager

7. Once done checked the notifications from purchase orders to supplier and Forgot Your Password link with other domain’s mail-id started working fine

Creating FRD (Forms Runtime Diagnostic) log in Oracle Applications R12

Forms Runtime Diagnostic (FRD) is a runtime event-based logging system intended to aid in the debugging of Forms applications. FRD is enabled at runtime on a user by user basis. When a form is run with FRD enabled, a combination of external user-application interactions and internal Forms processing events are written in chronological order to a log on the file system.

The following steps shows how to create a FRD (Forms Runtime Diagnostic) Log in EBusiness Suite R12 using Forms 10g

1. Make the USER value for profile option 'ICX: Forms Launcher' the same as the SITE value

e.g. copy value of ICX: Forms Launcher for the SITE

"http://testserver.oracle.com:8005/forms/frmservlet"

to be the value for the USER.

2. Append the USER value of ICX: Forms Launcher with the "?record=collect" (without the quotes)

e.g. update the value of ICX: Forms Launcher for the user to be

"http://testserver.oracle.com:8005/forms/frmservlet?record=collect"

3. Save this change at the USER level.

4. Logout and Log back in again, for this profile to take effect. When you login again, a message box pops up, which alerts you that Diagnostics is enabled.

5. Go to Help->About Oracle Applications, go to the section

----------------------------------------

Forms Server Environment Variables

----------------------------------------

There you should see a FORMS_TRACE_DIR. Note the value of this variable.

P.S: If you find that the FORMS_TRACE_DIR is not defined, then ask your sysadmin to bring down the forms server, define this environment variable in the middle tier (form tier) to point to a valid directory, and then bring the forms-sever back up .

6. Reproduce the Forms-Issue, which you are trying to diagnose.

7. Go to the directory specified in the FORMS_TRACE_DIR variable. List the latest files. The FRD Log should be the one with the string "collect" in its name.