There are two steps to create Materialized Views in 12.2 Create Logical View Upgrade to Materialized View Create Logical View CREATE OR REPLACE <Custom Schema>.XXBLOG_CREATE_LOGICAL_MV# AS <SELECT Statement>; Upgrade Logical View to Materialized View exec ad_zd_mview. upgrade('<custom schema>', 'XXBLOG_CREATE_LOGICAL_MV'); How to check if the Materialized Views got created properly in 12.2 SELECT object_type, object_name FROM dba_objects WHERE object_name like 'XXBLOG_CREATE_LOGICAL_MV%'; -- 4 rows Selected These 4 Rows get created in the process for Logical View (Ending with '#') in Custom Schema Materialized View in Custom Schema Table in Custom Schema Synonym in APPS Possible Issue: Create mview gives the following error when the mview definition query refers to editioned function: ORA-38818: illegal reference to editioned object %.% Possible Solution: Re-create the referenced pl/sql objects in a sche