Workflow Notification Mailer Setup in Oracle Apps R12/12i

On popular demand from readers, I am going to cover Workflow Notification Mailer in Oracle Applications R12/12i.
Workflow notification mailer setup in R12 is similar to 11i ( In both release 11i (OWF.H and higher in 11i) & R12 are Java Mailer)
* Previous version of Notification Mailer in 11i was based on C also called as C Mailer

Things to note
1. You use Oracle Application Manager (OAM) to configure Workflow Notification Mailer.
2. There are two kind of Notification (Outbound & Inbound) in Workflow Mailer
3. For Outbound Notification, CM (Concurrent Manager) node should be able to connect to SMTP (Simple Mail Transfer Protocol) server/relay.
4. For Inbound Notification (Optional), CM node should be able to connect to IMAP (Internet Message Access Protocol) Server.
5. Log file for Workflow Mailer Notification are at $APPLCSF/$APPLLOG/FNDC*.txt
6. Workflow Notification Mailer in background run as Concurrent Manager (Workflow Mailer Service, Workflow Agent Listener Service)
7. If you don’t wish to send mail notification to end user (from Dev/Test instance) then configure Test Address in configuration screen.


Step to configure Workflow Notification Mailer

1. Login to Apps R12 with System Administrator Reponsibility
2. under Workflow : Oracle Applications Manager click on Workflow Manager

workflow notification mailer

If this is first time you are configuring Workflow Notification Mailer in Oracle Apps R12/12i you will see Notification Mailers as unavailable as shown in screenshot

Click on Notification Mailers

Workflow Notification Mailer Setup in Oracle Apps R12/12i

In next screen (as shown below, click on Edit Button)

Workflow Notification Mailer Setup in Oracle Apps R12/12i

Here you have option to select Inbound notification setup or Just outgoing Notification Setup.

Workflow Notification Mailer Setup in Oracle Apps R12/12i

Provide SMTP Server Name (ensure that CM node should be able to connect to SMTP Server or SMTP Relay)

Workflow Notification Mailer Setup in Oracle Apps R12/12i

Uncheck Inbound Processing (from above screen), if you don’t wish to configure Inbound Notification Mailer.

If you wish to configure Inbound Notification as well then ensure IMAP Server should be configured with a valid user (create Inbox, Processed & Discard folder for this User)

Click on Apply button to finish configuration, at this stage Notification Mailer will test SMTP Server & IMAP Server connectivity.

For Advanced setup, click on Advanced at top right of configuration screen.
Metalink Notes for Notification Mailer
1. 453137.1 Oracle Workflow Best Practices Release 12 and Release 11i
2. 274764.1 Oracle Workflow Cartridge Workflow Java Mailer Setup Test
3. 433359.1 Tracking Workflow Notification Event Messages
4. 456921.1 Queries Related to Alert and Mailer Integration Post RUP4
5. 454706.1 How to Stop mails from Workflow Notification Mailer

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

73 comments
GOLD HILL FINANCIAL INVESTMENT PLC says April 14, 2008

I am a young company owner and i need a mailer to advertise my products.

Reply
Abu Umer Hafeez says June 19, 2008

Hi Atul

How to enbale OEM for Oracle11i?

Thanks

umair

Reply
Atul says June 19, 2008

Umair,
Here is link to all documentation required for OEM monitoring for 11i

Please note some of these documents are oracle intrenal and you may not be able to open them

393246.1 : Install & config of the Agent 1.2 for EM Grid Plug-In 10gR2 for Oracle Applications
394448.1 Title: Getting Started with the Application Management Pack for Oracle E-Business Suite (Releases 2.0 and 2.0.1)
273579.1 Title: Enterprise Manager Grid Control 10g (10.1.0) Frequently Asked Questions

412044.1 Application Management Pack for Oracle E-Business Suite Release 2.0 and 2.0.1 Troubleshooting Guide

https://metalink.oracle.com/metalink/plsql/docs/E12177_02.pdf (Oracle Application Management Pack for Oracle E-Business Suite – Installation Guide Part No E12177-02 )

