Adding New Work Order Status

You can add user-defined work order status in Oracle Maintenance corresponding to the standard activity status. The accelerator can update the current work order status with a user-defined status based on the mapping configured in the accelerator.

The following table (lookup table in Oracle Integration Cloud) provides you an option to map the user-defined status in Oracle Maintenance to the standard status in Oracle Fusion Field Service. You can define the Oracle Fusion Field Service standard status and map that to a new work order status. The accelerator provides a custom activity property 'mwo_status_change_reason'. You can use the value of this field in the column "STATUS_CHANGE_REASON" to show different work order statuses against the same standard status in Oracle Fusion Field Service.
OFS_STATUS STATUS_CHANGE_REASON MNT_STATUS
Pending Scheduled
Not Done Awaiting parts Awaiting parts
Not Done Additional manpower Additional manpower
For example:
  • To display the work order status as 'Scheduled' (a user-defined status) in Oracle Maintenance when an activity is in 'Pending' status in Oracle Fusion Field Service, you can configure the OFS_ STATUS (representing the Oracle Fusion Field Service standard status) as 'Pending' and the column MNT_STATUS (representing Oracle Maintenance status) as 'Scheduled' in the table.
  • To display two different statuses ("Awaiting parts" or "Additional manpower") against the same activity status "Not Done" (Oracle Fusion Field Service status), configure the column OFS_STATUS with "Not Done. Configure the "STATUS_CHANGE_REASON" property with the values expected from "mwo_status_change_reason" in the mapping table. The accelerator updates the work order status per this configuration.