WebSphere Adapter for Oracle E-Business Suite

Selecting the business objects and services

After configuring connection properties, run a query for database objects. Browse the metadata tree structure to understand the structure of the objects in the enterprise information system (EIS) and select objects needed for the service description. For this sample, you run a query on the accounts receivable (AR) schema and select synonyms that represent the Oracle E-Business Suite interface tables.

How to perform this task

  1. Specify filter properties

    In the Find and Discover Enterprise Services window, click Edit Query. In the Query Filter Properties window, type AR in the Schema Name Filter property field to display the accounts receivable (AR) schema.

    The Types property field lists the entries: tables, views, stored procedures, and synonyms/nicknames. You can add or remove nodes from that list.

    Select the Add Business Object ASI check box, and click OK. Now whenever you add an object when you run the metadata query in step 2, a window called Configuration Parameters for (name of object) opens for entering application-specific information.

  2. Run the metadata query
    1. Display objects covered by the query

      Click Execute Query. The AR schema and data elements of the schema are displayed in the top pane.

    2. Select the object for import

      Expand the AR schema. Expand Synonyms - Nick Names

      Highlight the synonym IBM_C_CUST_PROFILE, and click Add to Import List to select this object to be imported.

    3. Add business object application-specific information

      Clink Add in the Configuration Parameters for IBM_C_CUST_PROFILE window.

      Select AfterCreateSP and click OK in the Add window.

      In the AfterCreateSP area of the Configuration Parameters for IBM_C_CUST_PROFILE window, set the following values:
      • Type APPS in the Schema Name Filter field.
      • Select APPS from the Schema list.
        Note: There may be long delay after selecting the APPS schema before the SP Name Filter field is active.
      • Type IBM_WEBSPHERE_CUSTOMER_IMP in the SP Name Filter field.
      • Select IBM_WEBSPHERE_CUSTOMER_IMP from the Stored Procedure list.

      Click OK.

      After a delay, the selected object is displayed in the bottom pane.

      In this sample, you process data using Oracle's built-in Interface and Base tables. Only the Create operation is necessary to post both new customer data and updates to existing customer data. As part of calling the Create operation of the object, the stored procedure IBM_WEBSPHERE_CUSTOMER_IMP is run using the AfterCreateASI value for the object to process. This stored procedure moves the data from the Interface to the Base tables.

    4. Select remaining synonyms

      Select each of the remaining synonyms (see the following list) and click Add. When the Configuration Parameters for (name of object) window opens, just click OK. Do not add the AfterCreateSP value.

      When you are finished, click Next.

      The remaining synonyms are as follows:
      1. AR.IBM_C_CUST_INTERFACE
      2. AR.IBM_C_CUST_BANKS
      3. AR.IBM_C_CONTACTS
      4. AR.IBM_C_PAY_METHODS
      5. AR.IBM_R_CUST_PROFILES
      6. AR.IBM_R_CUST_ACCOUNTS
      7. AR.IBM_R_PARTIES
      8. AR.IBM_R_ACCT_SITES
      9. AR.IBM_R_SITE_USES
      10. AR.IBM_R_PARTY_SITES
      11. AR.IBM_R_LOCATIONS
      12. AR.IBM_R_CONTACTS_CUSTOMER
      13. AR.IBM_R_CONTACTS_SITES

      For information on the object-level, verb, and attribute application-specific information, refer to "Application-specific information" in IBM WebSphere Adapters: Adapter for JDBC User Guide. To view that documentation, see http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/topic/com.ibm.wsadapters602.jca_jdbc.doc/doc/stjdb_welcome.html.

.

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)