APPS.ad_zd_mview.upgrade('APPS','OE_ITEMS_MV'); Failed ORA-00904: "B"."INVENTORY_ITEM_ID": invalid i
I am upgrading from 12.1.3 to 12.2.7.
Completed 12.2 upgrade and enabled Online Patching by applying Patch 13543062
But when running the report adzdexrpt, I am getting the following errors
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 10211 ERROR begin ORA-22818: subquery expressions not allowed here
APPS.ad_zd_mview.upgrade('APPS','MRP_COMPANY_USERS
_SN'); end;UPGRADE_MVIEW 10250 ERROR begin ORA-00904: "B"."INVENTORY_ITEM_ID": invalid
APPS.ad_zd_mview.upgrade('APPS','OE_ITEMS_MV'); identifier
Tagged:
1