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 Home
 AFJVAPRG = $JDK1.3 Home/bin/java
 AF_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 : WFMAILER
Password : WFMAILER
INBOX folder
PROCESS folder
DISCARD folder


Test your IMAP account


telnet testorcl.com 143
Trying 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 -0800
1 login WFMAILER WFMAILER
1 OK LOGIN completed
1 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 flags
1 OK [READ-WRITE] SELECT completed
1 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 completed
1 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 flags
1 OK [READ-WRITE] SELECT completed
1 logout
* BYE testorcl.com IMAP4rev1 server terminating connection
1 OK LOGOUT completed
Connection closed by foreign host.

Verify SMTP server Configuration

telnet mailhost 25
MAIL FROM: wfmailer@orcl.com
RCPT TO: kapil@orcl.com
DATA
Subject: 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.

In the next Post i will discuss Workflow mailer troubleshooting.