Workflow Notification Mailer Setup in Oracle Apps R12

Workflow Notification Mailer Setup in Oracle Apps R12/12i 

December 27, 2007 /



r12





workflow /

By Atul Kumar / By Atul Kumar / 73 COMMENTS

On popular demand from readers, I am going to cover Workflow W orkflow 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), (Opti onal), 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/T est 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

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

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

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

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

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 Did you get a chance to download 6 Docs Every Apps DBA Must Read for EBS R12.2 ? If not, then get it now by clicking on link below.

If you want to learn more about Oracle Apps DBA (Architecture, Installation, WebLogic, Patching, Cloning and other maintenance tasks with the upgrade of Oracle E-Business Suite 12.2.0 to 12.2.4 then have a look at our Oracle Apps DBA Training . Note: We are so confident on our workshops that we provide 100% Money back guarantee provided that you do the work e.g. attend Live Sessions, Perform Activity Guides, Watch Recordings, Apply for the Job , in unlikely case of you being not happy, just drop us a mail and We’ll refund FULL money (or ask us from our 100s of happy trainees in our private Facebook Group) Share This Post with Your Friends over Social Media! 

50



3



14

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: Name * E-Mail * Website

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


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


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 Workfl ow 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

Atul Kumar says November 26, 2008

Rajesh, Check workflow developer guide here For 11i http://download.oracle.com/docs/cd/B25516_18/current/acrobat/115wfdg.zip

For R12 http://download.oracle.com/docs/cd/B40089_10/current/acrobat/120wfdg.pdf 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


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: [email protected] RCPT TO: your_target_mail@your_target_domain DATA Subject: Type_some_dummy_mail_body_here . (Type Dot to finish entering data) quit Reply


Hi, Thank you for your immediate response. Find below the result of the test : ——————————————–

EHLO bones.otalgerie.com MAIL FROM: [email protected] RCPT TO: [email protected] 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


Issue is with SMTP server , Are you using exchange , Novel groupwise or any other SMTP server ? Contact person/team who maintains SMTP server Reply


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_COU NT=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


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


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


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 i t 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. [email protected] Reply


@ 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

[email protected] 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


@ akreddy To configure SMTP server on Linux use this link http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch21_:_Configu ring_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


@ 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.

Workflow Notification Mailer Setup in Oracle Apps R12

Recommend Documents