WebSphere Adapter for Oracle E-Business Suite

Testing the Create operation

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

  1. Select the module to test

    In Websphere Integration Developer, right-click the Oracle_Outbound module, and select Test > Test Module.

  2. Set the test values
    In the Oracle_Outbound_Test window, use the arrows to set the test values shown in the following table.
    Table 1. Test values for the Create operation
    Item Test value
    Configuration Default Module Test
    Module Oracle_Outbound
    Component JDBCOutboundInterface
    Interface JDBCOutboundInterface
    Operation createArIbm_C_Cust_Profile
  3. Set attribute values for the input business object

    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.

    Oracle requires ID values for import. These values represent the corresponding ID values for the objects in the system from which the objects originate. The ID values are used in multiple objects, so you need to record the values you will use to be able to enter them consistently for the different objects. For each of the following five values, create unique string values.
    • CustomerReference#
    • AddressReference#1
    • AddressReference#2
    • TelephoneReference#
    • CustomerNameReference
    Note: For more information on required values and other allowed values for data in the Oracle interface tables, refer to your documentation for Oracle Applications, specifically the Oracle Receivables User Guide.
    1. Set the verb to Create.
    2. In the Events window of the Assembly Diagram, under Initial request parameters, click the Value column across from the name of each attribute whose value you need to set, and enter the value from the following tables.
      Figure 1. Attribute values
      This image is described in the surrounding text.
      Note:
      • To set a value for an attribute to <null>, click the value field for the attribute. Click the arrow, and select <null> from the list.
      • To add a child object, right-click the attribute of the appropriate type and choose Add Element. Enter the number of elements you are adding for each attribute. In this sample, enter 2 when you add elements for the attribute ArIbm_R_Cust_Interface_All because there are two child objects of that type (two addresses), and enter 1 when you add elements for the attribute ArIBM_C_Contacts because there is one child object of that type (one contact).
      Figure 2. Using Add Element to add a child object
      This image is described in the surrounding test.
      Table 2. Values for the top-level object
      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.

      Table 3. 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.

      Table 4. 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.

      Table 5. 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  
  4. Click Continue. From the Deployment Location window, select the name of the server where your module will be deployed, and click Finish. The Starting the Integration Test Client window is displayed briefly.
  5. Verify that the customer has been imported properly

    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.

    Note: For specific information about using the Oracle interface, refer to your documentation for Oracle Applications.
  6. Write down the customer number displayed in the customer screen in Oracle.

    You will use this customer number when you test the Retrieve operation.

Related reference
Troubleshooting information for the sample applications

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)