https://metalink.oracle.com/metalink/plsql/docs/E12178_02.pdf (Oracle® Application Management Pack for Oracle
E-Business Suite – User’s Guide)

Reply
abhishek says June 26, 2008

Hi atul
I want to configure workflow purchage notification mailer.We would like to receive my Notifications into my Inbox. Please help me to configure/setup my Oracle workflow Notification Settings for the email server or clinet.
Please assist me to allow the Notifications to be sent to the Required emails automatically after the manager responds to the user’s request.My application version is 12.0.4.
Please explain :What we need to set for below Parameters
Outbound EMail Account (SMTP)
Server Name
Inbound EMail Account (SMTP)
Server Name
Inbound Processing
server Name
User name:
Password:
Reply to address:

Thanks
Abhishek

Reply
Atul says June 26, 2008

If you want inbound notification then put IMAP Server details or ignore them

Outbound (System to user)

SMTP (Simple Mail Transfer Protocol) Server or relay should already be configured
Outbound EMail Account (SMTP) – Any email ID which will be used to send mails to users
Server Name – SMTP Server IP/Servername which will be used to send mails to users

Fill this if you want inbound else disable inbound email notification (i.e. from user to system), you should already have IMAP (Internet Message Access Protocol) Server and user configured before this.

Inbound EMail Account (SMTP) – Any valid email account to which mails are delievered
Server Name – IMAP Server Name

Inbound Processing

User name: IMAP Server user name
Password: password you created while creating IMAP User

Reply to address: Address which user will see when he/she click on reply to button from email they receive

Reply
Lalit says June 27, 2008

Hi Atul

I had configured the workflow mailer but after 8 hrs all the concurrnet request are giving signal 11 error.This error is not comming in the test server.When i disabled the WFNM the production is working fine.

Can please tell me what is the poblem bhind this error and how can I get rid of this problem.

Regards
Lalit

Reply
Atul says June 27, 2008

Lalit, Signal 11 means not enough resource which can be because of memory, cpu, display or any other thing.

I never saw signal 11 because of notification mail but still check why signal 11 in CM log file and notification mailer log file to find root cause in $APPLCSF/log

Reply
Lalit says July 4, 2008

Hi Atul,

Thank you for your imediate response.
Can you please tell how can i resolve this signal11 error.
Please help me i am facing lot of problem due to this issue.

Regards,
Lalit

Reply
Pavan Kumar says August 2, 2008

Hi Atul,

Can u tell us how to find password in Apps R12. In 11i apps password is stored in wdbsvr.app file.
a) Is apps password stored in any file for R12
b) If it is stored in encrypted form, how do we retrieve it.

thanks in advance.
Pavan.

Reply
Prabhakar says August 18, 2008

Very good suggestions

Reply
Balakrishna says September 13, 2008

Hi Atul,

I have two questions.

1. We have R12 Oracle Apps and in order to configure workflow notifications mailer do we need to configure SMTP & IMAP Oracle server Box or we have to take the IP of SMTP & IMAP from sysadmins Incase if we have to configure can you please guide me how do we go about it ??

2. We want use Workflow notification mailer only for alert manager and not for other modules since we use a pl/sql package to send mail.

Regards

Balakrishna.

Reply
Atul says September 13, 2008

1. We have R12 Oracle Apps and in order to configure workflow notifications mailer do we need to configure SMTP & IMAP Oracle server Box or we have to take the IP of SMTP & IMAP from sysadmins Incase if we have to configure can you please guide me how do we go about it ??

SMTP server is required for outgoing mails only
and
IMAP server is required for only incoming mails

