Monday, March 22, 2010

User Notification Preference Update from backend

We have been facing problems when the email address is not properly defined in per_people_f and fnd_user at times the mailer changes the send mail preference to disabled. So this creates a situation where you have to ask the user to change his preference to HTML mail with attachments.

There is another way out doing it from back end.

exec FND_PREFERENCE.put('SYSADMIN', 'WF', 'MAILTYPE', 'MAILHTML');
COMMIT;

as documented in Metalink Note ID 746255.1

No comments: