Create Materialized View Fails With ORA-30372

[David Purge]

Hi Erman,

While I create MV i get an error ORA-30372,after that I had grant EXEMPT ACCESS POLICY to apps
But now I'am getting ORA-38818: illegal reference to editioned object XLE.XLE_ENTITY_PROFILES#

ı checked SELECT username,editions_enabled
FROM   dba_users where username='XLE' and 'APPS'  it returned Y.


I am trying with apps;

and here is my create script;

Create materialized view APPS.XXPC_SLA_GMF_FISLER_MV
BUILD IMMEDIATE
refresh complete
START WITH (sysdate) --+0.1/24
NEXT (sysdate) + 1
AS
SELECT *
from APPS.XXPC_SLA_GMF_FISLER_V

[ErmanArslansOracleBlog]

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.