User Profile Options

With the following query, you can list all the profile options assigned to a particular user:

select vl.profile_option_name,tl.user_profile_option_name,val.profile_option_value
from fnd_profile_options vl,fnd_profile_option_values val,fnd_profile_options_tl tl
where vl.PROFILE_OPTION_ID = val.profile_option_id
and tl.language = 'US'
and tl.profile_option_name = vl.profile_option_name
and val.level_value = (select user_id from fnd_user where user_name = 'ORACLE')
order by vl.profile_option_name;