fnd concurrent request queues and logs update

 

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;