Difference between fnd_conc_clone.setup_clean and cmclean

Hi DBA-Mates, Hope you all are doing great!!!

What is difference between fnd_conc_clone.setup_clean and cmclean.sql, I got same questions in email and comment box.

So, we decided to clear the points which may useful here. It may easy/simple but hope useful for those who have requested.

FND_CONC_CLONE.SETUP_CLEAN Details:

Here, fnd_conc_clone is package name and setup_clean it is procedure name.

When we run fnd_conc_clone.setup_clean it deletes the information from the below tables such as:

fnd_nodes table in the target to clear source node information as it is a part of cloning.

It deletes the information from fnd_concurrent_queue_size , fnd_concurrent_queues_tl and

It deletes the information from fnd_concurrent_queues,
Delete from fnd_nodes;

Please find the below Syntax:

$sqlplus apps/<apps_password>

SQL> exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

Note: Post  run the Autoconfig on DB tier and middle tier this will register the nodes in fnd_nodes tables.

CMCLEAN.sql Details:

Actually, we run it to cleanup the running and pending requests, because if we stop concurrent managers forcefully or by abort then concurrent requests/process may be in running state.

But when we start concurrent manager the processes may or may not start properly, sometimes due to old running process CM will not come Up. And also we should not kill the process in PROD.

Better to wait for some time or kill the process if there is no other option. There is also a way to kill process , we need to check and verify what process is doing and as it is child or parent process etc...

As per our real time experiences we/anyone should recommend as always bring down the CM /Apps then only run cmclean otherwise it may cause issue such as holding lock on tables.

It may not able to delete the rows from the concurrent manager process and request tables which are in use.

CMCLEAN will update below tables:

1) FND_CONCURRENT_QUEUES

2) FND_CONCURRENT_PROCESSES

3) FND_CONCURRENT_REQUESTS

4) FND_CONFLICTS_DOMAIN

5) FND_CONCURRENT_CONFLICT_SETS

cmclean.sqlscript and details (please find here… >>)

Some more useful links:

ORACLE APPS DBA INTERVIEW QUESTIONS AND ANSWERS LATEST ON 31stAug2018

Concurrent Managers are down error insert_fcp failed due to ORA-01403 no data found,ORA-06512

How to Duplicate a database using RMAN backup

R12.2 Cloning Steps

Regards,