Issue:
======
SQL> @create_synonyms.sql
But many synonyms creation failed while executing create_synonyms.sql. like
ORA-38818: illegal reference to editioned object APPS.OE_ENDECA_FULFILL_DELAY_V..
Solution:
========
Before running create_synonym pls do the below steps.
sqlplus SYSTEM/manager
SQL> alter session set current_schema=APPS;
SQL> exec AD_ZD_PREP.ENABLE_CUSTOM_USER('CUSTOM_SCHEMA');
run the synonym script.
Ref: Create And Register CUSTOM Schema On EBS 12.2 (Doc ID 1929668.1)
======
SQL> @create_synonyms.sql
But many synonyms creation failed while executing create_synonyms.sql. like
ORA-38818: illegal reference to editioned object APPS.OE_ENDECA_FULFILL_DELAY_V..
Solution:
========
Before running create_synonym pls do the below steps.
sqlplus SYSTEM/manager
SQL> alter session set current_schema=APPS;
SQL> exec AD_ZD_PREP.ENABLE_CUSTOM_USER('CUSTOM_SCHEMA');
run the synonym script.
Ref: Create And Register CUSTOM Schema On EBS 12.2 (Doc ID 1929668.1)
Useful one. I got similar error today and is resolved with your solution. Thanks a lot
ReplyDeleteHello,
ReplyDeleteI am facing ORA-38818: illegal reference to editioned object APPS.MTL_ONHAND_QUANTITIES
while creating materialized view and edition is enabled what can i do to create MV?
Regards