13 Replies Latest reply on Nov 18, 2014 11:36 AM by MariaKarpa(MK)

    WorkFlow email notification

      Hi all,

       

      EBS 12.2

       

      Can you please give me  docs/links on how to configure & test email notification in EBS R12.2?

       

      Thank you so much for your usual support and help.

       

      mk

        • 1. Re: WorkFlow email notification
          Srikkanth.M

          Hi,

           

          Could pls check whether the email notification server is up.

           

          Ranjit's Oracle Blogs: Workflow Notification Mailer Setup in Oracle Apps R12/12i

           

          Thanks & Regards

          srikkanth.M

          1 person found this helpful
          • 2. Re: WorkFlow email notification

            Thanks Sri,

             

            How do I check if my email server is up?

             

            Is this command okay?

             

            $ mailx -s "test mail"  mariakarpa@yahoo.com <  "hello world!"

             

             

            Thanks a lot

            • 3. Re: WorkFlow email notification
              Srikkanth.M

              From the application you can check whether the notification server is up or not.

               

              Regards

              sri

              1 person found this helpful
              • 4. Re: WorkFlow email notification

                Thanks Sri 

                • 5. Re: WorkFlow email notification
                  Mohammed Ali A. Syed

                  MariaKarpa(MK) wrote:

                   

                  Thanks Sri,

                   

                  How do I check if my email server is up?

                   

                  Is this command okay?

                   

                  $ mailx -s "test mail"  mariakarpa@yahoo.com <  "hello world!"

                   

                   

                  Thanks a lot

                   

                  If you are using any other external mail server, then you can not test it from Oracle Applications.

                   

                  You can use point 3 in

                   

                  How to perform a meaningful SMTP telnet test to troubleshoot Java Mailer for sending email notifications (Doc ID 753845.1)


                  Thanks

                  1 person found this helpful
                  • 6. Re: WorkFlow email notification

                    Hi Ali, Sri,

                     

                    I have edited the wf mailer notification and I have this window:

                     

                     

                    * Name

                    Outbound EMail Account (SMTP)

                    * Server Name

                    Host Name of the machine used to send email notifications (including full domain name).

                    Username

                    Username for the Outbound Server

                    Password

                    Password for the Outbound Server

                    Outbound SSL Enabled

                    What username do I put on the outbound server? Can I use my personal email like mariakarpa@yahoo.com , just for testing purpose only?

                    How do I know what is my smtp server name? I have the root login password. What command do I run to get the smtp server?

                    By the way, I was able to send email to mariakarpa@gmail.com using linux generic commnad > mail -s

                     

                    Thanks a lot,

                    • 7. Re: WorkFlow email notification

                      Hi all,

                       

                      I have found this doc, but this is for 11i, is there counterpart for 12.2 for this note/doc?

                       

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


                      Thanks a lot.

                      • 8. Re: WorkFlow email notification
                        ;) ApPsMasTi ;)

                        the doc says

                        Oracle Workflow - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]


                        How Does One Configure Oracle Applications Workflow Notification Mailer And Where Is The Documentation To Do That? [ID 1051562.1]

                        Configuring the Oracle Workflow 2.6 Java-based Notification Mailer with Oracle Applications 11i [ID 231286.1]

                        Example Of Configuring Workflow Java Notification Mailer With Oracle Applications [ID 249957.1]    

                        How To Configure The Workflow Java Mailer Without An IMAP Account (Assumes No Inbound Processing) [ID 268274.1]

                        Oracle Workflow Release Notes for Release 12.2.2 (Doc ID 1375779.1)

                         

                         

                        Thanks though


                        • 9. Re: WorkFlow email notification

                          Opps sorry, thanks, but what username, password do I supply in the edit outbound email notification?

                          • 10. Re: WorkFlow email notification
                            Mohammed Ali A. Syed

                            Hi,

                            Regarding you question about username and password for mail server see these documents,

                             

                            Can Workflow Mailer Use SMTP With Authentication? (Doc ID 564361.1)

                            Is it required to set the OUTBOUND_USER Workflow Mailer parameter in 12.1.3? (Doc ID 1544552.1)

                             

                            Thanks

                            1 person found this helpful
                            • 11. Re: WorkFlow email notification

                              Hi all ebsdba, and all

                               

                              I ask the network admin what is our smtp server

                               

                              I added the smtp server but when I apply I got connection refused.

                               

                               

                              Applications Dashboardhttp://crp2.oracle.amti.com.ph:8000/OA_HTML/cabo/images/skyros/navPane_sSeparator.pngSite Map

                               

                              http://crp2.oracle.amti.com.ph:8000/OA_HTML/cabo/images/skyros/error.pnghttp://crp2.oracle.amti.com.ph:8000/OA_HTML/cabo/images/skyros/t.gif

                              An error has occurred!

                               

                              Connection refused

                              http://crp2.oracle.amti.com.ph:8000/OA_HTML/cabo/images/skyros/tip.pngTIP Use Browser's Back button to go to previous page.

                               

                               

                              Please help,

                              Thanks

                              • 12. Re: WorkFlow email notification
                                Mohammed Ali A. Syed

                                Did you perform the tests as shown in the document below? Please read all our replies before posting your questions. Please do not waste precious time of you and ours

                                 

                                You can use point 3 in

                                 

                                How to perform a meaningful SMTP telnet test to troubleshoot Java Mailer for sending email notifications (Doc ID 753845.1)


                                1 person found this helpful
                                • 13. Re: WorkFlow email notification

                                  Thanks ebsdba,

                                   

                                   

                                  I tried to follow the docs above but there are "not-so-clear" instructions.

                                   

                                   

                                  I did the following:

                                   

                                  ================

                                  Solution

                                   

                                  It is very important to perform all the steps mentioned below; they will allow to perform the telnet SMTP test from the right node and to pass the correct values during the test.

                                   

                                  1) Identify the concurrent tiers node where mailer runs by running script below:

                                   

                                  SQL> select target_node from fnd_concurrent_queues where concurrent_queue_name like 'WFMLRSVC%';

                                   

                                  TARGET_NODE

                                  ------------------------------

                                  APPSCRP

                                   

                                  In this example APPSCRP is the node where java mailer runs.

                                   

                                  2) Gather other parameters values necessary for the SMTP telnet test:

                                   

                                  To perform the SMTP telnet test, in addition to mailer node, you will also need to know on which node is the SMTP server (this is mailer "outbound server" parameter), and what is the reply to address that is set up for the java mailer (this is mailer "reply to" parameter).

                                   

                                  To get these values run the following:

                                    

                                  SQL>

                                    1  SELECT b.component_name,

                                    2         c.parameter_name,

                                    3         a.parameter_value

                                    4  FROM fnd_svc_comp_param_vals a,

                                    5       fnd_svc_components b,

                                    6       fnd_svc_comp_params_b c

                                    7  WHERE b.component_id = a.component_id

                                    8       AND b.component_type = c.component_type

                                    9       AND c.parameter_id = a.parameter_id

                                  10       AND c.encrypted_flag = 'N'

                                  11       AND b.component_name like '%Mailer%'

                                  12       AND c.parameter_name in ('OUTBOUND_SERVER', 'REPLYTO')

                                  13* ORDER BY c.parameter_name

                                  ==============================================================================

                                  Workflow Notification Mailer >  OUTBOUND_SERVER > appscrp.oracle.com.ph

                                  Workflow Notification Mailer >  REPLYTO > changeOnJavaMailerInstall

                                   

                                  In this example the outbound server is on appscrp.oracle.amti.com.ph node and the reply to address is set to changeOnJavaMailerInstall.

                                   

                                  3) Perform the SMTP telnet test as follows:

                                   

                                  3.1) Log on to the node where mailer runs (to identify it, please refer to step 1)

                                   

                                  This is mandatory. SMTP telnet test is only meaningful when it is performed from the concurrent tier where mailer runs.

                                   

                                  In our example you should log to APPSCRP node.

                                   

                                  3.2) From mailer node, issue the following commands one by one:

                                   

                                  telnet appscrp.oracle.com.ph 25

                                  EHLO APPSCRP

                                  MAIL FROM: changeOnJavaMailerInstall

                                  RCPT TO: mariakarpa@gmail.com

                                  DATA

                                  Subject: Test message

                                   

                                  Test message body

                                  .

                                  quit

                                  =========================

                                   

                                   

                                  I do not understand > 3.2) From mailer node, issue the following commands one by one.

                                   

                                  It says to type one by one? how can it run in unix?

                                   

                                  Is the appstier node is also the mailer node?

                                   

                                  Do I need to telnet itself? Login to itself and telnet itself?

                                   

                                  Why is my mailto not configured? > changeOnJavaMailerInstall

                                   

                                  [applcrp@appscrp ~]$ telnet appscrp.oracle.amti.com.ph 25

                                  Trying 192.168.167.114...

                                  telnet: connect to address 192.168.167.114: Connection refused

                                   

                                  [applcrp@appscrp ~]$ EHLO APPSCRP

                                  -bash: EHLO: command not found

                                  [applcrp@appscrp ~]$ ehlo appscrp

                                  -bash: ehlo: command not found

                                  [applcrp@appscrp ~]$ mail from: