WebSphere Adapter for Oracle E-Business Suite

Preparing for outbound processing

You must run SQL script files to prepare for outbound processing. You need to create synonyms to save you time later when you generate business objects from the Oracle E-Business Suite database. You also need to insert artifacts into Oracle E-Business Suite before you can process objects using the database tables.

How to perform this task

  1. Create synonyms

    Open the SQL*Plus tool (or similar program for processing SQL statements). Log on to SQL*Plus using a database account that has been granted database administrator (DBA) rights.

    Run the file ibm_create_synonyms.sql.

    For example: SQL> @C:\samplecontent\ibm_create_synonyms.sql.

    The size of the database and number of database artifacts in the Oracle E-Business Suite database can lengthen the process of searching through large lists when running the enterprise service discovery wizard to generate objects. Creating the synonyms will help to make the search quicker. In addition, the synonyms help resolve an issue related to the Oracle database driver. The issue is documented in IBM® technote 1218775.

  2. Insert artifacts into Oracle E-Business Suite

    Before you process business objects, run the SQL script ibm_submit_request.sql.

    This places a stored procedure called IBM_WEBSPHERE_CUSTOMER_IMP into the Oracle APPS schema. This procedure is used to move customer data from the Oracle interface tables to the base tables. You will use the interface tables when you construct the Create business object.


Terms of use |

Last updated: Mon 30 Oct 2006 03:46:26

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)