Oracle Utilities Work and Asset Cloud Service to Oracle Field Service Data Synchronizations
Mobile Control Data Sync
The control data and the activity types from Oracle Utilities Work and Asset Cloud Service are synced to Oracle Field Service. The work skill related configurations needed in Oracle Field Service are created to match activities with resources and for crew tracking. This synchronization happens on initial installation or on a need only basis when new control data from Oracle Utilities Work and Asset Cloud Service or work skill related configurations needs to be created or updated in Oracle Field Service.
Control Data includes codes and descriptions of selected admin entities, characteristic type valid values and extendable lookup values. It also includes craft, equipment and other direct changes, whose resource type is internal, needed to support timesheet and resource usage.
Activity types define the categories of the activity supported by Oracle Field Service (in this case, Oracle Utilities Work and Asset Cloud Service Integration to Oracle Field Service). If any Activity Type already exists in Oracle Field Service, it is skipped from syncing to avoid overriding of Activity Type settings in Oracle Field Service.
Control data from Oracle Utilities Work and Asset Cloud Service have three categories:
1. controlDataEntities
2. resourceTypes
3. workClass
The properties controlDataEntities.default and resourceTypes.default in WAMOFSC_ConfigProps lookups can be used to control this sync based on the flag value. By default, this is set to “yes”. workClass will always be synced to Oracle Field Service application.
Equipment work skill creation is optional. It is controlled by property createEquipmentWorkSkills.flag in WAMOFSC_ConfigProps lookups. By default, this is set to “no”.
Note: Once a resource is created in Oracle Utilities Work and Asset Cloud Service, the resource code (craft code, equipment code and other resource code) cannot be changed. This sync integration process uses the resource codes to create the enumeration values for equipment, craft and other resource property in Oracle Field Service. Slash (/) also cannot be part of the resource code.
The enumeration values are populated for the following Oracle Field Service properties if the integration properties specified below are set to 'yes'.
Note: If admin data is deleted in Oracle Utilities Work and Asset Cloud Service, the enumeration value will not be deleted in Oracle Field Service. The sync integration process cannot delete enumeration values added to a property in Oracle Field Service; the OFSC REST API that updates the enumeration values of a property does not allow it. The only way to delete an enumeration value(s) in a property is by deleting the property, recreating the property, and run the sync to get the latest values. If Property resourceTypes.default in WAMOFSC_ConfigProps Lookup is set to 'yes', a work skill and work skill property is created for each craft retrieved from Oracle Utilities Work and Asset Cloud Service.
Managing Work Skills
1. If Property resourceTypes.default in WAMOFSC_ConfigProps Lookup is set to 'yes', a work skill and work skill property is created for each craft retrieved from Oracle Utilities Work and Asset Cloud Service. If Properties resourceTypes.default and createEquipmentWorkSkills.flag in WAMOFSC_ConfigProps Lookup are set to 'yes', it creates a work skill and work skill property for each equipment retrieved from Oracle Utilities Work and Asset Cloud Service.
2. Work skill conditions are also created based on the craft, equipment and the property values of workSkillCond.actvtySameSkillMaxWorker.default and workSkillCond.actvtyMaxEquipment.default from WAMOFSC_ConfigProps Lookup.
Truck Storeroom Admin Sync
This synchronization process is used to sync storeroom data from Oracle Utilities Work and Asset Cloud Service to Oracle Field Service where the storeroom type is “Truck”. Oracle Utilities Work and Asset Cloud Service will send only the active storerooms data at this time.
For each storeroom from the storeroom list returned by Oracle Utilities Work and Asset Cloud Service, only storerooms of TRUCK type are filtered and compared to each storeroom with the list of existing resources from Oracle Field Service.
a. If the resource from the list in Oracle Field Service does not exist in Oracle Utilities Work and Asset Cloud Service storeroom list, the resource status is updated as 'inactive' and sent to Oracle Field Service.
b. If the resource from the list in Oracle Field Service exists in Oracle Utilities Work and Asset Cloud Service storeroom list, the corresponding data in Oracle Field Service is updated.
c. If the storeroom from Oracle Utilities Work and Asset Cloud Service does not exist in Oracle Field Service, a new record in Oracle Field Service is created.
This synchronization process is a scheduled business flow which can be planned to run at a specific time of day/week/month to sync the truck admin data from WACS to OFSC.
There is another synchronization process “WACS OFSC Schedule Storeroom Sync” which is used to sync individual truck’s inventory from WACS to OFSC which is also a scheduled business flow that can be planned to run at a specific time of day, week, or month, or can be ran manually whenever necessary.