Materialized view is giving error ORA-38818: illegal reference to editioned object AR.HZ_CUST_ACCOUN
We are in process of upgrade from 11.5.10 to R12.2.5.
Compilation of Materialized view is giving error mentioned below..
Error report -
SQL Error: ORA-38818: illegal reference to editioned object AR.HZ_CUST_ACCOUNTS#
38818. 00000 - "illegal reference to editioned object %s.%s"
*Cause: An attempt was made to violate the rule "A noneditioned object
may not depend on an editioned object."
*Action: Either make this object editioned; or do not make the illegal
reference.
Metalized view compilation script is as below...
CREATE MATERIALIZED VIEW XXIT.XXIT_CUST_TEMP_MV
TABLESPACE XXINDEX
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED