Post Clone Steps (Updating the Tables)

In This blog I discuss some points of post clone activities of Oracle Applications. We need to update certain fields of certain tables after our cloning completes. Here are the values:

update wf_notification_attributes set text_value=replace(text_value,

'http:// prod.domain:8000/pls/prod','http://clone.domain:8036/pls/test') where text_value like '%http://prod.domain:8000/pls/prod%'; update wf_notification_attributes set text_value=replace(text_value,'http:// prod.domain:8000','http:// clone.domain:8036') where text_value like '%http://prod.domain:8000%'; update wf_notification_values set text_value=replace(text_value,'http:// prod.domain:8000','http://clone.domain:8036') where text_value like '%http://umappprod.umniah.com:8000%'; update wf_notification_values set text_value=replace(text_value,'prod','clone') where text_value like '%clone%'; update wf_agents set address=replace(address,'prod','clone') where text_value like '%prod%'; update wf_systems set name='clone', DISPLAY_NAME='clone' where name like '%prod%'; where clone is the new cloned instance and prod is the source instnace.

Even then if you have problems in fixing the Workflow, then recreate the service component containers from the scripts below:

Run these scripts in directory $APPL_TOP/fnd/11.5.0/patch/115/sql

to get the service component containers back up and running in the following order after shutting down the apps after cloning: wfntfqup.sql wfqidxc2.sql wfquec2.sql wfjmsqc2.sql wfbesqc.sql Also Please run cmclean.sql and fnd_conc_clone.setup_clean as APPS before starting the cloning on target server. Balaji R S