Script to update Email Style for all Employees - Oracle Applications

Business Case:
Login > Click on Preferences > Under Notifications, 'Email Style'
Update this email style as 'HTML mail' for all employees

Solution:
Run following SQL's to update 'Email Style' to 'HTML mail', under The Notification Preference For All The Users.
1.
UPDATE wf_local_roles
   SET notification_preference='MAILHTM2'
 WHERE orig_system IN ('FND_USR', 'PER');
2.
UPDATE fnd_user_preferences
   SET preference_value='MAILHTM2'
 WHERE preference_name ='MAILTYPE'
   AND module_name     ='WF'
   AND user_name      <> '-WF_DEFAULT-';

3. Issue Commit.

Note:

1. To update Email Style as 'HTML mail with attachments', we need to use 'MAILHTML' instead of 'MAILHTM2'

2. Other email styles and description:

• DISABLE = Disabled
• QUERY = Do not send me mail
• MAILHTM2 = HTML mail
• MAILHTML = HTML mail with attachments
• SUMHTML = HTML summary mail
• MAILTEXT = Plain text mail
• MAILATTH = Plain text mail with HTML attachments 
• SUMMARY = Plain text summary mail

 3. If this preference need to be set for all new users created in the system

   Navigate to Workflow Administrator Web (New)>Administration
   Under Global Preferences, Set the Notification Style as appropriate. In this case 'HTML mail'