WebSphere Adapter for Oracle E-Business Suite
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.
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 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. |
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.
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.
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)