Work Order Update
If you update the work order data, when the data is synced from Oracle Maintenance to Oracle Fusion Field Service, the accelerator updates the Oracle Fusion Field Service activities as mentioned below.
- When you create a new operation or resource, a new activity is created in Oracle Fusion Field Service corresponding to the new operation or new resource that was added.
- When you remove an existing operation resource from the work order operation, the corresponding activity is deleted from Oracle Fusion Field Service.
- Operational-level information updates aren't updated in the activity.
- Operation resource level information updates aren't updated in the activity.
- If a work order has an operation with no resource, when you add a new resource into the operation after the work order syncs with Oracle Fusion Field Service, this updates the existing activity with the resource information.
- Any update to a past-dated work order doesn't update the corresponding past-dated activity in Oracle Fusion Field Service.
| Work Order Status | Unreleased | Released | On hold | Completed | Closed | Canceled |
|---|---|---|---|---|---|---|
| Unreleased | Not Applicable |
New Activity creation Note: Make sure released status is allowed to sync the work order data in Oracle Fusion Field Service. |
Delete the activities associated with the work order | Not Applicable | Not Applicable | Cancel the activities associated with the work order |
| Released | Delete the activities associated with the work order | Not Applicable | Delete the activities associated with the work order | Not Applicable | Not Applicable | Cancel the activities associated with the work order |
| On Hold |
New Activity creation - If unreleased status is configured to sync the work order data in Oracle Fusion Field Service. No action - If the status isn't configured. |
New Activity creation Note: Make sure released status is allowed to sync the work order data in Oracle Fusion Field Service. |
Not Applicable | Not Applicable | Not Applicable | Not Applicable |
| Completed | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable |
| Closed | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Not Applicable |
| Canceled |
New Activity creation - If unreleased status is configured to sync the work order data in Oracle Fusion Field Service. No action - If the status isn't configured. |
New Activity creation Note: Make sure released status is allowed to sync the work order data in Oracle Fusion Field Service. |
Not Applicable | Not Applicable | Not Applicable | Not Applicable |
Field Mapping - Work Order to Activity
| Work Order Field | Description | Field Service Field | Field Type | Description | Mandatory |
|---|---|---|---|---|---|
|
Operation.WorkOrderNumber Operation.OperationSequenceNumber Resource.ResourceSequenceNumber Resource.ResourceCode |
Prefix_<running number> ; For example: MWO_00001 This is configured in Setup and Maintenance. |
apptNumber | String |
The logic to form the column is "<WO number>-<Operation Seq No.>-<Operation Resource Seq No. if available>-<Operation Resource Code if available> " For example: MWO_00001-10; MWO_00001-20-10-BMW |
M |
| Workorder.OrganizationId |
The organization or entity on which the maintenance operation is performed, which includes many work areas and inturn many work centers to perform the job. Typically, inventory is maintained at this level. |
resourceId | String |
Parent level bucket
|
M |
| Operation.WorkCenterCode | The physical area or location, where the maintenance activity is performed. The Labor and Equipment resources with capacity are maintained at this level. | mwo_work_zone | String | Work zone in Oracle Fusion Field Service | M |
| Operation.PlannedStartDate | Operation Start Date |
slaWindowStart date |
DateTime | M | |
| Operation.PlannedCompletionDate | Operation Completion Date - derived based on the Duration, if the Operation Start Date is specified. | slaWindowEnd | DateTime | M | |
| Resource.RequiredUsage | Duration of the work to be performed by Resource. | duration | Minutes |
Mapped with the Resource's Required usage (RequiredUsage * 60) |
M |
| Operation.OperationSequenceNumber | The sequence number is defined in the operation, and it is to be performed in this order. | mwo_op_seq_number | String | NEW: store the sequence number of Operation | M |
| Operation.WorkOrderId | mwo_workorder_id | String | M | ||
| Resource.ProfileCode | mwo_work_skill | String | O | ||
| Resource.WoOperationResourceId | Operation resource id | mwo_op_resourceid | String | O | |
| Operation.OperationName | mwo_operation_name | String | M | ||
| Workorder.WorkOrderPriority | mwo_workorder_priority | String | O | ||
| WorkOrder.WorkOrderDescription | wo_case_note | String | O | ||
| Operation.OperationDescription | mwo_operation_note | String | O | ||
| Operation.WoOperationId | mwo_operation_id | String | M | ||
| Asset.AssetId | wo_asset_id | String | M | ||
| Asset.AssetNumber | mwo_asset_number | String | |||
| Asset.SerialNumber | wo_asset_serial_number | String | |||
| Asset.Description | wo_asset_name | String | |||
| Asset.InstalledDate | wo_asset_install_date | String | |||
| Operation.OperationCode | activityType | Enum | |||
| Workorder.WorkOrderTypeCode | mwo_workorder_type | String | |||
| Workorder.WorkOrderSubTypeCode | mwo_workorder_subtype | String | |||
| Resource.ResourceDescription | mwo_op_resource_note | String | |||
| Workorder.OrganizationCode | mwo_workorder_org_code | String | |||
| Workorder.CancelReason | mwo_cancel_reason | String | |||
| Operation.OperationCode | mwo_standard_op_code | String | |||
| Preferred Resources: | |||||
| ResourceInstance.LaborInstanceId | resourceId | String | |||
| Required Inventory: | |||||
| OperationMaterial.InventoryItemNumber | model | String | |||
| OperationMaterial.Quantity | quantity | Number | |||
| Operation Completion: | |||||
| mwo_transaction_status | String | Value: FAILURE. It will capture if there is any transaction error [resource/material] during activity completion/cancel/not done/suspend. |
Field Mapping - Activity to Work Order
Oracle Fusion Field Service to Maintenance - Work order data with scheduled dates and resource instance assignments
| Oracle Maintenance Field | Description | Field Service Field | Field Type | Description | Mandatory |
|---|---|---|---|---|---|
| Create New WO, New Operation or New Resource in Oracle Maintenance by accelerator | To create a work order, operation, or resource in Oracle Maintenance when a new activity is created in Oracle Fusion Field Service or when a users wants to create a work order, operation, or resource in Oracle Maintenance during notdone/ completed/ canceled. | mwo_action_type | enumeration |
Values: newWO, newOperation, newResource This can be configured in any scenario where we want a new work order, operation, or operation resource to be created in Oracle Maintenance. This can be configured in Book Activity/Add Activity flows, or in any case where a follow-up activity needs to be created for a NotDone/Canceled/Completed scenario. |
Yes |
| Create New WO, New Operation or New Resource in Oracle Maintenance by accelerator | To create a new work order, operation, or resource in Oracle Maintenance when a new activity is created in Oracle Fusion Field Service or when users wants to create a new work order, operation, or resource in Oracle Maintenance during notdone/completed/canceled. | mwo_planned_date |
string with reg expression /^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1]) (2[0-3]|[01][0-9]):[0-5][0-9]:[0-5][0-9]/ |
Date Format: YYYY-MM-DD hh:mm:ss To capture the due date in which the work order, operation, or resource must be created. |
Yes |
| Create New WO, New Operation or New Resource in Oracle Maintenance by accelerator | To create a new work order, operation, or resource in Oracle Maintenance when a new activity is created in Oracle Fusion Field Service or when users wants to create a new work order, operation, or resource in Oracle Maintenance during notdone/completed/canceled. | mwo_parent_ref_wo_num | string | For Add activity/ Book activity/ Follow-up activity, make sure to have a value in this property which will be the reference activity to create a new work order, operation, or resource in Oracle Maintenance. | Yes |
| WO > Description | Sync the value captured in mwo_wo_desc to Oracle Maintenance work order description. | mwo_wo_desc | string | To capture the description for creating a new work order. | No |
| Custom WO Status |
This can be configured in notDone scenario to capture the reason for notDone. Based on this value and Oracle Fusion Field Service activity status, the accelerator can set custom work order statuses by configuring the values in ORCL-BRT-OFS-MNT-STATUS-MAPPING lookup.
|
mwo_status_change_reason | enumeration | Can be configured based on customer use case. | No |