Import and Export Service Work Orders

You can now import and export service work orders by utilizing the existing object import/export functionality in Oracle Fusion. This allows the importing of historical work orders during your implementation or bulk updates of existing work orders. For integrated Field Service Work Orders, you can have these either sent to Field Service through the standard OIC* flows for open work orders or not sent to Field Service for historical work orders.
*OIC = Oracle Integration Cloud

Companies often need the ability to import current and historical service work orders during their implementation and may need the ability to export a list of work orders.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

When importing work orders, the following rules apply depending on the type of work order imported:

  • Generic work orders, where WoIntegrationCd equals ORA_WO_INT_SVC, creates a new work order or updates an existing work order.
  • Third party integrated work orders, where WoIntegrationCd equals a customer created new integration code, creates a new work order or updates an existing work order.
  • Oracle Field Service work orders, where WoIntegrationCd equals ORA_WO_INT_OFSC:
    •  If WoStatusCatCd equals ORA_SVC_WO_CAT_OPEN and WoStatus_Cd equals ORA_SVC_WO_SUBMITTED, creates a new work order and triggers the active OIC work order create flow to create the activity in Field Service.
    •  If WoStatusCatCd equals ORA_SVC_WO_CAT_OPEN and FsActivityId contains a Field Service Activity Id and  WoStatus_Cd equals ORA_SVC_WO_PENDING, ORA_SVC_WO_STARTED or ORA_SVC_WO_ENROUTE, creates a new work order or updates an existing work order and triggers the active OIC work order update flow to update the associated activity in Field Service.
    • If WoStatusCatCd equals ORA_SVC_WO_CAT_CLOSED, creates a new work orders or updates an existing work order.
    • If WoStatusCatCd equals ORA_SVC_WO_CAT_CANCELED, creates a new work orders or updates an existing work order.
    • If WoStatusCatCd equals ORA_SVC_WO_CAT_DRAFT, creates a new work orders or updates an existing work order.

Key Resources

The following guide provides more information on the import and export processes in Fusion Service for all objects including the service work order: Implementing Service Center Import and Export Management.

Access Requirements

Users need access to the following two tools:

  • Tools > Import Management > Import Objects
  • Tools > Export Management > Export Objects

To grant access, the user needs a role that contains the Manage Setup Data Export and Import Processes.