Creating Synonyms for E-Business Suite Tables

If a user other than the "apps" user is referenced, you can create synonyms for Oracle E-Business Suite tables.

Note:

Synonyms are required for a PeopleSoft setup since PeopleSoft administrators typically do not provide PeopleSoft schema applications to users for configurations.

To create synonyms for E-Business Suite tables:

1. Create synonyms for the E-Business Suite 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.