WebSphere Adapter for Oracle E-Business Suite

Building objects for Retrieve operation

To build the business objects for the Retrieve operation, you must establish a relationship between the parent and child business objects. The Adapter for JDBC processes the business objects by retrieving rows in the corresponding Oracle E-Business Suite base tables.

About this task

Use the steps described in this procedure to build a top-level object and add its child objects, and to build the remaining objects for the Retrieve operation. After you have built the top-level object, use information in the provided table to add child objects and set Foreign Key values.

How to perform this task

  1. Select a top-level object

    From the Business Integration perspective in WebSphere® Integration Developer, expand the Oracle_Outbound module.

    Expand Data Types. Double-click the ArIbm_R_Cust_Accounts object.

  2. Set the Primary key value for the object

    In the Business Object window, click the cust_account_id attribute.

    In the Properties view, click the Application Info tab.

    In the Attribute – cust_account_id window, in the ASI element properties box, in the column to the right of jdbcasi:PrimaryKey, change the value to true.

    Figure 1. Setting the Primary key
    This image is described in the surrounding text.
  3. Add the first child business object
    1. At the top of the Business Object window, click the button to add an attribute to a business object.
    2. In the Properties view, click the Description tab, and enter the values for the attribute.
      • In the Name field, type Profiles.
      • In the Type field, use the arrows to select ArIbm_R_Cust_Profiles.
      • Select the Array check box.
  4. Add the remaining child business objects to the top-level object
    Repeat the previous step to add two or more child business objects to the ArIbm_R_Cust_Accounts object. The following table shows the name and type attributes to enter for each child business object.
    Table 1. Name and type attributes
    Name Type
    Parties ArIbm_R_Parties
    AccountSites ArIbm_R_Acct_Sites
    The following figure shows how your set of objects looks after the build procedure.
    Figure 2. Built object set for the Retrieve operationThis image is described in the surrounding text.
  5. Build the remaining business objects for the Retrieve operation

    This step describes how to set the Foreign Key value and add a child object to the remaining business objects you need to build for the Retrieve operation. The Foreign Key application-specific information enables the adapter to retrieve child objects based on an attribute value in the parent object.

    Set the Foreign Key value for all eight of the objects in the table titled "Objects requiring Foreign Key values and child objects." Use the attribute name and value provided in the table for each object.

    For the business objects in the table that have child objects, you need to add child business object values. Enter the child object Name and Type provided in the table for each child object.

    1. Set the Foreign Key value for the object

      In the Business Integration view, double-click the object name. Click the attribute name that is provided in the table for the selected object.

      In the Properties view, click the Application Info tab.

      At the Attribute – attribute name window, right-click in the ASI element properties box. Select Add After > jdbcasi:ForeignKey.

      In the column to the right of jdbcasi:ForeignKey, set the value to match the value listed in the table for the selected object.

    2. Add child business objects

      In the Business Integration view, double-click the object name. At the top of the Business Object window, click the button to add an attribute to a business object.

      In the Properties view, click the Description tab, and enter the values for the attribute.

      • In the Name field, type the child object Name from the table for the selected object.
      • In the Type field, use the arrows to select the child object Type from the table for the same object.
      • Select the Array check box.
    Table 2. Objects requiring Foreign Key values and child objects
    Object Values
    ArIbm_R_Cust_Profiles

    ForeignKey Attribute = cust_account_id
    ForeignKey Value = cust_account_id

    ArIbm_R_Parties

    ForeignKey Attribute = party_id
    ForeignKey Value = party_id
    Child object:
       Name = Contacts
       Type = ArIbm_R_Contacts_Customer

    ArIbm_R_Party_Sites

    ForeignKey Attribute = party_site_id
    ForeignKey Value = party_site_id
    Child object:
       Name = Locations
       Type = ArIbm_R_Locations
    Child object:
       Name = Contacts
       Types = ArIbm_R_Contacts_Sites

    ArIbm_R_Acct_Sites

    ForeignKey Attribute = cust_account_id
    ForeignKey Value = cust_account_id
    Child object:
       Name = PartySites
       Type = ArIbm_R_Party_Sites
    Child object:
       Name = SiteUses
       Type = ArIbm_R_Site_Uses

    ArIbm_R_Site_Uses

    ForeignKey Attribute = cust_acct_site_id
    ForeignKey Value = cust_acct_site_id

    ArIbm_R_Locations

    ForeignKey Attribute = location_id
    ForeignKey Value = location_id

    ArIbm_R_Contacts_Sites

    ForeignKey Attribute = owner_table_id
    ForeignKey Value = party_site_id

    ArIbm_R_Contacts_Customer

    ForeignKey Attribute = owner_table_id
    ForeignKey Value = party_id

  6. Save the module

    In the Business Integration view, click the Oracle_Outbound module.

    From the menu bar, select File > Save.


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)