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.
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.
- 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.