Change Mail Preferences for all Application Users (FND USERS)

How to mass change Mail Preferences for FND USERS [ID 451929.1]

Solution :

Using sqlplus as the apps user:

1^st Method:

 1.

update wf_local_roles

set notification_preference = 'MAILHTML'

where user_flag='Y'

2.

update fnd_user_preferences

set preference_value = 'MAILHTML'

where module_name = 'WF'

and preference_name = 'MAILTYPE'

commit;

2nd method:

Navigation: Connect to Applications as Sysadmin user and select responsibility

 Workflow Administrator  Web Applications --> Administration --> Global  Preferences