11i - 12 How To Set Email Style Preference For All Users At Once?

kikiwhq

已于 2023-03-29 13:56:55 修改

阅读量149

点赞数

分类专栏： EBS SA WF-NF 文章标签： Oracle WF-NF EBS-SA Powered by 金山文档

于 2023-03-20 13:35:39 首次发布

原文链接：https://www.cnblogs.com/huak/p/4158004.html

版权

SA 同时被 3 个专栏收录

30 篇文章 0 订阅

订阅专栏

EBS

11 篇文章 0 订阅

订阅专栏

WF-NF

10 篇文章 0 订阅

订阅专栏

摘自：11i - 12 How To Set Email Style Preference For All Users At Once? - huak - 博客园 (cnblogs.com)

11i - 12 How To Set Email Style Preference For All Users At Once? (Doc ID 578574.1)

In this Document

Goal

Solution

Workflow Information Center, Diagnostics, & Community

References

APPLIES TO:

Oracle Workflow - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]

Information in this document applies to any platform.

GOAL

The goal of that Note is to explain how to bulk update the Email Style preference for all E-Business Suite users at once. The same can be used to update the Email Style for a group of users only, for instance the users who have the preference set to "Disabled" ...

Usually, each user must reset the Email Style preference through the "Preferences" page available from his Home Page.

SOLUTION

1. Unfortunately, currently there is no seeded way to do this. An enhancement request has been logged for this under internal Bug 5748131 (NEED PLEASANT WAY TO BULK RESET NOTIFICATION PREFERENCE FROM DISABLED).

It is under Oracle Development's review.

2. Currently, the only workaround to change the Email Style of all users is to update the tables.

Note that there are 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 is not supported.

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. Updates for Users having 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 be modified to match ones needs.

Possible values for <wished_preference> are:

QUERY (corresponds to preference value "Do 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")

In EBS 12.2+, run the Concurrent Program (FNDWFBULKRESETNTFPREF) "Workflow Directory Services Bulk Reset DISABLED Notification Preference".

This program resets the notification preference of all DISABLED users/roles by Mailer due to some error to its previous value.

Workflow Information Center, Diagnostics, & Community

Please 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 an issue for support when logging a service request is very helpful.

Document 179661.1 for 11i or Document 421245.1 for Rel 12.x