ADOP Prepare phase failed with below error while running autoconfig on Patch Edition.
Error:
ERROR at line 1:
ORA-20001: Synonym does not point to an editioning view: ADOP_VALID_NODES
ORA-06512: at “APPS.AD_ZD”, line 26
ORA-06512: at “APPS.AD_ZD_SEED”, line 65
ORA-06512: at “APPS.AD_ZD_SEED”, line 102
ORA-06512: at “APPS.AD_ZD_SEED”, line 1656
ORA-06512: at line 38
Cause :
The editioning view of ADOP_VALID_NODES doesn’t exist .
Solution :
Run the below procedure to create the synonym & editioning view of ADOP_VALID_NODES. Also any triggers & funtions that’s needed.
SQL> exec ad_zd_table.upgrade(‘APPLSYS’, ‘ADOP_VALID_NODES’);
PL/SQL procedure successfully completed.
You may run ADZDSHOWTAB.sql for ADOP_VALID_NODES , it will display the edition mapping of the table.