11i-12 How to Set e-mail Style Preference for all Users at Once?

(Document ID 578574.1)

In this Document

Goal

Solution

Workflow information Center, diagnostics, & Community

References

Applies To:

Oracle Workflow cartridge-version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 06-jul-2013

GOAL

The goal of that Note are to explain how to bulk update the e-mail Style preference for all e-business Suite users at once. The same can used to update the e-mail Style for a group of users only, for instance the users who has the preference s ET to "Disabled" ...

Usually, each user must reset the e-mail Style preference through the "Preferences" page available from his Home page.

Solution

1. Unfortunately, currently there is no seeded-to-do this. An enhancement request have been logged for this under internal Bug 5748131 (need pleasant the to BULK RESET NOTIFICATION P REFERENCE from DISABLED).
It is under Oracle development ' s review.

2. Currently, the workaround to change the e-mail Style of all users are to update the tables.
Note that there is 2 tables to update:fnd_user_preferences and wf_local_roles.

One should backup the tables before performing the updates as updating application tables from Sqlplus are not supporte D.

3. Updates for all Users would look like:

A.

Update Wf_local_roles
Set notification_preference= ' <wished_preference> '
where Orig_system in (' Fnd_usr ', ' PER ');

B.

Update fnd_user_preferences
Set preference_value= ' <wished_preference> '
where Preference_name= ' Mailtype '
and Module_name= ' WF '
and user_name <> '-wf_default-';

4. The Updates for Users have the preference set to "Disabled", would look like:


A.

Update Wf_local_roles
Set notification_preference= ' <wished_preference> '
where Orig_system in (' Fnd_usr ', ' PER ')
and name in
(Select user_name
From Fnd_user_preferences
where Preference_name= ' Mailtype '
and Module_name= ' WF '
and preference_value= ' DISABLED ');

B.

Update fnd_user_preferences
Set preference_value= ' <wished_preference> '
where Preference_name= ' Mailtype '
and Module_name= ' WF '
and preference_value= ' DISABLED ';

The WHERE clauses of above SQL can is modified to match ones needs.

Possible values for <wished_preference> is:

QUERY (corresponds to preference value "does not send me mail")
Mailtext (corresponds to preference value "Plain text Mail")
MAILATTH (corresponds to preference value "Plain text mail with HTML attachments")
Mailhtml (corresponds to preference value "HTML Mail with Attachments")
MAILHTM2 (corresponds to preference value "HTML mail")
SUMMARY (corresponds to preference value "Plain text SUMMARY Mail")
Sumhtml (corresponds to preference value "HTML summary Mail")
DISABLED (corresponds to preference value "DISABLED")

Workflow information Center, diagnostics, & Community

• Reference the Workflow Product information Center Document for Top Workflow resources:document 1320509.1

• For additional help, please refer to one of the following documents on diagnostics to address current needs. Providing diagnostic output on the issue for support when logging a service request is very helpful.
  
  Document 179661.1 for 11i or document 421245.1 for Rel 12.x

• Visit the Core Workflow community for help with industry experts or to share knowledge.
  
  
• Please see Document 1186338.1 for recorded Workflow webcasts.

11i-12 How to Set e-mail Style Preference for all Users at Once?