We are having a R12.2.3 ebs environment with 126.96.36.199 database.
For creating a read only apps schema we have followed the steps from
While running create synonym script we got the below mentioned error.
ORA-38818: illegal reference to editioned object APPS.OE_ENDECA_FULFILL_DELAY_V..
A custom / read-only schema can be created in 12.2.x the same way as it has been done so far for the previous releases (11i / R12).
The only difference in 12.2 is that the custom schema should be registered with EBS or it has to be manually enabled for editions.
If Online Patching Enablement has already been enabled:
Before running create synonym.sql script need to do the below steps.
SQL> alter session set current_schema=APPS;
SQL> exec AD_ZD_PREP.ENABLE_CUSTOM_USER('APPSRO;
It works for me.