Creating Synonyms for EBS Tables

If a user other than the “apps” user is referenced, you can create synonyms for EBS tables.

  To create synonyms for EBS Tables:

  1. Create synonyms for the EBS tables listed in this appendix.

  2. Assign read access to all the synonyms that you created.

  3. Assign write access to the following tables:

    • GL_Interface

    • GL_Budget_Interface

    • GL_Track_Delta_Balances

    In ODI Topology for EBS_Data_Server, you can use the synonym for both the user and the schema.