My Oracle Support Banner

User Notification Preference Updated to DISABLED (Doc ID 1379564.1)

Last updated on JULY 12, 2019

Applies to:

Oracle Workflow - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Checked for relevance on 11-MAY-2013


User's notification preferences are being disabled in WF_LOCAL_ROLES table and the administrator is receiving email notification such as following:

Sent 10-Nov-2011 14:25:32
ID 5208

The notification with the ID of 5207 experienced problems when attempting to dispatch an email notification to the role XYZ. Subsequently the notification preference for the following users has been set to DISABLED. Please correct the issue and re-enable their notification preference.

Run the following sql as the apps user:

   select notification_preference,email_address
      from applsys.wf_local_roles
     where name = 'XYZ';

------------------------------ ---------------------------------------

One is sure that the notification email address returned for this user is a valid email and can send email to this user from any mail client and the user receives all emails except email notifications from Oracle Applications.

One can do further testing by sending a test notification to any other user and verify if the user's notification preference gets disabled too.

Send a Test Outbound E-mail to another user:

1. In the Service Components page for notification mailers in Oracle Applications Manager, select the Workflow Notification Mailer service component and click the View Details button.
2. Click the Test Mailer button. The test page lets you send a test e-mail to a workflow role. In the Recipient Role field, select your user name from the list of values. Note that only workflow roles with a notification preference set to receive e-mail and an e-mail address defined are included in the list of values for this field.
3. Click the Send Test Message button.
4. In your preferred mail client, verify that the e-mail account associated with this e-mail address receives the test e-mail.

If not, run the sql above to check if the user's notification preference has been set to DISABLED.


SMTP server security configuration


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.