FAQs for Scheduling Frequent Data Refresh V2
This topic lists the frequently asked questions for scheduling frequent data refresh V2.
Are there access controls or permissions to restrict other Oracle Fusion Data Intelligence users from changing the frequent data refresh schedules created by me?
You can use the audit history to view the frequent data refresh schedule changes. Currently, there are no access controls or permissions to restrict other users from changing your frequent data refresh schedules.
Are delta tables truncated after every frequent data refresh process or after the next incremental refresh?
The delta tables are truncated after the next incremental refresh.
Should we use lambda views or delta tables to move the latest frequent data refresh V2 data from Oracle Fusion Data Intelligence to downstream enterprise data lake?
For downstream integrations, it's recommended to capture data changes. See Capture Data Changes (Preview).
Is the FDR flag enabled automatically for custom facts,custom dimensions, extend custom confirmed dimensions, or custom facts? Are the lambda or delta tables created manually or automatically in Oracle Fusion Data Intelligence ?
When you run frequent data refresh, the lambda or delta tables are created automatically.
Does frequent data refresh V2 handle the hard deletes made in Oracle Fusion Cloud Applications?
No. Currently, frequent data refresh V2 doesn’t handle the hard deletes made in Oracle Fusion Cloud Applications.
Is it possible to schedule data refreshes bi-weekly multiple times a day?
No. You can’t schedule data refreshes bi-weekly multiple times a day.
Will you continue to support users who are using frequent data refresh V1?
We are currently supporting frequent data refresh V1, but we recommend users to upgrade and use frequent data refresh V2.
Will there be any price change for frequent data refresh V1 customers migrating to frequent data refresh V2?
Contact your Oracle account representative to discuss the specific implications of frequent data refresh V2. They can provide detailed, updated information on licensing and costs tailored to your organization's needs.
Is it possible to increase the limits for frequent data refresh V2? For example, can we request more than 20 tables for frequent data refresh?
Request Oracle Support to increase your limits. Note that increasing the limits might have cost implications.
What column in the lambda view corresponds to the Oldest Date to Report field?
Download the frequent data refresh V2 database objects spreadsheet for each pillar on the Recommended Tbls FilterDateCols tab to review the frequent data refresh V2 filter date columns to discover the filter used.
Are there any potential downsides or performance impacts to increasing the number of FDR modules or tables?
Yes. See Performance Considerations for Frequent Data Refresh.