If you only want outgoing mails (for alerts) then you don’t need IMAP server at all (In workflow notification mailer configuration screen under “Inbound EMail Account (IMAP)” don’t select check box “Inbound Processing”. By doing this notification mailer will not do any validation for IMAP server and incoming mail processing with not activate.
For outgoing mails, You don’t need to configure SMTP server. Use any existing SMTP server (or SMTP relay server ) (only requirement is that Concurrent Manager should be able to ping SMTP server and port 25 (SMTP server port) should be open between CM node & SMTP server)

2. We want use Workflow notification mailer only for alert manager and not for other modules since we use a pl/sql package to send mail.

Alert manager started using Workflow Notification mailer to send notification from ATG Rollup 4 (check with oracle support/ATG team to confirm)

Reply
Qamar says November 24, 2008

Hi
I want to install “Oracle Workflow Client for Oracle Applications Release 12 for Windows”.
Is there any patch or any other download link?
Please give me.

Kind Regards
Qamar Zahoor
+923218776877

Reply
rajesh says November 26, 2008

Hi Atul,

I want to include the url of workflow notification in the email notification so that the user can directly go to the notification page from email notificaiton in rel 12.

How to acheive this?

Thanks
rajesh

Reply
hakim says November 28, 2008

Hi

I have configured the workflow mailer(11.5.10.2) but the notification test fail with the following msg error :
javax.mail.MessagingException: 501 Sender domain must exist

Any help?
Thanks in advance.
Hakim

Reply
Atul Kumar says November 28, 2008

Hakim,
Check your source (from) email address and see if you can send mails from o.s. commands from CM node.

Do a quick test like

telnet 25
EHLO
MAIL FROM: testmail@testdomain.com
RCPT TO: your_target_mail@your_target_domain
DATA
Subject:

Type_some_dummy_mail_body_here
. (Type Dot to finish entering data)
quit

Reply
hakim says November 30, 2008

Hi,

Thank you for your immediate response.
Find below the result of the test :
——————————————–
EHLO bones.otalgerie.com
MAIL FROM: abdelkrim.kaci@otalgerie.com
RCPT TO: abdelkrim.kaci@otalgerie.com
Subject:
hakimmmmmmmmmmmmmm
.
quit
503 bones.otalgerie.com Duplicate HELO/EHLO
501 Sender domain must exist
503 Need MAIL before RCPT
——————————————–

I count on your help.
Regards

Reply
Atul Kumar says November 30, 2008

Issue is with SMTP server ,
Are you using exchange , Novel groupwise or any other SMTP server ?

Contact person/team who maintains SMTP server

Reply
hakim says November 30, 2008

Hi,

I’m using the smtp of HP-UX server (our Oracle Applications Server)

Regards

Reply
Hakim says December 2, 2008

Hi,

I want to learn about the significance of the below parameters :

1-Inbound Thread Count
2-Outbound Thread Count

What will be the impact if I change the value of these two parameters

Thanks in advance for your help

Reply
Atul Kumar says December 2, 2008

Setting Inbound to 0 means notification from User to Workflow Notification Mailer will not work.

Inbound to 1 means Inbound email notification is enabled.

1 means enabled
0 means disabled

Outbound is from Workflow Notification Mailer to User , 1 means enabled and 0 means disabled

Reply
Hakim says December 2, 2008

Hi,

Thanks a lot.

In “Schedule Event” step I found the below comments:
———————————————-
Enter parameters, separated by a colon (:), in the following format: internal_parameter_name=parameter_value (for example: PROCESSOR_IN_THREAD_COUNT=3:PROCESSOR_OUT_THREAD_COUNT=6).
——————————————

what will be the impact of the use of these parameters on the execution of the event

Thanks for your help
Best Ragards

Reply
Atul Kumar says December 2, 2008

Which documentation you are following for
“Schedule Event” ?

Reply
Hakim says December 2, 2008

It is mentioned in “Schedule Event” step in Workflow Manager>Workflow Mailer>Edit.

Reply
Pokhraj says December 26, 2008

Hi Atul,

I am new in Oracle Apps.Is there is any document for maintaing and troubleshooting workflow mailer?

Thanx in advance..
Pokhraj

Reply
ebisdba says May 27, 2009

on particular user is getting PO approval intimation twice. this is a workflow generated mails. please suggest or give some action plan.

Reply
alihaddawi says June 3, 2009

Dears Atul / Guyes

on ERP 12i we have configured notification mailer succussfully via IMAP and working fine by sending notifications to the users, after sometime the notificatin cannot connect to Exchange Server by saying as below :
Inbound EMail Account (IMAP)
* Server Name= Our Exchange Server
“Unable to make a network connection.”

SSL is enabled

we tested from other server by typing
telnet exchange server 993
connected
but from application server
$ telnet Exchnage IP 993
Trying Exchnage IP…
telnet: Unable to connect to remote host: Connection refused

anyone can help please ?

Reply
Atul Kumar says June 3, 2009

Alihaddawi, Exchange Server is rejecting connection from Workflow (Concurrent Manager).

Check if there is any firewall between CM node and Exchange Server or ask exchange team to check why exchange server is rejecting connections.

Reply
alihaddawi says June 4, 2009

Dear Atul / guys

thanks for your reply, the Exchange Team has indication that there is some other system in the same subnet range is connected both on:

172.30.50.*

and also from other subnet from windows we could connected to the exchange Server successfully.
So the Exchange Team have their prove.

I do appreciate if someone has an idea.

Alihaddawi

Reply
Atul Kumar says June 4, 2009

@Alihaddawi,
Other option is to check firewall between CM & Exchange

Reply
alihaddawi says June 4, 2009

Thanks again,

Since we have other server in the same subnet as dbTier can telnet via 993 port successfully than means there is no Firewall to block it from accessing exchange server.

We have two tiers Scenario of our Oracle Apps.

dbTier responses to telnet exchange id 993

appsTier doesn’t response to telnet exchange id 993

I feel we need Unix Admin has good experience to help ..

BR,

Reply
srikanth says June 5, 2009

hi atul;
i have setup notification mailer in R12 and now i want to send mail through alert using notification mailer instead using unix send mail option.when i am trying send mail through periodic alert by giving different mail id from that of test override mail address alert is getting completed sucessfully but i am not recieving messages.I have checked notification mailer and recieving messages to test override mail address.So kindly reply at earliest as it is very urgent.

Reply
satheesh says July 5, 2009

Hi All/atul,

I want to prepare sheel script for monitoring workflow mails if it is struck in the Inbox.Please advise me………..

Reply
nikhil says February 15, 2010

Hi Atul,

I need one help. I have installed R12.0.4 at my laptop on OS server 2003(32bits). I have to learn workflow so I have installed client(workflow builder). Can I configure workflow mailer in R12 as I m not using internet. I just want to do this for testing purpose only so I could find mailing details in table itlself or send notification to User in R12 instance…to achive this do I require to setup workflow Notification mailer ? if not there what r things I require to do ?

Thanks for help. Waiting ur promp reply!!

Nikhil

Reply
Atul Kumar says February 15, 2010

@ Nikhil,
If you want to send notifications in user accounts and would like to see those notifications in email server then you need to configure SMTP server (or use existing SMTP server – your CM should be able to connect to SMTP server) and then use configuration notification mailer screen in Oracle Application Manager.

Reply
nikhil says February 17, 2010

Hi Atul,

Many Many thanks for quick response :-)

