5 Replies Latest reply on Sep 24, 2018 6:19 AM by Bommi

    WF Notifications - Outlook - Not appearing

    1552104

      Hi,

       

      This is related to Workflow.

       

      When I am sending notification to Individual application User or Notification send to ROLE in both cases Employee receiving notification in Worklist.

       

      And at the same time when Notification send to application User Notification is appearing in Outlook mail Inbox.

       

      But, the notifications send to ROLE are not appearing in Outlook Inbox or junk mail.  It is only appearing in worklist only.

       

      We need to be setup to bring these notifications to Outlook.

       

      Regards.

        • 1. Re: WF Notifications - Outlook - Not appearing
          Shaik

          Hi

           

          Check whether user attached with email or not

           

          and check notification preference must be MAILTEXT,  MAILHTML

           

          Regards

          Shaik

          • 2. Re: WF Notifications - Outlook - Not appearing
            1552104

            Dear Shaik,

             

            Mail preferences values are set for all the Users in the ROLE, they are getting notification in Outlook when it is send to individual Users.

             

            Regards.

            • 3. Re: WF Notifications - Outlook - Not appearing
              Bommi

              Hi,

                   From where you created the role? Can you check in 'Status monitor'? (Workflow Administrator Resp. > Administrator Workflow > Status Monitor. Query the workflow item) Then select and click on 'Workflow Details' and check the role value

                   Also, I suggest you to use below to create adhoc roles

               

              wf_directory.createadhocrole (v_role_name,          --Role Name

                                                     v_role_name,

                                                     'AMERICAN',

                                                     'AMERICA',

                                                     'Custom Role created for AP Team to send Emails on AME',

                                                     'MAILHTML',

                                                     NULL,

                                                     NULL,

                                                     NULL,

                                                     'ACTIVE',

                                                     SYSDATE + 100

                                                    );

               

                   Now, add the users to role as below

              wf_directory.adduserstoadhocrole (v_role_name, v_role_user);

               

              v_role_user must be application login name.

              You can use the below query to check if the users are added properly to the role.

               

              SELECT *

              FROM wf_local_user_roles

              WHERE 1 = 1 AND role_NAME =<role_name>;

               

              Regards,

              Bommi

              • 4. Re: WF Notifications - Outlook - Not appearing
                3318914

                Hi,

                 

                Check from table fnd_user_preference that user has preference_value 'MAILHTML' in preference_name MAILTYPE

                 

                select * from fnd_user_preferences where user_name like 'ABC';

                 

                if you get value 'DISABLED' 'then

                 

                update fnd_user_preferences set preference_value = 'MAILHTML'

                where user_name = 'ABC' and module_name = 'WF';

                 

                after that you can run concurrent program "Resend Failed / Error Workflow Notifications" in responsibility System Administrator

                • 5. Re: WF Notifications - Outlook - Not appearing
                  Bommi

                  Hi,

                       Seems he has an issue when he try to send mails t role, but not for individual user. Updating preference_value in FND_USER_PREFERENCE will help for individual user (as far as I know)

                   

                   

                  Regards,

                  Bommi