5 Replies Latest reply on Jan 25, 2017 10:04 PM by Bharat G

    Email Address table used in Workflow Notifications

    Bharat G

      Hi All,

       

      Trying to explore which table is used to get email address in Workflow notifications to send emails.

       

      Regards,

      Bharat

        • 1. Re: Email Address table used in Workflow Notifications
          mdtaylor

          fnd_user, per_all_people_f and wf_local_roles.

          • 2. Re: Email Address table used in Workflow Notifications
            2794067

            Hi,

             

            wf_notifications and wf_users contains the email address.

             

            Regards,

            Bala

            • 3. Re: Email Address table used in Workflow Notifications
              Bharat G

              Thank you for your prompt response Taylor,

               

              from the mentioned 3 tables, is it going to take email address from 3 tables based on any priority ?

              because, in those 3 tables we will have email address. So how the workflow will look for email address to send notifications?

               

              Regards,

              Bharat

              • 4. Re: Email Address table used in Workflow Notifications
                mdtaylor

                Hi Bharat,

                 

                The notification will be sent to the email address stored in wf_local_roles.  If it comes from fnd_user or per_all_people_f (or hz_parties) depends on how the user is defined and if a supplier or party is attached.

                 

                If I want to test email notifications in Vision for example, and I have an email address I can access, I would do the following updates:

                 

                update fnd_user set email_address = 'services@home.com' where user_name

                = 'SERVICES'

                /

                update per_all_people_f set email_address = 'services@home.com'

                where person_id = (select employee_id from fnd_user where user_name = 'SERVICES'

                )

                /

                update wf_local_roles

                   set email_address = 'services@home.com

                where name = 'SERVICES'

                /

                 

                Then send a test notification from Oracle Applications Manager Workflow section to SERVICES and it would go to that email address if SMTP outbound workflow notifications are properly configured.

                 

                Regards,

                Michael

                1 person found this helpful
                • 5. Re: Email Address table used in Workflow Notifications
                  Bharat G

                  Thanks a lot Michael,

                   

                  After few studies, came to know that if email address is correctly located in WF_LOCAL_ROLES Table, then Workflow notifications will go fine.

                  To update WF_LOCAL_ROLES table we must have email addresses correctly in FND_USER. Once Workflow sync is happened correctly, then email addresses from FND_USER will be updated in WF_LOCAL_ROLES automatically.

                  in FND_USER table we can update emails in two ways.

                  1. If employee table have correct email address in PER_ALL_PEOPLE_F Table, then we can assign that person to appropriate User in FND_USER. So automatically Email Address from PER_ALL_PEOPLE_F is loaded to FND_USER table.

                  or

                  2. We can automatically update the email address in FND_USER table.

                   

                  Regards,

                  Bharat