1. Using Forecasting Cloud Service
  2. Exporting Data

Exporting Data

You can export CSV-formatted data from Oracle Fusion Field Service Forecasting Cloud Service. The exported data doesn't show in Microsoft Excel format as this feature doesn't support Microsoft Excel.

This screenshot shows the data exported to CSV format, which is opened in a spreadsheet:
This screenshot shows the data exported to CSV format, which is opened in a spreadsheet. The columns included are Bucket external ID, Data type, Name, Date, Time slot, Capacity category, and Minutes.

You can export these types of data:

  • Actual Workload

  • Forecasted Workload/ Forecasted Max. Workload/ Forecasted Min. Workload

  • Available Resources (Min, Max and Avg if available)

  • Plan

  • Booked workload

  • Overrides (Lines added using the “Override” functionality)

  • Custom lines (Additional data that you add to a chart or table. For example, you can add data from another bucket for comparison and analysis.)

The lines in the exported CSV file contain this data:

  • Bucket's external ID: The external ID of the bucket selected in the Mobile Worker/Bucket Info page.

  • Parent ID: This is the external ID of the parent of the line. The line would have been created using the “Override” functionality on the parent.

  • Data type: The type of data exported (history, forecasting, sla_start, sla_end, booked, resources_min, resources_max, resources_avg, or custom_line).

  • Name: The name of the data defined as custom line. This parameter is used to differentiate between custom lines when several custom lines are used in the same chart. For History, Forecast, SLA Start, SLA End, and Plan data types the Name column will contain Actual Workload, Forecasted Workload. Forecasted Max. Workload, Forecasted Min. Workload, and Plan depending on the data.

  • Date: The date of the data that is getting exported in ISO format.

  • Time slot: The time slot of the data that is getting exported. Time slot labels are set under Time Slots on the Configurations menu.

  • Capacity category: The label of the capacity category that is getting exported. Capacity category labels are set under Capacity Categories on the Configurations menu.

  • Minutes: The man-minutes needed for the specified date, capacity category and time slot. Depending on the type of data this value can represent history, forecasted, planned or custom value.