I m not DBA so I do not know how to configure SMTP server(for recieving notification to user account in R12). I provide you details of my machine so you can help how to do that…

I log in R12 from http://sumit.ced.com:8003/

I m using following details in host file of
C:\WINDOWS\system32\drivers\etc

127.0.0.1 localhost
127.0.0.1 sumit.ced.com

Please let me know if you need any missing information.

Thanks always :-)
Nikhil.
nikhil.burbure@gmail.com

Reply
Atul Kumar says February 17, 2010

@ Nikhil

For mail server (SMTP) server on windows, search on google about free SMTP/mail server for windows and then install.

Then configure mail client like outlook express or thunderbird to connect to mail (smtp) server on local machine.
Mail server usually runs on port 25 .

Once you can send and receive mail to your local account (local smtp server) thwen login to OAM (Oracle Application Manager) and configure Workflow Notification Mailer as shown in this post.

Reply
farhan says February 23, 2010

Hi Atul,

Need help in WF java mailer configuration for SMTP with authentication.
In detail for outbound SMTP to configured, but this SMTP requires authentication to sendmail and 11i/R12 does not have this provision to provided or to enter username/password for SMTP.
note id=564361.1
BUG:5556540

How to resolve this as security guys will not allow this w/o authentication.

Waiting for your reply ..

