IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Oracle E-Business Suite > Overview of IBM WebSphere Adapter for Oracle E-Business Suite > Technical overview

Outbound processing

When an application component needs to query the existence of a record in the database or retrieve or modify data in the underlying Oracle database, the adapter acts as the connector between the application component and the database. The adapter provides a set of standard outbound operations, which process either the after-image or delta style business objects. The adapter also supports both local and XA (distributed) transactions for outbound processing.

The adapter business object model uses two styles of business objects for making updates: after-image and delta. An after-image business object is one that contains the complete state of the business object after the required changes have been made to it. A delta business object is one that contains only key values and the data to be changed. Delta business objects are used only in operations that update business objects.


Supported operations

Table 1 lists the outbound operations that are supported for each type of business object and indicates whether each supports after-image or delta style processing.

Outbound operations supported by type of business objects
Business objects supported Operation After-image support Delta support

Tables
Views
Synonyms - Nick Names

Create Yes Not applicable
Update Yes Not applicable
Delete Yes Not applicable
Retrieve Not applicable Not applicable
RetrieveAll Not applicable Not applicable
Exists Not applicable Not applicable
ApplyChanges Yes Yes
Stored procedures Execute Not applicable Not applicable
Queries RetrieveAll Not applicable Not applicable
XML Gateway Invoke Not applicable Not applicable
Publish Not applicable Not applicable
Advanced Queue Enqueue Not applicable Not applicable


Transaction management

The adapter supports both local and XA (distributed) transactions for outbound processing. In the adapter, a transaction is an isolated interaction with the database. A transaction consists of multiple operations on the database that are performed as an atomic unit. These operations are not affected by simultaneously occurring operations from other users of the database.

The adapter supports transactions only if the database server supports transactions. The types of transactions that are supported are local and XA transactions:


XA transactions

The adapter supports XA transactions for outbound processing. Choose one of these methods to configure the adapter for XA transactions:

The XADataSourceJNDIName property represents a data source created within IBM BPM or WebSphere Enterprise Service Bus. If you define a JNDI data source that supports XA transactions on the server, and specify that data source when you configure the adapter, the adapter participates in XA transactions. Optionally, if you use an XA data source, the adapter participates in XA transactions.

Technical overview of IBM WebSphere Adapter for Oracle E-Business Suite


Related reference:

Managed connection factory properties