Creating Synonyms for E-Business Suite Tables

If a user other than the “apps” user is referenced, you can create synonyms for 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.