Query to find the User preferences set for a User in Oracle Apps/EBS
We can use below query to check preferences set for a user. In this example I am checking the preferences set for user related to workflow/mails.
select * from fnd_user_preferences where PREFERENCE_NAME='MAILTYPE' and MODULE_NAME = 'WF' and user_name in ('HIMANSHU.SINGH');
select preference_value
from fnd_user_preferences
where user_name='HIMANSHU.SINGH'
and preference_name='MAILTYPE';
select distinct PREFERENCE_VALUE from fnd_user_preferences where PREFERENCE_VALUE like '%MAI%'
select PREFERENCE_VALUE
from FND_USER_PREFERENCES
where USER_NAME='-WF_DEFAULT-'
and MODULE_NAME='WF'
and PREFERENCE_NAME='MAILTYPE' ;
select * from wf_local_roles
where notification_preference in ('DISABLED','QUERY')
and orig_system='PER' and name in ('HIMANSHU.SINGH');
3 Comments
Thanks For This Blog...
ReplyDeletesalesforce CRM Training
devops course in hyderabad
full stack java training
Looking for this query. Thanks for posting this,
DeleteOf course, this is the set which requires to be checked out. However, I think that we have to be very careful with how it looks like.
ReplyDeletePost a Comment