- Run FND_CONC_CLONE.SETUP_CLEAN;
- Run cmclean.sql
- Run autoconfig on both DB and APPS tier.
- Run adstartal.sh start apps/apps
You need to perform node cleanup as per standard practice after cloning PRD environment to Test/Dev.
SQL> Run FND_CONC_CLONE.SETUP_CLEAN;
Run autoconfig on both DB and APPS tier respectively and the start application tier services.
Query FND_NODES again and see if it populates correct values for the Cloned environment.
I hope this helps you solve your problem.
Since we don't know his EBS version, it is safer to hold the suggestion to run cmclean.sql since it is not supported in 12.2.
Thanks for suggesting me.