My Oracle Support Banner

Email Notifications To A Role Are Not Being Received (Doc ID 561192.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Workflow - Version to [Release 11.5.10]
Information in this document applies to any platform.
Workflow Directory Services and Workflow Mailer Email Notifications (ATG RUP 4 and higher)
Checked for relevance on 30-NOV-2013



Assigned user to the role 'HR Rep'. Tested a process that was supposed to send a notification to
this role 'HR Rep', but while a notification was viewable in the Oracle Worklist an email notification was never received. Found <Note 302262.1> that states the notification_preference for this role needs to be set in order for emails to be received. I ran the following script to
update the preference: update wf_local_roles set notification_preference = 'MAILHTML' where name='PQH_ROLE:1'

Once retested, everything worked and the user received an email as expected. However, saw a note that mentioned that the 'Synchronize WF LOCAL tables' process will wipe out this value when run.  Upon testing this and the value was reset to 'QUERY'. This is run nightly, so a
better solution is needed.

What's needed to ensure that this value is updated permanently?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.