Monday 28 July 2014

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;




No comments:

Post a Comment