Stay at Home!! Be Safe!! Take Care!!

For Any queries, please mail us at support@funoracleapps.com

Query to find the User preferences set for a User in Oracle Apps/EBS

3 comments

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 :

  1. Replies
    1. Looking for this query. Thanks for posting this,

      Delete
  2. Of 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.

    ReplyDelete