Introduction:
User’s notification preferences are being disabled in WF_LOCAL_ROLES table and the administrator is receiving email notification such as following:
To SYSADMIN
Sent 10-Nov-2011 14:25:32
ID 5208
What happens and how this error occur?
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’;
NOTIFICATION_PREFERENCE EMAIL_ADDRESS
—————————— —————————————
DISABLED xyz@smtpserver.com
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:
- 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.
[Nov 16, 2011 8:19:08 AM CST]:1321453148928:-1:-1:acctdb1.offi.dall.tx.acm:10.176.1.52:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1808479824:95398:1321452935429:29:ERROR:[SVC-GSM-WFMLRSVC-60063-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:SendFailedException -> [[“xyz, xyz” <xyz@smtpserver.com>]] javax.mail.SendFailedException: Invalid Addresses;
nested exception is:
class com.sun.mail.smtp.SMTPAddressFailedException: 550 relay not permitted
How to resolve:
The error is an indication that there are some security configurations on the SMTP server that are preventing the SMTP server from accepting the notifications that are coming from Workflow Notification Mailer.
The SMTP server administrator needs to verify the cause of this error. Some reasons could be:
- The anti-spam settings on the mail server are set in such a way that you cannot send emails to those addresses from unauthorized clients.
- Also some SMTP servers are configured to deny email from clients that send an IP address in HELO command.
Conclusion:
By modifying security configurations on the SMTP server that are preventing the SMTP server from accepting the notifications this can be resolved.
