Order business object

In the sample Order business object for the connector, data is populated into the following SO interface tables

The user runs the Import Order concurrent program to import the orders into the application.

In Oracle, Sales orders can be imported using interface tables and Order APIs. Oracle provides the following interface tables for order:

The sample Order business object is designed to use the Oracle API. Oracle provides an API for each order record in the OE_Order_Pub package. These APIs cannot be accessed directly because they take parameters of type PL/SQL or RECORD. Therefore, a wrapper API is required to provide access. When data is inserted into the interface table, the wrapper API is called to take data from these tables and put it into the base tables. The sample stored procedure CW_PROCESS_ORDER provides an example of using a wrapper API.

The Order business object for Oracle uses the same interface tables as Sales except Order does not use OE_ACTIONS_IFACE_ALL.

Additionally, the table CW_OE_API_ERRORS stores error messages that are generated during the API call. When an error occurs, the application administrator must correct the error and remove the error record from the CW_OE_API_ERRORS table before restarting the concurrent program.

Procedure CW_PROCESS_ORDER contains the logic for order processing and calls to the API routines. Calls to this procedure migrate data from the interface tables to the Oracle application base tables. When an error occurs, the application administrator must correct the error and remove the error record from the CW_PROCESS_ORDER table before restarting the concurrent program. The procedure takes the Orig_Sys_Document_Ref attribute value as its order number parameter. This attribute is present in all objects related to order. You must ensure that the Orig_Sys_Document_Ref attribute is populated with the same value across all objects in an order. This can be enforced through foreign key specifications or can be defined in the map (relevant only when using ICS as the integration broker).

The Order business object for Oracle, supports Create, Update, and Delete operations. Retrieve operations must use either the base tables or a view defined on the base tables. The sample business object BO_ORACLEAPPS_ORDERRETRIEVE supports Retrieve operations based on the interface tables.

Copyright IBM Corp. 1997, 2003