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
- 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.
- 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
- Add the first child business object
- 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 Profiles.
- In the Type field, use the arrows to select ArIbm_R_Cust_Profiles.
- Select the Array check box.
- 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 attributesName |
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 operation
- 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.
- 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 .
In the column to the
right of jdbcasi:ForeignKey, set the value to match
the value listed in the table for the selected object.
- 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 objectsObject |
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
|
- Save the module
In the Business Integration view,
click the Oracle_Outbound module.
From the menu
bar, select .