How do I 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 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 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 applications. 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, 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 applications. The pre-built data visualization reports will display data from these tables.

The application provides in-app prompts and banners to guide users through the process of downloading and configuring the pre-built reports. These prompts will disappear once the reports have been successfully downloaded and configured.

The following pre-built data visualizations are available in the downloaded .dva file:

Report	Description
Total Activities	Total activities created for the organisation in a selected date range
Late Arrivals (%)	Percentage of activities started late for 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 Activity Duration for different activity types
Days to Service by Region	Activity duration (in days) based on activity region
Average Travel Time by Region	Average Travel time based on activity region
Late Arrivals by Region	Activities started late across different region

You can now upload this .dva file into Oracle Analytics and view them from Oracle Analytics dashboard.