Compare FND profiles of Users
**************************************************************************************
Profile options
****************************************************************************************
to compare users profile
select LEVEL_ID,LEVEL_VALUE,PROFILE_OPTION_VALUE from FND_PROFILE_OPTION_VALUES a where APPLICATION_ID in (select RESPONSIBILITY_APPLICATION_ID from FND_USER_RESP_GROUPS_ALL where USER_ID=(select USER_ID from fnd_user where USER_NAME='&a'));
select count(1)
from fnd_profile_option_values where profile_option_value like '%www.diipartner.net%'
col user_profile_option_name format a37 hea 'Profile Option Name'
col profile_option_name format a26 hea 'Profile Option Code'
col profile_option_value format a33 hea 'Value'
col level_id format a15 hea 'Set at Level'
col user_name format a12 hea 'User Name'
col last_update_date format a12 hea 'Date Changed'
set lines 150
set pages 9999
select l.user_profile_option_name
,l.profile_option_name
,v.profile_option_value
,decode(v.level_id,'10001','Site'
,'10002','Application'
,'10003','Responsibility'
,'10004','User'
,v.level_id) Level_ID
,u.user_name
,v.last_update_date
from fnd_profile_options_tl l
,fnd_profile_options o
,fnd_profile_option_values v
,fnd_user u
where o.profile_option_name = l.profile_option_name
and l.user_profile_option_name like '%configurator%'
and v.profile_option_id = o.profile_option_id
and l.language = 'US'
and u.user_id(+) = v.level_value
/
update fnd_profile_option_values fpov
set PROFILE_OPTION_VALUE = replace(PROFILE_OPTION_VALUE,'www.irpartner.net','www.diipartner.net')
where PROFILE_OPTION_VALUE like '%irpartner%'