What is the purpose of "Reload Data" and "Refresh Data" actions

Molly P

When updating descriptive flexfields in FDI > Custom Data Configurations, there are actions to Reload Data or Refresh Data. What is the purpose of these actions? I cannot find documentation on it.

Ashish-Oracle

@Molly P Reload Data will essentially perform a full load for the DFF related tables but the Data will reload in next scheduled data refresh. But a Refresh Data will perform an adhoc incremental load for the DFF related tables, you dont have to wait for the next schedule data refresh.

Richard Halford

As Ashish says, for reloading data from source. Reload in effect wipes the warehouse and repopulates for that data entity, where as refresh is an incremental load.

If I'm doing any development, e.g. meta data changes such as enabling multiple DFFs and especially disabling DFFs I'll do a reload just so I know I have a known baseline to report from.

As Ashish says the refresh option is for incremental on demand rather than waiting for the next schedule. If I'm say doing mass updates to DFF values in Fusion apps and testing a report I'd do a refresh to bring in the changes as that will get me a quick turn around rather than waiting for next ETL.

Molly P

Thank you both. @Richard Halford is there a limit to how many incremental refreshes we can do?

Thanks,
Molly

Richard Halford

I've not had any limit on how many I can run other than how long it takes to get a processing slot and run the incremental.

With your pipeline you can set frequent refresh for some tables as hourly as an example and I can see in there you can select DFFs (though I would expect your need to have the related table in frequent refresh to get in new records else I would suspect its doing updates only)

If you are running a DFF incremental on demand via refresh I'd expect you can get runs, maybe two in within an hour depending on how much data you changed. I did a complete republish of DFFS (in effect re-generate the RDP extension clean down and reload data) in about 1 1/2 hrs including a full reload.

JT_DC_2023

Hi,
the reload does not affect any custom schema but only the oracle schema, correct?

Is there any way to trigger a full reload of the Oracle Schema? Or does it have to be done for every Application (Offering & Functioanl area)?

Thanks

Ashish-Oracle

@JT_DC_2023 Instead of doing a reload of the functional areas. You can either "Reset the Data Warehouse" or "reset and reload"

https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/reset-and-reload-data-source.html

https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/reset-data-warehouse.html

JT_DC_2023

The "reset and reload" function does not affect custom tables, right? It will only reset and reload the out of the box data?

Ashish-Oracle

@JT_DC_2023 Reset and Reload option will affect all the activated functional modules , Augmentations and Custom Data Configurations ie. DFF, CAA etc
If your Custom tables are not brought in using Augmentations then they won’t be affected

Jose Zuria-Oracle

Hi team, I have a question: can I do several refreshes a day for a table created with Data Augmentation? This is for version 24.R4.P2 of FDI.
Thanks