Regards
Farhan

Reply
Syed Kashan says April 19, 2010

can anybody here tell me that how could i configure Reminder of workflow notofcation so that incase of any pending again an automatic reminder to this notification could be generated.

Reply
Sanjeev Nanda says September 23, 2010

Hi Atul,

I need one help
How to check that CM node is able to connect to SMTP Server .

How to create configured with a valid user IMAP Server.

Regards
Sanjeev

Reply
Sanjeev Nanda says September 23, 2010

Hi Atul,

As per you1.
For Outbound Notification, CM (Concurrent Manager) node should be able to connect to SMTP (Simple Mail Transfer Protocol) server/relay.
2.For Inbound Notification (Optional), CM node should be able to connect to IMAP (Internet Message Access Protocol) Server.
For CM node need to connect SMTP/IMAP server what confu setup need to be done.
Regards
Sanjeev

Reply
Atul Kumar says September 23, 2010

@ Sanjeev,

Q1. How to check that CM node is able to connect to SMTP Server ?

From CM node “telnet SMTPServerName SMTPServerPort” (Port for SMTP server is usually 25)

Q2. For CM node need to connect SMTP/IMAP server what confu setup need to be done.

Go to Notification Mailer Setting from Oracle application Manager and define SMTP/IMAP server settings .

Reply
rr1987 says September 27, 2010

Hi Atul,

I’ve do the setup as you mentioned. Now the status of Workflow Notification Mailer is running, but when I Test Mailer to send message to my email, I didn’t get the message on my email

Reply
Atul Kumar says September 27, 2010

@rr1987,
Check under Logs on CM Node at $APPLCSF/$APPLLOG/FNDC*.txt to find root cause of issue.

Reply
oracle_solutions says October 8, 2010

We want the from address of particular notifications to be different from the general workflow mailer account. is this achievable ?. If yes, how please

Reply
sanjeev kumar nanda says October 8, 2010

Hi Atul,

How to test IMAP server what we have define in Oracle application Manager is correct.

Regards
Sanjeev

Reply
Muthu says October 13, 2010

Hello Atul,

Just a quick question. May I know which table stores the details reg. the Inbound and outbound email account (such as the inbound server name, username, protocol etc.) ?

Thanks
Muthu

Reply
mnasr98@gmail.com says February 19, 2011

Hi,

how can i change from address for all outbound emails.

Regards,

Reply
akreddy says February 22, 2011

How enable smtp in linux

Reply
Atul Kumar says February 23, 2011

@ akreddy

To configure SMTP server on Linux use this link

http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch21_:_Configuring_Linux_Mail_Servers

Reply
santu says February 27, 2011

Hello

I am using R12(12.1.1) Application ,i want to configure IMAP server on my application.

For this its required separate IMAP server ? or we can configure in SMPT

We have already configure SMPT for outbound and wrking fine..

Please suggest me..Thanx Santu..

Reply
metisunitha says May 5, 2011

Hi,
We are trying to show output of the concurrent request in a notification in R12.
We are using htp.meta to redirect the URL.
This is working in 11i but not in R12.
Could you please help us in this regard.

Thanks in advance

Reply
Nile says June 27, 2011

Hi,

We want to configure oracle notification mailer on R12(Linux Server).
Its kind of approval notification,the user should recieve email through which he can Approve/Reject the request from mail itself is this possible?

Reply
Atul Kumar says June 27, 2011

@ Nile,
Yes this is possible .

Reply
Nile says June 27, 2011

What are the steps to achieve this on linux server.?
Can you provide the same for me.

Thanks a Lot.

Reply
Nile says July 1, 2011

What are the steps to achieve this on linux server.?
Can you provide the same for me.

Reply
sreedhar says July 31, 2011

Hello All,

I am new to Oracle Apps and learning a lot reading posts on OnlineAppsDBA.com.

Per the blogs:

SMTP server is required for outgoing mails only
and
IMAP server is required for only incoming mails

We have a requirement to send workflow & email notifications to PO buyers & approvers (level-1 and level-2 approvers).

Please advise, if I need to perform any configuration in Purchasing Module in Oracle R12.

