Siebel Field Service Integration to Oracle Real-Time Scheduler Implementation Guide > How the Connector Retrieves Geocodes > Integration Flows That Retrieve Geocodes >

Integration Flow That Retrieves Geocodes for Multiple Addresses

Figure 13 illustrates the integration flow that retrieves geocodes for multiple addresses.

Figure 13. Integration Flow That Retrieves Geocodes for Multiple Addresses

Explanation of Callouts

The integration flow that retrieves geocodes for multiple addresses includes the following steps:

1. In Siebel CRM, the user queries for the addresses for which this integration must retrieve geocodes, and then clicks Bulk Geocode.
2. Siebel CRM changes the value in the Geocode Sync Description field of the address record to Geocoding In Progress.
3. Siebel CRM calls the BatchGeoCode method of the BatchGeoService Web service in Oracle Fusion Middleware. It uses Geocoding In Progress as the input.
4. A database adapter in the BPEL flow retrieves all the address records in the Siebel address table that contain Geocoding In Progress in the Geocode Sync Description field.
5. The BPEL flow reads the batch message and then parses the batch message into individual address messages so that it can retrieve a geocode for each individual address.

   To retrieve a geocode for a single address, the Bulk Geocoding BPEL process calls the real-time geocode BPEL flow for each address. For more information, see Integration Flow That Retrieves a Geocode for a Single Address in Real-Time.

6. If Oracle Real-Time Scheduler returns only a single set of geocodes, then the BPEL process uses the database adapter to add the latitude and longitude values to the address table in the Siebel database.
7. If Oracle Real-Time Scheduler returns multiple geocodes or no geocode, then the database adapter inserts an error message in the error column of the address table in the Siebel database.

WSDL That Retrieves Geocodes for Multiple Addresses

To retrieve geocodes for multiple addresses, Siebel CRM uses the BatchGeoCode WSDL operation. For more information, see Integration Services.