Creating Data Servers and Physical Schemas for Oracle E-Business Suite

  To create a data server for each of the related logical schemas:

  1. Launch Oracle Data Integrator Topology Manager, then select the Physical Architecture tab.

  2. Expand Oracle E-Business Suite.

  3. Expand Oracle.

  4. Right-click and select Insert Data Server.

  5. Enter a name and connection information on the Definition tab, then the JDBC driver and the APPS JDBC URL. Then, click Apply or OK.

  6. Optional: Change the value for Application on the physical schema dialog box. (The value should be “APPS” for E-Business Suite.)

  7. Click OK twice to save.

  8. Ensure that you have created all data servers and physical schemas listed in Creating Data Servers and Physical Schemas. Then, create contexts. See Creating Contexts.