WebSphere Adapter for Oracle E-Business Suite

Retrieve operation business objects

The business objects for the Retrieve operation are stored in the Oracle E-Business Suite base tables. Because the Retrieve operation does not modify the values in the base tables, you can retrieve the data from those tables directly. You do not have to use interface tables.

Business objects in the base table

The following table shows the structure of the business objects for the Retrieve operation in the base tables, including the table name, business object name, and description. The next section shows the relationship of the business objects that you configure for the Retrieve operation.

Table 1. Business objects for the Retrieve operation in the base tables
Table name Business object Description
AR.HZ_CUST_ACCOUNTS ArIbm_R_Cust_Accounts Customer number, type, and other customer information.
AR.HZ_CUSTOMER_
PROFILES
ArIbm_R_Profiles High-level profile information for the customer.
AR.HZ_PARTIES ArIbm_R_Parties Customer name and if it is a person, not a business, the person's details.
AR.HZ_PARTY_SITES ArIbm_R_Party_Sites Links between customer's address IDs and address location IDs.
AR.HZ_CUST_
ACCT_SITES_ALL
ArIbm_R_Acct_Sites Address IDs.
AR.HZ_CUST_
SITE_USES_ALL
ArIbm_R_Site_Uses Customer business address purposes (BILL_TO, SHIP_TO), etc.).
AR.HZ_LOCATIONS ArIbm_R_Locations Address details.
AR.HZ_CONTACT_POINTS ArIbm_R_Contacts_Sites Contact and phone details. The table is listed twice because both sites and customers (PARTY_SITES and PARTIES) use the same table for contact details.
AR.HZ_CONTACT_POINTS ArIbm_R_Contacts_Customer Contact and phone details. The table is listed twice because both sites and customers (PARTY_SITES and PARTIES) use the same table for contact details.

Relationship of the business objects

For the Retrieve operation to succeed, the links connecting the customer object to its child objects must match those in the Oracle database. The following diagram shows the relationship of the objects you must configure for the Retrieve operation.

Figure 1. Relationship of objects for the Retrieve operation
This image is described in the surrounding text.

To build the objects, you create the child objects and set the application-specific information foreign key relationship between the parent and child objects. For more information on the nature of business objects, refer to the "Business objects" section of the WebSphere Adapters: Adapter for JDBC User Guide. To view that documentation, see http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/topic/com.ibm.wsadapters602.jca_jdbc.doc/doc/stjdb_welcome.html.


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)