user6445925 wrote:You do not need to apply the patch, just purge/clean the table as per [ID 260887.1], then run AutoConfig on the database and the application tier nodes and check the contents of the table then.
All good except when I happened to check autoconfig I see it still shows old 11.1 database context file entry and my new 11.2 file.
In the 11i world you pointed me to "How to Clean Nonexistent Nodes or IP Addresses From FND_NODES [ID 260887.1]" but that file seems to be for 11i.
Do I still need to apply that patch  in R12 and then EXEC FND_CONC_CLONE.SETUP_CLEAN;?
Here's my fnd_Nodes output (not sure how it's supposed to look):
Node Name M C W A F
------------------------------ - - - - -
AUTHENTICATION O N N N N
DBTIER O N N N N
APPTIER O Y Y Y Y
user6445925 wrote:You're welcome!
Much better, all nice and tidy like.
Thanks again Hussein, not sure what I would do without your help sometimes.