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
Retrieve operation
The Retrieve operation extracts data from a database for a hierarchy of business objects.
To process the Retrieve operation, the adapter performs the following actions:
- Removes all child business objects from the top-level business object it received. In other words, it makes a copy of the top-level business object without any children.
- Retrieves the top-level business object from the database.
- If the retrieval operation returns one row, the adapter continues processing.
- If the retrieval operation returns no rows, indicating that the top-level business object does not exist in the database, the adapter returns the RecordNotFoundException error.
- If the retrieval operation returns more than one row, the adapter returns the MultipleMatchingRecordsException error.
The Retrieve operation uses only the primary key. Other columns are ignored.
- Recursively retrieves all multiple-cardinality child business objects.
The adapter does not enforce uniqueness when populating an array of business objects. The database is responsible for ensuring uniqueness of the business objects. If the database returns duplicate child business objects, the adapter returns duplicate children.
- Recursively retrieves each of the single-cardinality children, regardless of whether the child business object is contained with or without ownership.
All single-cardinality child business objects are processed based on their occurrence in the business object and before the parent business object is processed.
Retrieving NULL dataThe adapter can retrieve a record from a database table when the column value is NULL.
For example, a Customer business object might have these columns: custid, ccode, fname, and lname, where custid and ccode form composite keys. Composite keys are primary keys that refer to more than one attribute and are used to define the uniqueness of the business object. You can retrieve a Customer record for which the value of ccode is NULL. The adapter generates a SELECT statement for the Retrieve operation as:
select custid, ccode, fname, lname from customer where custid=? and ccode is null
Related concepts:
Related reference: