Siebel Connector for Oracle Applications > Developer Procedures > Understanding the Oracle Receiver >

Operational Summary


When an Oracle database base table row is updated, a standard Oracle Events Alert or a database trigger copies the just-updated row to the Notification Table (SIE_NOTIFY_TBL) with the Status column value set to Ready for Transfer. At scheduled intervals or when user requests are made, the Oracle Receiver polls the Notification Table. When the Receiver finds updates, it extracts the rows into integration objects.

NOTE:  The Notification Table can include records of several types of objects. All rows of the same type are extracted into a single Siebel message containing many integration object instances of that type.

The Receiver starts a separate workflow for each integration object. The Receiver calls the Oracle Receiver Dispatch Workflow. This workflow passes data through the Data Transformation Engine (DTE) into a Siebel Integration Object, and then passes it into a Siebel Business Object to update the Siebel database tables.

When the workflow is completed successfully, the Receiver deletes the corresponding rows from the Notification Table. If the workflow fails, the status of the rows is set to Error in the Notification Table.

The overall pattern of Oracle Receiver activity is represented in Figure 6.

Figure 6. Oracle Receiver Operations

Click for full size image

Oracle Receiver Dispatching

Activated by the ReceiverDispatchMethod, the Oracle Receiver Dispatch Workflow controls the Oracle Receiver's data dispatching operations. When it obtains a new integration object (based upon Oracle Base Table changes reflected in the Notification Table), the Receiver Dispatcher workflow branches the flow of execution in the way shown in Figure 7.

Figure 7. Oracle Receiver Dispatch Workflow

Click for full size image

As Figure 7 shows, the Oracle Receiver Dispatch workflow accommodates the following integration object types:


 Siebel Connector for Oracle Applications 
 Published: 18 April 2003