ADOP fails with [ERROR] ETCC not run in the database node DBHOSTNAME in R12.2

 Error:-

1- adop phase=prepare.

[ERROR]     ETCC not run in the database node prerptdb01
                The EBS Technology Codelevel Checker needs to be run on the database node.
                It is available as Patch 17537119.
    Encountered the above errors when performing database validations.
    Resolve the above errors and restart adop 

Solution:-

1- It might be due to mismatch in host name between APPS.FND_NODES and APPLSYS.TXK_TCC_RESULTS tables.

2-  Take backup of APPLSYS.TXK_TCC_RESULTS

create table APPS.TXK_TCC_RESULTS_backup as select * from APPLSYS.TXK_TCC_RESULTS;

3- Truncate APPLSYS.TXK_TCC_RESULTS table.

truncate table  APPLSYS.TXK_TCC_RESULTS

4-  UPDATE applsys.txk_tcc_results SET node_name ='<node name>';