create table apps.fnd_concurrent_queues_oci as select * from apps.fnd_concurrent_queues;
create table fnd_concurrent_requests_oci as select * from fnd_concurrent_requests;
create table xxau_fnd_concurrent_requests_oci as select * from xxau_fnd_concurrent_requests;
create table fnd_conc_req_outputs_oci as select * from apps.fnd_conc_req_outputs;
select CONCURRENT_QUEUE_NAME,NODE_NAME,NODE_NAME2,target_node from fnd_concurrent_queues_oci ;
select CONCURRENT_QUEUE_NAME,NODE_NAME,NODE_NAME2,target_node from fnd_concurrent_queues ;
select 'update fnd_concurrent_queues set node_name='''||NODE_NAME||''',NODE_NAME2='''||NODE_NAME2||''',TARGET_NODE='''||TARGET_NODE||''' where CONCURRENT_QUEUE_NAME ='''||CONCURRENT_QUEUE_NAME||''';' from fnd_concurrent_queues_oci;
col CONCURRENT_QUEUE_NAME for a20
set pages 500 lines 500
col 'Target_Node' for a20
col 'Node_Name' for a20
col 'Node_name2' for a20
select CONCURRENT_QUEUE_NAME,NODE_NAME,NODE_NAME2,target_node from fnd_concurrent_queues;
select CONCURRENT_QUEUE_NAME,TARGET_NODE,NODE_NAME,NODE_NAME2,RUNNING_PROCESSES,PCP_FLAG from fnd_concurrent_queues;
select CONCURRENT_QUEUE_NAME,TARGET_NODE,NODE_NAME,NODE_NAME2,RUNNING_PROCESSES,PCP_FLAG from fnd_concurrent_queues where target_node is not null;
update fnd_concurrent_queues set node_name='ASBAVEBSPRD17',NODE_NAME2='ASBAVEBSPRD18',TARGET_NODE='ASBAVEBSPRD17' where CONCURRENT_QUEUE_NAME in ( 'FNDICM','STANDARD','PASMGR','INVMGR','MRPMGR','WFALSNRSVC','WFMLRSVC','XDP_MANAGER','IEU_WL_CS','OKCCONCMGR','IEXCONMGR','OAMCOLMGR','WFWSSVC','FNDCPOPP','IEU_SH_CS','WFMGSMS','WFMGSMD','WMSTAMGR','CMICRM','FTE_TXN_MANAGER','AMSDMIN','FNDCRM','FNDSCH','PODAMGR','RCVOLTM','INVTMRPM','CRPINQMGR');
update fnd_concurrent_queues set node_name='ASBAVEBSPRD18',NODE_NAME2='ASBAVEBSPRD17',TARGET_NODE='ASBAVEBSPRD18' where CONCURRENT_QUEUE_NAME in ( 'XX_AU_MGR','XXSTD_ASC_DBMSPIPE');
Commit;
select CONCURRENT_QUEUE_NAME, CONTROL_CODE , TARGET_NODE, NODE_NAME,NODE_NAME2 from FND_CONCURRENT_QUEUES where concurrent_queue_name like 'XX_AU_MGR%';
select CONCURRENT_QUEUE_NAME,TARGET_NODE,NODE_NAME,NODE_NAME2,RUNNING_PROCESSES,PCP_FLAG from fnd_concurrent_queues where target_node is not null;
select distinct(TARGET_NODE)from fnd_concurrent_queues where target_node is not null;
select distinct(NODE_NAME)from fnd_concurrent_queues where target_node is not null;
select distinct(NODE_NAME2)from fnd_concurrent_queues where target_node is not null;
update fnd_concurrent_queues set target_node='ASBAVEBSPRD17' where target_node='IRXVLP0628';
update fnd_concurrent_queues set node_name='ASBAVEBSPRD17' where node_name='IRXVLP0628';
update fnd_concurrent_queues set node_name2='ASBAVEBSPRD17' where node_name2='IRXVLP0628';
update fnd_concurrent_queues set target_node='ASBAVEBSPRD18' where target_node='IRXVLP0629';
update fnd_concurrent_queues set node_name='ASBAVEBSPRD18' where node_name='IRXVLP0629';
update fnd_concurrent_queues set node_name2='ASBAVEBSPRD18' where node_name2='IRXVLP0629';
select distinct(logfile_node_name) from fnd_concurrent_requests;
LOGFILE_NODE_NAME
----------------------------------------------------------------------------------------------------
ASBAVEBSDEV04
ASBAVEBSDEV03
ASBAVEBSI1B04
ASBAVEBSI1B03
IRXVLP0628
IRXVLP0629
select distinct(outfile_node_name) from fnd_concurrent_requests;
select distinct(logfile_node_name) from fnd_concurrent_requests;
select distinct(NODE_NAME1) from fnd_concurrent_requests;
select distinct(NODE_NAME2) from fnd_concurrent_requests;
update fnd_concurrent_requests set logfile_node_name='ASBAVEBSPRD17' where logfile_node_name='IRXVLP0628';
update fnd_concurrent_requests set logfile_node_name='ASBAVEBSPRD18' where logfile_node_name='IRXVLP0629';
update fnd_concurrent_requests set outfile_node_name='ASBAVEBSPRD17' where outfile_node_name='IRXVLP0628';
update fnd_concurrent_requests set outfile_node_name='ASBAVEBSPRD18' where outfile_node_name='IRXVLP0629';
update fnd_concurrent_requests set NODE_NAME1='ASBAVEBSPRD17' where NODE_NAME1 in ('IRXVLP0628');
update fnd_concurrent_requests set NODE_NAME1='ASBAVEBSPRD18' where NODE_NAME1 in ('IRXVLP0629');
commit;
