Sync Mobile Control Data Information from DACS to OFS
Information from Oracle Utilities Digital Asset Cloud Service has to be replicated to Oracle Field Service to provide the drop-down information used in the Oracle Field Service mobile application. Create work skills, work skill properties, and work skill conditions in Oracle Field Service to match activities with resources and for crew tracking.
As part of this accelerator, OU DACS OFS Admin Data Sync deployed on Oracle Integration Cloud is provided to create these configurations automatically making the migration of data easier and to get rid of tedious manual work.
OU DACS OFS Admin Data Sync needs to be run on initial installation or on a need to basis when new control data from Oracle Utilities Digital Asset Cloud Service or work skill related configurations needs to be created or updated in Oracle Field Service.
This synchronous integration process is manually run in Oracle Integration Cloud by scheduling the integration process to run on a scheduled date or selecting Submit Now from the menu of the activated synchronous integration process to initiate an instance of the integration. An optional language parameter can be entered, it should be an ISO 2 letter language code, to determine the description to retrieve from Oracle Utilities Digital Asset Cloud Service and in what language code the property name should be created in Oracle Field Service. If the language is not populated or blank, it is defaulted to English (en).
Refer to the Business Flows chapter in Oracle Utilities Digital Asset Management Integration to Oracle Field Service Configuration Guide included in this release. The documentation is available on Oracle Help Center at https://docs.oracle.com/en/industries/utilities/integrations-index.html.
The following configurations are created or updated by the Sync Process:
• Create or update the enumeration values for the Oracle Field Service properties.
OFSC Property label | Synchronized DACS Information |
|---|---|
dacs_craft | Craft |
dacs_crew_shift_type | Crew Shift Type |
dacs_downtime_reason | Downtime Reason |
dacs_equipment_type | Equipment Type |
dacs_labor_earning_type | Labor Earning Type |
dacs_measurement_gauge_reason | Measurement Gauge Reason |
dacs_measurement_meter_reason | Measurement Meter Reason |
dacs_other_resource_type | Other Resource Type |
dacs_overtime_type | Overtime Type |
dacs_resource_uom | Unit of Measure-Resource |
dacs_material_uom | Material Unit of Measure |
dacs_material_stockitemCategory | Stock Item Category |
dacs_pickup_location_type | Pickup Location Type |
dacs_work_priority | Pickup Work Priority |
dacs_work_type | Pickup Work Type |
dacs_work_category | Pickup Work Category |
dacs_work_class | Pickup work class |
dacs_actType_psh | Activity Type To PSH |
To verify the information that is synchronized from Oracle Utilities Digital Asset Cloud Service to Oracle Field Service, navigate to the respective property and check the enumeration values. Click Modify.
Note: After a resource is created in Oracle Utilities Digital Asset Cloud Service, the resource code (craft code, equipment code and other resource code) cannot be changed. The synchronous integration process uses these resource codes to create the enumeration values for equipment type, craft and other resource type property in Oracle Field Service. Slash (/) should not be included in the resource.
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. One can delete an enumeration value(s) in a property by deleting the property itself, recreate the property and run the synchronization to get the latest values. Another alternative is to manually delete the unwanted enumeration values from the Oracle Field Service properties.
Following are the work skill related configurations:
1. A work skill is created in Oracle Field Service for each craft synchronized from Oracle Utilities Digital Asset Cloud Service. Work skill is a job-specific skill and is used as a criteria to match activities with the resources. The label format for work skill created in Oracle Field Service is:
W_ + DACS craftcode
Example: Work Skill created in Oracle Field Service
2. A work skill property on the activity level is created in Oracle Field Service for each craft synchronized from Oracle Utilities Digital Asset Cloud Service. This property will contain information about how many people with the particular work skill is needed for the activity. The label format for Work Skill property created in Oracle Field Service is:
W_ + DACS craftcode + _Nd
Example: Work skill property created in Oracle Field Service
3. Work skill conditions are created in Oracle Field Service based on the craft and the configuration property value of workSkillCond.actvtySameSkillMaxWorker.default obtained from DACSOFSC_ConfigProps lookup defined in Oracle Integration Cloud. This configuration property value contains the maximum number of people with the same work skill allowed to work simultaneously in an activity.
In this example: For work skill = Carpenter and workSkillCond.actvtySameSkillMaxWorker.default = 3, these are the work skill conditions created.
Example: Work skill conditions created for Work Skill Carpenter in Oracle Field Service
These configurations are used to track teams (crews) consisting of people with different work skills and make sure that activities that require several people simultaneously is assigned to the right team.
4. If the resourceTypes.default and createEquipmentWorkSkills.flag properties in DACSOFSC_ConfigProps lookup are set to 'yes', for each equipment synchronized from Oracle Utilities Digital Asset Cloud Service work skills, work skill properties, and work skill conditions are created in Oracle Field Service.
The label format for work skills created from equipment is:
WE_ + DACS equipmentcode
Example: Work skill created in Oracle Field Service
5. A work skill property on the activity level is created in Oracle Field Service for each equipment synced from Oracle Utilities Digital Asset Cloud Service. This property will contain information about how many people with the particular work skill is needed for the activity. The label format for work skill property created in Oracle Field Service is:
WE_ + DACS equipmentcode + _Nd
Example: Work Skill Property created in Oracle Field Service
6. Work skill conditions are created in Oracle Field Service based on the equipment and the configuration property value “workSkillCond.actvtyMaxEquipment.default” obtained from the DACSOFSC_ConfigProps lookup defined in Oracle Integration Cloud. This configuration property value contains the maximum number of people with the same work skill allowed to work simultaneously in an activity.
In this example: For work skill = Bolt Machine, workSkillCond.actvtySameSkillMaxWorker.default = 3, these are the work skill conditions created.
Example: Work Skill Conditions created for Work Skill Bolt Machine in Oracle Field Service
These configuration are used to track teams (crews) consisting of people with different work skills. Make sure that the activities that require several people simultaneously are assigned to the right team.