Example Of Configuring Workflow Java Notification Mailer With Oracle Applications

Example Of Configuring Workflow Java Notification Mailer With Oracle Applications (Doc ID 249957.1)

Applies to:

Oracle Workflow - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

The purpose of this note is to highlight the steps required to successfully configure the Oracle Workflow Java Notification Mailer.

Solution

The content of this note is directed at anyone who is configuring the Oracle Workflow Java Notification Mailer.  Each configuration step is validated during the configuration process to minimize the risk of errors later on.

This note should be used in conjunction with Note 231286.1 Configuring the Workflow Java-based Notification Mailer with Oracle Applications 11i.

The Oracle Workflow Java Notification Mailer is installed with patchset 11i.OWF.G - Patch 2728236. This patchset is included by default with Oracle Applications 11.5.9.

Pre-requisite Considerations:

• If one is applying patchset 11i.OWF.G, a mandatory step is to implement the new workflow java mailer.

• If one is configuring IMAP Server for Inbound Processing with Workflow Java Mailer, then one must have a unique IMAP4 compliant email account for the mailer.

• If one does not have an IMAP server and requires inbound notification transaction processing, then one cannot apply OWF.G as this functionality will no longer work as it has been obsoleted.

• If one does not require inbound notification processing, one can now configure the java mailer without an IMAP account see Note 268274.1 How To Configure The Workflow Java Mailer Without An IMAP Account (Assumes No Inbound Processing).

• The new java based workflow mailer uses SMTP (port25) for outbound transactions, so client software is not required. The Workflow mailer makes a TCP/IP connection to the SMTP server on port 25 and issues the SMTP commands required to send the email.

Example Of Configuring the Workflow Java Notification Mailer

1. Setup an IMAP email user (e.g wfmailer) with a mailbox.

2. Configure an IMAP compliant email application to be able to connect to the account

Note: The IMAP email account MUST be able to receive emails before continuing to step 3
If you need help configuring IMAP4, please visit the URL http://imap.org

3. Connect an email client to the IMAP4 account and synchronize the IMAP folders.

4. Create the PROCESSED AND DISCARD folders from the EMAIL application (e.g. MS Outlook Express)

Note: this step can be also be performed from the IMAP4 server:
a) 'Edit' the mailbox for the wfmailer user
b) 'Add' the PROCESSED AND DISCARD folders.

5. From the Concurrent processing tier, issue the command 'ping SERVERNAME'

Note 1: if there is no response from this command then there could be a network config issue.
In this case, add the following entry to your hosts file:

(Replace the ipaddress, servername and domain with their actual values)

ipaddress    SERVERNAME.DOMAIN     SERVERNAME

Note 2: please ensure you are able to ping the server successfully before proceeding to the next step.

6. Validate the SMTP server from the Concurrent processing tier, by using the command 'telnet SERVERNAME 25'.

'telnet SERVERNAME 25' should return something similar to:
220 otdasol4.us.oracle.com ESMTP Sendmail 8.11.6+Sun/8.11.6; Thu, 2 Oct 2003 02:45:57 -0600 (MDT)

Note 1: verify that the response includes a reference to 'SMTP'

Note 2: please ensure that the email account is able to send emails successfully via SMTP before
continuing to step 7.

7. Add the email address to Oracle Applications:

a) Log in to Oracle Applications as System Administrator and navigate to SECURITY>>USER>>DEFINE.

b) Query a user and add a valid email address.

8. Perform the required Workflow Mailer setup steps in OAM.  Please log in to OAM to edit WF Mailer configuration details

a) Please follow these example details for your configuration values in page 3.

Inbound EMail Account (from step 1)
* Protocol  IMAP
* Server Name =      SERVNAME.DOMAIN
* Username    = wfmailer
* Password    = ******
* Inbox Folder= INBOX  
* Test Address=

Outbound EMail Account (from step 6)
* Protocol  SMTP
* Server Name = SERVNAME.DOMAIN

* Processed Folder   = PROCESS (from step 3)
* Discard Folder     = DISCARD

b) Select 'Next' in the OAM edit screen.

At this point, validation checking is performed for the above settings before progress to page 4.
Any errors are highlighted in red.

c) Select 'Finish' twice

9. Test the Mailer

a) Select the Workflow Notification Mailer hyperlink.

b) Select 'Test Mailer' button.

c) Enter the username that was added at step 7.

10. If no email is received then follow the troubleshooting steps below.

Troubleshooting steps:

If no email is received when testing the Mailer, please try the following steps:

1. Please check the status of the Java Mailer:

a) Navigate to the OAM Home Page =>Workflow Manager => Service Components.

b) Check the status of the java mailer.

2. If the Java Mailer is not working, check the java mailer log file for related errors.
    Select the 'Workflow Notification Mailer' hyperlink => View Log

3. If the Java Mailer is not running, if any errors occur in the log file, please review the following troubleshooting notes:

Note 242941.1 How To Troubleshoot Workfow Java Notification Mailer In 11.5.9 and 11i.OWF.G

Note 260393.1 Java Mailer and Other Current Workflow 11.5.9/OWF.G Issues In Apps 11i

4. If no error is occurring, apply Patch 3203709 (just a c driver 49k.) This patch updates the
error messaging code for Workflow, so that more meaningful error messages return when problems arise.

5. Try enabling debugging:

a) Login to OAM
b) Navigate Workflow Manager =>Service Components =>Workflow Mailer Service =>Edit
c) open the Edit service parameters screen
d) set parameter SVC_CONTAINER_LOG_LEVEL=1   (1 is the highest 5 is the lowest)
e) select 'OK' to save the change
f) restart the mailer
g) reproduce the problem and review the logfile again

 

Workflow Information Center, Diagnostics, & Community

• Please reference the Workflow Product Information Center Document for Top Workflow Resources: Document 1320509.1

• For additional help, please refer to one of the following documents on diagnostics to address current needs. Providing diagnostic output on an issue for support when logging a service request is very helpful.
  
  Document 179661.1 for 11i or Document 421245.1 for Rel 12.x

• Collaborate with industry peers at the Core Workflow community.
• Please see Document 1186338.1 for recorded Workflow Webcasts.

 

Related Documents

Note 231286.1 Configuring the Workflow Java-based Notification Mailer with Oracle Applications 11i
Note 249961.1 What is required to run the new Workflow Java Mailer