About Scheduling Frequent Data Refreshes

For Oracle Fusion Data Intelligence, you can schedule frequent data refreshes for functional areas that are visible in the Frequent Data Refresh Schedule tab on the Pipeline Settings page.

When you refresh certain functional areas and warehouse tables, be sure you understand which tables you can refresh or not because the selective refresh of some tables could lead to functional inconsistencies when combining data from multiple subject areas. The frequent data refresh capability is designed for refreshing base tables that capture the transactional data, but not for a high volume of derived datasets that require aggregations, snapshots, or complex transformation logic. Processing derived datasets in large numbers creates data latency, which conflicts with the frequent refresh process.

When you select the functional areas for a frequent refresh, you can't refresh the data pipeline for the applicable functional area using the Refresh Data option on the Data Configuration page. Oracle Fusion Data Intelligence processes the data augmentations as part of the incremental loads. If you change a data augmentation after including it in the frequent data refresh schedule, then you must remove that data augmentation and let the next incremental refresh finish. Otherwise, the frequent data refresh might fail. After the incremental refresh is complete, you can add the updated data augmentation back to the frequent data refresh schedule.