Why some users from FND_USER do not have a record in FND_USER_PREFERENCES for their Notification Preference?


Explanation

A user will have a record in table FND_USER_PREFERENCES for the Notification Preference, only when the users explicitly set the Email Style preference in the Preferences page.  If a user never explicitly sets the Email Style, then there will be no record in FND_USER_PREFERENCES, instead, the global preference will apply.

When a user has set the Email Style desired, from the Preferences page, a record can be found in table FND_USER_PREFERENCES by running:


select preference_value
from fnd_user_preferences
where user_name='<user>'
and preference_name='MAILTYPE';

When the user has never set the Email Style, the global preference applies, which can be found using:


select preference_value
from fnd_user_preferences
where user_name='-WF_DEFAULT-'
and preference_name='MAILTYPE';





If you like please follow and comment