How to mass change Mail Preferences for FND USERS

How to mass change Mail Preferences for FND USERS

 How to change all existing users to 'HTML Mail' as their preference?

         Direct table updates are not supported.  Please ensure to perform a backup prior to making any changes reflected in this document.

Using sqlplus as the apps user:

Step 1:

SQL> update wf_local_roles

set notification_preference = 'MAILHTML'

where user_flag='Y'

Step 2:

SQL> update fnd_user_preferences

set preference_value = 'MAILHTML'

where module_name = 'WF'

and preference_name = 'MAILTYPE'

step 3:

SQL> commit

++++++++++451929.1 ,728483.1++++++++++++