Workflow Notification Mailer Configuration using Autoconfig for Outbound Processing
I remember, 30th July 2006 is the first day Atul started blogging with his first post
http://becomeappsdba.blogspot.com/2006/07/how-2-become-oracle-apps-dba.html
In past 2 years, there is tremondous reponse from viewers from all over the world. I would like to congratulate and wish him all the best on this great occasion.
Today I want to post the Workflow Notification Mailer Configuration using Autoconfig for Outbound Processing in 11i. Oracle Workflow Notification Mailer is a Java Program, which is used to send e-mails and recive responses through e-mails for workflow notification system. Internally it is done through JavaMail API. If your workflow users want to get workflow notification mails, you need to configure workflow notification Mailer. Normally I have seen everybody configuring the same from Workflow Mailer Configuration Wizard using Oracle Application Manager. But Here I want to post simple procedure configuring the same using Autoconfig.
Note: If you are going to configure only one Workflow Notification Mailer and having smtp server running on default Port Number 25, then the following procedure is simple to configure. If it is not, then you have to configure Workflow Notification Mailer using Mailer Configuration Wizard using OAM.
If you configure through Mailer configuration wizard through OAM, Autoconfig overwrites its configuration. Because By default Autoconfig Context file contains smtp server name as Application Tier Hostname/Concurrent Manager Node Hostname. When you run autoconfig, it overwrites the smtp server hostname what you have configured through OAM with the value in Autoconfig Context File. I feel the following is the simple procedure to follow, which worked for me.(1) Take backup of existing Autoconfig Context Filelogin as APPLMGR User
$cd $APPL_TOP/admin
$cp <SID>_<hostname>.xml <SID>_<hostname>.xml.orig
(2) Edit the Autoconfig Context file with SMTP server name
$vi <SID>_<hostname>.xml
search for smtp and give smtp server details
s_smtphost ==> SMTP Server Host Name
s_smtpdomainname ==> SMTP Server Domain Name
Note: Above Same procedure can also be done by editing above context variables
in OAM > Site Map > System Configuration> Applications Autoconfig Context File
(3) Run the autoconfig
$cd $COMMON_TOP/admin/scripts/<SID>_<hostname>
$sh adautocfg.sh
(4) Bounce the Apache Service
$cd $COMMON_TOP/admin/scripts/<SID>_<hostname>
$sh adapcctl.sh stop apps/<apps password>
$sh adapcctl.sh start apps/<apps passwod>
(4) Start the following workflow Concurrent Managers
If the following Concurrent Managers are not activated or started before, activate and srart them
(a) Workflow Agent Listener Service
This is the seeded Workflow Notification Mailer Service component belongs to a container named Workflow Agent Listener Service
(b) Workflow Mailer Service
This is also seeded agent listener service component required for Workflow Mailer Processing
The above Services can be started using
(1) Using OAM > Site MAP > Wofkflow > Home > Service Components
or
(2) Using System Administrator Responsibility > Concurrent > Manager > Administer
That’s the procedure I did it and configured successfully workflow Notification Mailer.
Reference:
(1) Oracle Workflow Adminstrator’s Guide
http://download.oracle.com/docs/cd/B25284_01/current/acrobat/115wfag.pdf
(2) Oracle Workflow User’s Guide
http://download.oracle.com/docs/cd/B25284_01/current/acrobat/115wfug.pdf
(3) Note:313954.1 Autoconfig Overwriting The SMTP Server Name For The Java Mailer