Wednesday, 4 April 2018

Post Clone WF

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

select text_value from wf_notification_attributes;

2.

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

select text_value from wf_notification_attributes;

3.
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%';

select text_value from wf_notification_values;
4.

update wf_notification_values set text_value=replace(text_value,'prod','clone') where text_value like '%clone%';

5.
update wf_agents set address=replace(address,'prod','clone') where text_value like '%prod%';

select address from wf_agents;

6.
update wf_systems set name='clone', DISPLAY_NAME='clone' where name like '%prod%';

select name,DISPLAY_NAME from wf_systems;

===============================
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.

No comments:

Post a Comment