APPS.AD_ZD_MVIEW error
when using exec ad_zd_mview.upgrade to upgrade an MV from a view on EBS 12.2.4, we are getting the below error:
ORA-00980: synonym translation is no longer valid
ORA-06512: at "SYS.DBMS_SQL2", line 214
ORA-06512: at "APPS.AD_ZD_MVIEW", line 206
ORA-06512: at "APPS.AD_ZD_MVIEW", line 1275
ORA-06512: at "APPS.AD_ZD_MVIEW", line 1620
ORA-06512: at "APPS.AD_ZD_MVIEW", line 577
ORA-06512: at "APPS.AD_ZD_MVIEW", line 709
ORA-06512: at "APPS.AD_ZD_MVIEW", line 1129
ORA-06512: at "APPS.AD_ZD_MVIEW", line 1865
ORA-06512: at line 1