ADOP Prepare phase failed with below error while running autoconfig on Patch Edition.


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.


Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search