WebSphere Adapter for Oracle E-Business Suite

Testing the Retrieve operation

After you have tested the Create operation and verified that the imported customer is in the Oracle E-Business Suite Interface tables, test the Retrieve operation.

How to perform this task

  1. Obtain a customer account ID value

    Start the SQL*Plus tool, or a similar program for processing SQL commands.

    Run this query: SQL> select cust_account_id from ar.hz_cust_accounts where account_number = customer number;

    where customer number is the number you wrote down when you verified the imported customer in Oracle E-Business Suite in step 5 of the section "Testing the Create Operation."

    Write down the cust_account_id value from this query for use in step 4, "Set the attribute value for the input business object."

  2. Select the module to test

    In the Business Integration perspective of WebSphere® Integration Developer, right-click the Oracle_Outbound module and select Test > Test Module.

  3. Set the test values
    In the Oracle_Outbound_Test window, use the arrows to set the test values, which are provided in the following table:
    Table 1. Test values for the Retrieve operation
    Item Test value
    Configuration Default Module Test
    Module Oracle_Outbound
    Component JDBCOutboundInterface
    Interface JDBCOutboundInterface
    Operation retrieveArIbm_R_Cust_Accounts
  4. Set the attribute value for the input business object

    In the Events window of the Assembly Diagram, under Initial request parameters, click the Value column across from the name of the custaccountid attribute. Set the value to match the cust_account_id value from the SQL query you ran in step 1,"Obtain customer account ID value."

    Do not change the default settings for the remaining values.

    Click Continue. From the Deployment Location window, select the name of the server where the object will be deployed, and click Finish. The Starting the Integration Test Client window is displayed as the object is being processed.

  5. Verify that the returned object matches the customer information that was imported into the Oracle interface tables.

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)