This content has been marked as final. Show 4 replies
Use the below Oracle notes to debug the WF notifications.
Tracking Workflow Notification Event Messages [ID 433359.1]
A Guide For Troubleshooting Workflow Notification Emails - Inbound and Outbound [ID 831982.1]
If you see the entry in 'wf_notifications' table then you can see the notification in recipient worklist UI. If you want to receive the email notification you need to pass the email address when calling wf_directory.createadhocrole() API
You can also verify the activity status from Status Monitor search by giving the item type and item key.
Since you are assigning the notification to a role (v_role_name_b) and not to a user directly, then you will have to change the message of this notification so that the check box Expand Roles is checked. This way the workflow mailer will loop through all the users of this role (in this case only this user) and will e-mail the notification.
Of course, you need to ensure that the user v_user_name was created properly and has an e-mailable notification preference, like MAILHTML or so.