Configure Oracle Integration for IoT Integration

Integration between IoT and Oracle Fusion Field Service can be achieved through Oracle Integration (OIC) configuration. This section discusses the process flow during the IoT - Oracle Fusion 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 Fusion Field Service:


Image shows the integration between IoT and OFSC through OIC.

The process flow during IoT and - Oracle Fusion 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 Fusion 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 Fusion 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