1 Reply Latest reply on Jun 22, 2016 10:15 AM by Kumar Vellaisamy

    APPS Read only schema creation steps for EBS R12.2.3

    Kumar Vellaisamy

      Hi,

       

      We are having a R12.2.3 ebs environment with 11.2.0.4 database.

       

      For creating a read only apps schema we have followed the steps from

      https://muneer2908.wordpress.com/tag/apps-read-only-schema-apps_read_only-appsro-database-objects-owned-by-apps-user-applications-oracle-apps-11i-r12-9i-10g/

       

      While running create synonym script we got the below mentioned error.

      ORA-38818: illegal reference to editioned object APPS.OE_ENDECA_FULFILL_DELAY_V..

       

      Regards

      Kumar Vellaisamy

        • 1. Re: APPS Read only schema creation steps for EBS R12.2.3
          Kumar Vellaisamy

          Hi,

           

          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.


          sqlplus SYSTEM

          SQL> alter session set current_schema=APPS;

          SQL> exec AD_ZD_PREP.ENABLE_CUSTOM_USER('APPSRO;


          It works for me.

           

          Regards

          Kumar Vellaisamy