About the Daily Extract

The Daily Extract functionality extracts data from Oracle Field Service for storage, analysis, and reporting of events. The extracted data contains details of the main entities such as activities, inventory, and messages and are stored as a set of XML files in the Daily Extract database. The following important note applies to all the topics in the Daily Extract and Data Sets sections.

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.

The process for manually regenerating data for previous days in the Daily Extract application is detailed in Regenerate the Daily Extract files topic. For other applications, regenerating files that have already been generated for previous days isn't possible.

You can configure the files that are extracted at the time of implementing the application and later change as necessary.

These rules describe how the Daily Extract files are generated when fields or entities are changed:
  • When you change the name of an entity in Oracle Field Service, a new table is created in the target application with the new name:
    • For daily transactions, the changes are shown in the next daily run configured for the customer
    • For entities that support both daily and realtime transactions, the changes are shown after the next daily run
    • For entities that support only realtime, changes are shown immediately
  • When you change a field that's configured for an entity, a new column is created in the target table:
    • For daily transactions, the changes are shown in the next daily run configured for the customer
    • For entities that support both daily and realtime transactions, the changes are shown after the next daily run
    • For entities that support only realtime, changes are shown immediately
  • When you change the data transfer mode (Real time to Daily or the reverse), the data transfer starts only from the next day.
Note: To access data elements that aren't described here, use a different interface, such as REST APIs.