EBS Customizations (MOSC)

MOSC Banner

Materialized view is giving error ORA-38818: illegal reference to editioned object AR.HZ_CUST_ACCOUN

edited Sep 9, 2020 10:06AM in EBS Customizations (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center