How to Update Profile option values which are pointing to source instance of DB-Refresh/Clone:

How to Update Profile option values which are pointing to source instance of DB-Refresh/Clone.

sqlplus apps/<apps password>

SQL> set linesize 140

set pagesize 132

column NAME format A40

column VALUE format A80 wrap

select n.user_profile_option_name NAME,

    v.profile_option_value VALUE

    from apps.fnd_profile_options p,

         apps.fnd_profile_option_values v,

         apps.fnd_profile_options_tl n

    where p.profile_option_id = v.profile_option_id (+)

    and p.profile_option_name = n.profile_option_name

    and v.level_id=10001

    AND n.LANGUAGE='US'

 and upper(v.profile_option_value) like upper('%prod%');

Note: If the O/p show PROD entries, please fire below update quey & provide the values source & Destination

Replace source instance paths with target instance using below DML Query.

SQL> update fnd_profile_option_values

set PROFILE_OPTION_VALUE= '&TargetPath'

where PROFILE_OPTION_VALUE = '&SourcePath';

++++++++++++++++++

set linesize 140
set pagesize 132
column NAME format A40
column VALUE format A80 wrap
select   
n.user_profile_option_name NAME,
v.profile_option_value VALUE
from apps.fnd_profile_options p,
    apps.fnd_profile_option_values v,
      apps.fnd_profile_options_tl n
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
and v.level_id=10001
AND n.LANGUAGE='US'
and upper(n.user_profile_option_name) like upper('%&profile_name%');

If you need to check DISCO:

Enter value for profile_name: ICX: Discoverer