Configure Pre-built Data Visualization Reports for Oracle Analytics

Oracle Fusion Field Service provides pre-built data visualization reports for Oracle Analytics. You can download these reports from Oracle Autonomous Database application, upload them to Oracle Analytics, and view them from Oracle Analytics Dashboard.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.

Select Navigation Menu > Configuration.
Click Applications.
Select Oracle Autonomous Database Application and click Modify.
Select Pre-built dashboards. If this option was already selected while creating the application, skip to the next step.

This selection creates the tables ORA_FS_ACTIVITIES for the Activity Fields entity and ORA_FS_TIME_SLOT for Time Slot Fields entity, along with their respective columns, in Autonomous Database application. The pre-built data visualization reports display data from these tables. Data from Oracle Fusion Field Service is automatically synchronized with the Oracle Autonomous Database, ensuring up-to-date insights.

Click Download reports and configure tables.

This downloads the .dva file. Before downloading the file, the application creates the tables ORA_FS_ACTIVITIES for the Activity Fields entity and ORA_FS_TIME_SLOT for Time Slot Fields entity, along with their respective columns, in Autonomous Database application. The pre-built data visualization reports display data from these tables.

Note: The application provides in-app prompts and banners to guide you through downloading and configuring the pre-built reports. The banner is shown only until the reports are first downloaded and configured in an environment. It does not reappear daily. To download the reports again, go to Navigation Menu > Configuration > Applications, select Oracle Autonomous Database Application, click Modify, and then click Download reports.

The downloaded .dva file includes the following pre-built data visualizations:

Report	Description
Total Activities	Total number of activities created for the organization in a selected date range
Late Arrivals (%)	Percentage of activities started late within a selected date range
Routing Assignment (%)	Percentage of activities assigned through routing
Activities by Status	Count of activities based on the activity status
Activity Type by Region	Count of activities based on the activity region (work zone)
Activity Type and Average Duration	Average duration of activities by activity type
Days to Service by Region	Activity duration (in days) by activity region
Average Travel Time by Region	Average travel time by activity region
Late Arrivals by Region	Activities started late across different regions

You can now upload the .dva file into Oracle Analytics and view the pre-built reports from Oracle Analytics dashboard.