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
Outbound operations
Application components use operations to perform actions such as retrieving from a database. The adapter provides certain outbound operations. Details are provided on how the adapter processes business objects for each of the supported operations.
An operation can be performed using a standard SQL statement provided by the adapter or by a stored procedure that you define.
You can run a stored procedure to perform the operation or to do custom processing before or after the operation. In each business object, you can configure how each operation is performed.
- Create operation
The Create operation creates rows in database tables corresponding to the business object in the request. When given a hierarchical business object, the Create operation recursively traverses the business object, creating rows corresponding to each business object in the hierarchy.- Retrieve operation
The Retrieve operation extracts data from a database for a hierarchy of business objects.- RetrieveAll operation
The adapter uses the RetrieveAll operation to retrieve an array of business objects from the database. The adapter uses different processes depending on whether the RetrieveAll operation is for database table business objects or for user-specified SQL business objects.- Update operation
In an Update operation, the source business object is compared to a business object that is retrieved from the database using the primary keys specified in the top-level, source business object.- ApplyChanges operation
The ApplyChanges operation provides both delta and after-image support for modifying or deleting a business object. The ApplyChanges operation is available only if you use business graphs.- Delete operation
The Delete operation is performed by pruning the incoming business object and then retrieving the complete business object from the database. The Delete operation is then applied recursively on each business object in the hierarchy.- Execute operation
The Execute operation is used to run stored procedures and stored functions. The external service wizard generates the required stored procedure business object that corresponds to the stored procedure or stored function definition in the database. The adapter uses the Execute operation to process the stored procedure business object.
- Exists operation
The Exists operation determines whether the database contains records that match the attributes set in a business object.- Invoke operation
The Invoke operation is used to start XML Gateway web Service. The external service wizard generates the required XML Gateway web Service business object that corresponds to the XML Gateway web Service interface in Oracle E-Business Suite.- Publish operation
The Publish operation is used to start XML Gateway JMS interface. The external service wizard generates the required XML Gateway JMS business object that corresponds to the XML Gateway JMS interface in Oracle E-Business Suite. The adapter uses the Publish operation to process the XML Gateway JMS business object.
Related concepts: