How to Configure Oracle Java Workflow Notification Mailer in Oracle apps 11i

Use following simple steps to configure Oracle Java Workflow Notification mailer in Oracle applications 11i

• Run $FND_TOP/sql/wfver.sql and review the output • Check for invalid objects• Generic Service Management (GSM) should be enabled in the system. Workflow mailer program runs as a service with in GSM.• Verify if GSM DEBUG service run successfully without exceptions in the log from OAM.• JDK1.3 or higher must be installed and configured on Concurrent processing node.

JDK1.3 Home/bin/java -version

• Verify following variables for JDK version

AF_JRE_TOP = $JDK1.3 HomeAFJVAPRG = $JDK1.3 Home/bin/javaAF_CLASSPATH = $JDK1.3 Home/lib/dt.jar:$JDK1.3 Home/lib/tools.jar:$JDK1.3 Home/jre/lib/rt.jar:$JDK1.3 Home/jre/lib/i18.jar: $JAVA_TOP/appsborg2.zip:$ORACLE HOME

8.0.6/forms60/java:$JAVA_TOP

• Verify if JMS libraries exist in AF_CLASSPATH.

grep jar $APPL_TOP/admin/adjborg2.txt

Sample output should look like:

$ORACLE HOME 8.0.6/owm/jlib/jssl-1_1.jar$ORACLE HOME 8.0.6/owm/jlib/javax-ssl-1_1.jar$iAS HOME/rdbms/jlib/aqapi.jar$iAS HOME/rdbms/jlib/jmscommon.jar$iAS HOME/Apache/xsu/xsu12.jar$iAS HOME/Apache/xsu/oraclexmlsql.jar$iAS HOME/rdbms/jlib/xsu12.jar$iAS HOME/lib/http_client.jar

If the output is 0 (zero), it means that appsborg2.zip does not contain the JMS classes

• Create a IMAP Account in Lotus Notes with following information

User ID : WFMAILERPassword : WFMAILER

INBOX folderPROCESS folderDISCARD folder

Test your IMAP account

telnet testorcl.com 143Trying 112.126.180.67...Connected to testorcl.com.Escape character is '^]'.* OK Domino IMAP4 Server Release 5.0.11 ready Sun, 23 Nov 2003 10:26:49 -08001 login WFMAILER WFMAILER1 OK LOGIN completed1 select "INBOX"* 23 EXISTS* 0 RECENT* OK [UIDVALIDITY 0] UIDs valid* FLAGS (\Flagged \Seen \Answered \Deleted \Draft)* OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft)] Permanent flags1 OK [READ-WRITE] SELECT completed1 select "DISCARD"* 54 EXISTS* 0 RECENT* OK [UIDVALIDITY 6] UIDs valid* FLAGS (\Flagged \Seen \Answered \Deleted \Draft)* OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft)] Permanent flags

1 OK [READ-WRITE] SELECT completed1 select "PROCESSED"* 58 EXISTS* 0 RECENT* OK [UIDVALIDITY 4] UIDs valid* FLAGS (\Flagged \Seen \Answered \Deleted \Draft)* OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft)] Permanent flags1 OK [READ-WRITE] SELECT completed1 logout* BYE testorcl.com IMAP4rev1 server terminating connection1 OK LOGOUT completedConnection closed by foreign host.

Verify SMTP server Configuration

telnet mailhost 25MAIL FROM: wfmailer@orcl.comRCPT TO: kapil@orcl.comDATASubject: Test message from workflow (mailhost)Hello Kapil.Verify that kapil@orcl.com receives an email from wfmailer@orcl.com . If not, then the SMTP server is not configured properly.

Configure Workflow Notification Mailer using

OAM

Log on to Oracle Application manager

Navigate to Workflow manager from pull down menu

Click the Notification Mailer status icon to navigate to the Service Components page for notification mailers

In the Service Components page, select the Workflow Notification Mailer service component and click the Edit button

Leave all settings as a default in the first page

Click on the next button to go to second step. If you are using inbound mails then define Inbound Thread Count more than 0 or else 0. For Outbound Mail define Outbound Thread Count to 1

In the Inbound eMail Account region, enter the inbound mail server and the username and password for the IMAP e-mail account. Please remember userid and password is case sensitive. In the Outbound eMail Account region, enter the outbound mail server that the Workflow Notification Mailer will use.

In the Send region of the Edit Notification Mailer: Message Generation page, enter the address of the reply-to e-mail account that receives incoming messages and the base URL that identifies the HTML web agent that handles HTML notification

responses.

All other configuration parameters for the Workflow Notification Mailer are set to default values.After you finish setting the configuration parameters, go to service component page and click on Workflow mailer Service.

In the Service Instances for Generic Service Component Container page select start all from pull down menu and click on go button.

Go to Service component page once again and verify that the status of the Workflow Notification Mailer service component is now running.