Issue with MVIEW MSD_DEM_OBI_DEMANTRA_MV after Online Patching Enablement patch: 13543062
Running ADZDEXRPT.sql & ADZDPAUT.sql after applying "Online Patching Enablement patch: 13543062:R12.AD.C" patch shows
DOC>
DOC> *************************************************************
DOC> SECTION 3
DOC> *************************************************************
DOC> Failed Jobs with ERRORS, For complete error stack and DDL,
DOC> Please check AD_ZD_DDL_HANDLER table for corresponding DDL_ID
DOC>
DOC>#
Phase DDL ID Status SQL Error
-------------------- ------------ ------------ -------------------------------------------------- --------------------------------------------------
UPGRADE_MVIEW 11500 ERROR begin ORA-00942: table or view does not exist
APPS.ad_zd_mview.upgrade('APPS','MSD_DEM_OBI_DEMAN
TRA_MV'); end;
DOC>
DOC> **********************************************************************
DOC> SECTION-6
DOC> **********************************************************************
DOC>
DOC> AUTO FIX: Materialized Views
DOC> - Will convert with equivalent EXPANDED QUERY