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.
- 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."
- Select the module to test
In the Business Integration
perspective of WebSphere® Integration
Developer, right-click the Oracle_Outbound module and
select .
- 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 operationItem |
Test value |
Configuration |
Default Module Test |
Module |
Oracle_Outbound |
Component |
JDBCOutboundInterface |
Interface |
JDBCOutboundInterface |
Operation |
retrieveArIbm_R_Cust_Accounts |
- 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.
- Verify that the returned object matches the customer information
that was imported into the Oracle interface tables.