How to update source instance Profile values to dest instance:

Step 1: To find the values as below Select Statement:

Login as oracle user to apps node and execute the following

sqlplus apps/<apps password>

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

Step 2: Update Profile option values which are pointing to source instance.

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

SQL > update fnd_profile_option_values

    set PROFILE_OPTION_value= '&TargetPath'

    where PROFILE_OPTION_value = '&SourcePath';

Step 3:

#sqlplus apps/<apps password>

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

Sample O/P:

Enter value for profile_name: RMI Server

old  11: and upper(n.user_profile_option_name) like upper('%&profile_name%')

new  11: and upper(n.user_profile_option_name) like upper('%RMI Server %')

NAME                                     VALUE

----------------------        -------------------------------------

TWE: RMI Server IP Address               10.06.108.108

TWE: RMI Server Request Port Number      8000

TWE: RMI Server Log Enabled              Y

Note:  prod à Source Instance name

profile_name  à POS: External URL /  WE: RMI Server IP Address /  ICX: Discoverer / ICX: Requisition Sever / ABM: Web Server Host    etc … Some of other options

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

Step 1: Verify WF mailer IMAP and SMTP Settings using below Query. Output should match with output taken in pre-clone Checks

                sqlplus apps/<apps password>

set lines 130

set pages 100

col value format a30

select p.parameter_id,p.parameter_name,v.parameter_value value

from fnd_svc_comp_param_vals_v v,

fnd_svc_comp_params_b p,

fnd_svc_components c

where c.component_type = 'WF_MAILER'

and v.component_id = c.component_id

and v.parameter_id = p.parameter_id

and p.parameter_name in

('OUTBOUND_SERVER', 'INBOUND_SERVER',

'ACCOUNT', 'FROM', 'NODENAME', 'REPLYTO','DISCARD' ,'PROCESS','INBOX', 'TEST_ADDRESS')

order by p.parameter_name;

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