When running adop phase=prepare, this error is shown: [UNEXPECTED]Nodes “xxxxxx” are listed in the ADOP_VALID_NODES table but not in the FND_NODES table. This is how to fix it:
Logon to sqlplus as applsys: sqlplus applsys
On sqlplus:
truncate table fnd_oam_context_files;
truncate table fnd_nodes;
truncate table adop_valid_nodes;
Run autoConfig on the DB tier
Run autoconfig on the run file system
Logon to sqlplus as system: alter trigger ebs_logon disable;
Run Autoconfig on the patch file system
Logon to sqlplus as system: alter trigger ebs_logon disable;