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.
Tagged:
0