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%'