thanks.

Reply
Paul says October 3, 2011

How do I stop email from parent source. The email will not open or make the commection and the unsubscribe button does not connect either,
Thanks,
Paul

Reply
Shreyas says October 31, 2011

I am getting Performing alert “TEST_ALR” (ROUTINE=alepaa) (FILE=alr/lib/alepea.c) (LINE=1065)
Connecting to “APPS (101)” (ROUTINE=alepaa) (FILE=alr/lib/alepea.c) (LINE=1128)
Performing action set “TEST_ALR_AS” (ROUTINE=alepea) (FILE=alr/lib/alepea.c) (LINE=277)
error and so not able to receive any email notifications as well.

What should be done on this.

Reply
Luciana says June 15, 2012

Hi, I need help. I requested a password reset and I did it before it expires, however I keep getting notifications to keep reseting it…. what should I do?

Reply
stall3 says May 10, 2013

Hi –

Is there a script to check the workflow mailer services from unix and bounce them? Sometimes the mailer says it is working fine, but it is not. Restarting the services seems to wake them up.

Thank-you,
S3

Reply
Hemanth says March 14, 2014

Hi ATUl,
we are facing one issue as some buyers or emps notification preference is suddenly automatically disabling.can you pls reply back what could be the reasons for this.

Thanks in Advance!!!!

Reply
Nalini says June 3, 2014

HI,

My client requirement is to send the notification and the email alert to be in different format that is content of the message is different. Please le tme know if this is possible in oracle workflow. Please update me asap since it is very urgent requirement.

Thanks.

Nalini

Reply
Delio says June 24, 2014

Hi, we are having an issue, we have R12.1.3 and a Microsoft exchange server 2007, CM node is in list to allow Relay in mail server, when we try to do:

EHLO xxxx
MAIL FROM: xxxxx
RCPT TO: xxxx

we can do success telnet in port 25, ehlo ok, mail from ok but when we type an external domain in RCPT we get error of “Unable to relay”

Can you pleas advice what else to check please?

Thanks

Reply
mkranthi says October 8, 2014

Hi,
I have a strange thing in Oracle istore emails.In most of the email headers am seeing From,Sent and Notification ID details.I would like to remove the notification ID from header.where the header mapping can be changed to particular email template.Please let me know.

Reply
Arulmani says November 10, 2014

Dear Atul,

We have WF configured with production with a SMTP user.
Can we use the same user to configure the WF mailer for test and development?

Is it advisable or any issue will happen?

Waiting for your valuable advise.

Thanks,
Arulmani

Reply
VikasM says December 19, 2014

Hi Atul,
I am facing issue with workflow Notification. PO approval workflow is not sending notification/email to the user, neither for approval nor for rejection.
I checked the users in WF_LOCAL_ROLES table and found that these user are not defined as WF_LOCAL_USER, instead defined as PER. Hence I believe this is the issue.
I looked into the metalink and found a note where they suggest to Run the “Workflow Directory Services User/Role Valudation” Concurrent Program TWICE. I did same, but no success.
Could you please help me. I am a new learner on Workflows.
Thanks,
VikasM

Reply
suresh says December 24, 2014

what is teh loction for cacert file for workflow

Reply
Margarita says January 18, 2015

I am in fact delighted to read this webpage posts which contains lots off helpful
data, thanjs for providing such statistics.

Reply
email exchange says February 12, 2015

I am really loving the theme/design of your site. Do you
ever run into any browser compatibility issues? A number of my bblog visitors have complained about my
website not workin correctly inn Explorer but looks great in Safari.
Do you have any tips to help fix thijs problem?

Reply
Rajan says February 24, 2015

Hello Atul,

We have the cloud office 365 mail service. Due to the security policy we can not connect directly to the cloud SMTP server EBS Server. We need to setup both INBOUND and OUTBOUND mails. Could you please guide on alternate solutions?

best regards,
Rajan

Reply
sjala says October 15, 2015

Hi,

i am new to oracle workflow builder .please can any one tell me how to know details from which workflow we are getting the mails. is their any table to get the details of workflow.

Reply
Add Your Reply