Check whether user attached with email or not
and check notification preference must be MAILTEXT, MAILHTML
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.
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
'Custom Role created for AP Team to send Emails on AME',
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.
WHERE 1 = 1 AND role_NAME =<role_name>;
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
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)