Re: Create Materialized View Fails With ORA-30372

Posted by ErmanArslansOracleBlog on Nov 04, 2015; 6:18am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Create-Materialized-View-Fails-With-ORA-30372-tp434p436.html

This error is caused by the statement : " the mview is a noneditionable object and a noneditioned object cannot depend on an editioned object.".

XLE.XLE_ENTITY_PROFILES# is an editioned object and your view named APPS.XXPC_SLA_GMF_FISLER_V probably using that one.

The correct procedure for MV creation in EBS 12.2 is explained in: Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1), exactly in "section 1.4.2.5: Materialized Views".

Please review that note.