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

Last updated on NOVEMBER 30, 2013

Applies to:

Oracle Workflow Cartridge - Version 11.5.10.2 to 11.5.10.2 [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


Goal

Scenario:

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?




Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms