WebSphere Adapter for Oracle E-Business Suite
After you have deployed your outbound processing module to WebSphere® Process Server, test the assembled adapter application using the WebSphere Integration Developer integration test client. You test the Create operation first, and then test the Retrieve operation.
About this task
To test the create operation, create a customer entry that has two addresses and one phone number.How to perform this task
In Websphere Integration Developer, right-click the Oracle_Outbound module, and select Test > Test Module.
Item | Test value |
---|---|
Configuration | Default Module Test |
Module | Oracle_Outbound |
Component | JDBCOutboundInterface |
Interface | JDBCOutboundInterface |
Operation | createArIbm_C_Cust_Profile |
Set the attribute values for the Customer Profile object, which is the top-level object ArIbm_C_Cust_Profile. Because this example uses two addresses and one contact, you also need to set values for two child objects of the Addresses type and one child object of the Contacts type. The following tables provide the values for each object and indicate any restrictions, such as whether the value has to be unique.
Attribute | Value | Notes |
---|---|---|
Insert_update_flag | I | |
Orig_system_ customer_ref |
CustomerReference # | Use the value you recorded. The value must be unique. |
Customer_profile_ class_name |
DEFAULT | |
Credit_hold | N | |
Last_updated_by | -1 | |
Last_update_date | 2006-06-25 12:00:00 | Today's date and time. Does not have to be exact. |
Creation_date | 2006-06-25 12:00:00 | Today's date and time. Does not have to be exact. |
Created_by | -1 | |
Org_id | 204 |
The following table lists the values for the new element for the Addresses attribute.
Attribute | Value | Notes |
---|---|---|
Orig_system_ customer_ref |
CustomerReference# | Use the value that you recorded. The value must be unique. |
Site_use_code | BILL_TO | |
Orig_system_ address_ref |
AddressReference# | Use the value that you recorded. The value must be unique. |
Insert_update_flag | I | |
Customer_name | CustomerNameReference | Use the value that you recorded. The value must be unique. |
Customer_number | <null> | |
Customer_status | A | |
Primary_site_ use_flag |
Y | |
Location | <null> | |
Address1 | Test Address 1 | You have the option of using your own address information. |
Address2 | <null> | |
Address3 | <null> | |
Address4 | <null> | |
City | San Mateo | |
State | CA | |
Province | <null> | |
County | San Mateo | |
Postal_code | 94010 | |
country | US | |
Cust_category_code | CUSTOMER | |
Last_updated_by | -1 | |
Last_update_date | 2006-06-25 12:00:00 | Today's date and time. Does not have to be exact. |
Created_by | -1 | |
Creation_date | 2006-06-25 12:00:00 | Today's date and time. Does not have to be exact. |
Org_id | 204 | |
Customer_name_ phonetic |
CustomerNameReference | Use the value that you recorded. |
The following table lists the values for the second element for the Addresses attribute.
Attribute | Value | Notes |
---|---|---|
Orig_system_ customer_ref |
CustomerReference# | Use the value that you recorded. The value must be unique. |
Site_use_code | SHIP_TO | |
Orig_system_ address_ref |
AddressReference#2 | Use the value that you recorded. The value must be unique. |
Insert_update_flag | I | |
Customer_name | CustomerNameReference | Use the value that you recorded. The value must be unique. |
Customer_number | <null> | |
Customer_status | A | |
Primary_site_ use_flag |
Y | |
Location | <null> | |
Address1 | Test Address 2 | You have the option of using your own address information. |
Address2 | <null> | |
Address3 | <null> | |
Address4 | <null> | |
City | San Mateo | |
State | CA | |
Province | <null> | |
County | San Mateo | |
Postal_code | 94010 | |
country | US | |
Cust_category_code | CUSTOMER | |
Last_updated_by | -1 | |
Last_update_date | 2006-06-25 12:00:00 | Today's date and time. Does not have to be exact. |
Created_by | -1 | |
Creation_date | 2006-06-25 12:00:00 | Today's date and time. Does not have to be exact. |
Org_id | 204 | |
Customer_name_ phonetic |
CustomerNameReference | Use the value that you recorded. |
The following table lists the values for an element for the Contacts attribute.
Attribute | Value | Notes |
---|---|---|
Orig_system_ contact_ref |
<null> | |
Orig_system_ telephone_ref |
TelephoneReference# | Use the value that you recorded. The value must be unique. |
Orig_system_ customer_ref |
CustomerReference# | Use the value that you recorded. The value must be unique. |
Orig_system_ address_ref |
AddressReference#1 | Use the value that you recorded. The value must be unique. |
Insert_update_flag | I | |
Contact_first_name | <null> | |
Contact_last_name | <null> | |
Contact_title | <null> | |
Contact_job_title | <null> | |
Telephone | 5551212 | You have the option of using your own phone number. |
Telephone_extension | 1234 | Use <null> if you don't have one. |
Telephone_type | FAX | |
Telephone_area_code | 650 | |
Last_update_date | 2006-06-25 12:00:00 | Today's date and time. Does not have to be exact. |
Last_updated_by | -1 | |
Creation_date | 2006-06-25 12:00:00 | Today's date and time. Does not have to be exact. |
Created_by | -1 | |
Email_address | <null> | |
Org_id | 204 |
Log on to Oracle E-Business Suite and switch to the Receivables Manager responsibility. Navigate to the Customers > Standard menu to open the Find/Enter Customers window. Query for the imported customer.
You will use this customer number when you test the Retrieve operation.
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)