0 Replies Latest reply on Oct 9, 2015 2:39 AM by NeerajShri

    R12.2 Standard for custom schema.

    NeerajShri

      Hi All,

       

      Need your help to confirm the following R12.2 standard.

       

      From a custom schema if we need to access a table present in APPS schema, the R12.2 standard is to access

      it using the private synonym defined in that particular custom schema and use that synonym in the SQL\PL\SQL statements.

       

      For example : If my custom schema is XXPO and has the Grant to access PO HEADERS_ALL present in APPS.

      We will create a private synonym in XXPO and use the synonym directly from XXPO schema.

       

      CREATE SYNONYM XXPO.PO_HEADERS_ALL for APPS.PO_HEADERS_ALL

       

      Can you please let me know if my understanding is correct.


      Thanks,

      Neeraj.