3 Replies Latest reply on Oct 12, 2015 4:23 PM by Shabz

    APPS Read only schema creation in Oracle EBS R12.2

    Shabz

      Hi ,

      could anyone, let us know the process to create apps read only schema in Oracle EBS R12.2 with database 11.2.0.3.

      followed:

      ======

      bash $ sqlplus "/ as sysdba"

      SQL > create user appsro identified by appsro default tablespace APPS_TS_TX_DATA;

      SQL> grant connect, resource to appsro;

      SQL> grant create synonym to appsro;

      SQL> exit;

       

       

      bash $ sqlplus apps/******

      SQL>set head off

      SQL> set newpage none

      SQL> set pagesize 9999

      SQL> spool create_synonyms.sql

      SQL> select 'create synonym ' || OBJECT_NAME || ' for ' || OWNER ||'.' ||OBJECT_NAME || ';' from all_objects where OWNER not in ('SYS','SYSTEM') and OBJECT_NAME not like '%/%' and OBJECT_TYPE in ('TABLE','VIEW','SYNONYM');

      SQL> spool off

      SQL> spool grant_select.sql

      SQL> select 'grant select on '|| OWNER ||'.' ||OBJECT_NAME || ' to appsro;' from all_objects where OWNER not in ('SYS','SYSTEM') and OBJECT_NAME not like '%/%' and OBJECT_TYPE in ('TABLE','VIEW','SYNONYM');

      SQL> spool off

      SQL> exit;

       

      bash $ sqlplus "/as sysdba"

      SQL> @grant_select.sql

      SQL> exit;

       

      bash $ sqlplus appsro/appsro

      SQL> @create_synonyms.sql

      SQL> exit;

       

      But many synonyms creation failed while executing create_synonyms.sql. like

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

       

      after completion of script i am able to read APPS schema data like

       

      QL> desc fnd_products_installations;

      ERROR:

      ORA-04043: object fnd_products_installations does not exist

       

      SQL> select count(*) from dba_objects where status like 'INVALID';

      select count(*) from dba_objects where status like 'INVALID'

                          *

      ERROR at line 1:

      ORA-00942: table or view does not exist

      SQL> show user

      USER is "APPSRO

       

       

      shall we follow the same process like R12.1? or is there anyway different in R12.2.

       

      please suggest.

      Thanks