POST CLONE STEPS in 11i/R12:
++++++++++++++++++++++++++++++++++++++++++
1.select distinct OUTFILE_NODE_NAME from FND_CONCURRENT_REQUESTS ;
2.select distinct LOGFILE_NODE_NAME from FND_CONCURRENT_REQUESTS ;
3.select node_name , status from fnd_nodes
CHECK ALL THE NODE NAMES IF YOU FOUND ANY SOURCE NODE NAMES THEN FOLLOW THE STEPS BELOW.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++==
1. Make a backup copy of the FND_RUN_REQUESTS, FND_CONCURRENT_REQUESTS, and
FND_CONCURRENT_PROCESSES tables
2. Run the following statements to remove the rows that refer to the node that
is no longer available.. (ERP is an example value)
delete FND_RUN_REQUESTS WHERE parent_request_id
in (select request_id from FND_CONCURRENT_REQUESTS where
upper(LOGFILE_NODE_NAME) = 'ERP'
or upper(OUTFILE_NODE_NAME) = 'ERP');
delete FND_CONCURRENT_REQUESTS where upper(LOGFILE_NODE_NAME) = 'ERP' or
upper(OUTFILE_NODE_NAME) = 'ERP';
delete FND_CONCURRENT_PROCESSES where upper(NODE_NAME) = 'ERP';
commit;
++++++++++++++++++++++++++++++++++++++++++
1.select distinct OUTFILE_NODE_NAME from FND_CONCURRENT_REQUESTS ;
2.select distinct LOGFILE_NODE_NAME from FND_CONCURRENT_REQUESTS ;
3.select node_name , status from fnd_nodes
CHECK ALL THE NODE NAMES IF YOU FOUND ANY SOURCE NODE NAMES THEN FOLLOW THE STEPS BELOW.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++==
1. Make a backup copy of the FND_RUN_REQUESTS, FND_CONCURRENT_REQUESTS, and
FND_CONCURRENT_PROCESSES tables
2. Run the following statements to remove the rows that refer to the node that
is no longer available.. (ERP is an example value)
delete FND_RUN_REQUESTS WHERE parent_request_id
in (select request_id from FND_CONCURRENT_REQUESTS where
upper(LOGFILE_NODE_NAME) = 'ERP'
or upper(OUTFILE_NODE_NAME) = 'ERP');
delete FND_CONCURRENT_REQUESTS where upper(LOGFILE_NODE_NAME) = 'ERP' or
upper(OUTFILE_NODE_NAME) = 'ERP';
delete FND_CONCURRENT_PROCESSES where upper(NODE_NAME) = 'ERP';
commit;
No comments:
Post a Comment