Configure Oracle Integration for IoT Integration

Integration between IoT and Oracle Field Service can be achieved through Oracle Integration (OIC) configuration. This section discusses the process flow during the IoT - Oracle Field Service integration. You can import the integration package for OIC from the OFSC-OSvC par file.

The image shows a flow diagram of how OIC achieves the integration between IoT and Oracle Field Service:


Image shows the integration between IoT and OFSC through OIC.

The process flow during IoT and - Oracle Field Service integration involves the following steps:

  1. IoT invokes OIC and sends the alert message with the array of alerts.
  2. For each alert the information about the asset is retrieved from IoT.
  3. Using alert and asset information, OIC creates or updates activity in Oracle Field Service
  4. You can import the integration package for OIC from the OFSC-OSvC par file.
  5. The list of fields mapped in the integration are as follows:
    • bulkUpdate.updateParameters.identifyActivityBy = apptNumberPlusCustomerNumber

    • bulkUpdate.updateParameters.ifInFinalStatusThen = createNew

    • bulkUpdate.updateParameters.ifExistsThenDoNotUpdateFields = slaWindowEnd

    • bulkUpdate.activities.resourceId = routing

      Note: You must configure this field based on the unassigned bucket in Oracle Field Service
    • bulkUpdate.activities.apptNumber = ruleId

    • bulkUpdate.activities.activityType = asset

    • bulkUpdate.activities.customerNumber = affectedObjectId

    • bulkUpdate.activities.streetAddress = street

    • bulkUpdate.activities.city = city

    • bulkUpdate.activities.postalCode = zip

    • bulkUpdate.activities.stateProvince = state

    • bulkUpdate.activities.slaWindowEnd = newly created activity’s timeOfBooking + amount of days stored in asset's service_delta

    • bulkUpdate.activities.severity = severity

    • bulkUpdate.activities.summary = description

    • bulkUpdate.activities.asset_name = name

    • bulkUpdate.activities.asset_description = description