You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reports table for Oracle Fusion Field Service

Hi Team,

We are trying to use a BI Publisher (BIP) report to extract and store data in our data warehouse for reporting in Oracle Fusion Field Service and audit purposes, because of the 90-day data retention period.

I am following the Oracle documentation below to identify the available tables/views for reporting in Fusion:

https://docs.oracle.com/en/cloud/saas/sales/oedms/ffsactionlink-29728.html#Tables-30

Based on the documentation, the FFS_REPORT table should return the list of available reports. However, I noticed that several reports appear to be missing. In particular, I am trying to retrieve the “View the GPS Alerts Per Resource” report, but it does not show up in the results.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!