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.
@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.
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.
Thank you both. @Richard Halford is there a limit to how many incremental refreshes we can do?
Thanks, Molly
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.
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
@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
The "reset and reload" function does not affect custom tables, right? It will only reset and reload the out of the box data?
@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
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
Hi, do both options have the same purpose for Custom Data Configuration and Data Augmentation ? Or it differs ? Thanks so much
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
In FDI, most of the Hierarchy folder wont populating any data. This is one of the most required data from HR. Can anyone assist me how can I get that data in FDI.
Hello Oracle Team, Many organizations currently rely on both Oracle Transactional Business Intelligence (OTBI) and Oracle Fusion Data Intelligence (FDI) for reporting and analytics. While FDI continues to expand its subject area coverage, there are still several OTBI subject areas that are not yet available in FDI. Could…
We want a better grasp on what is considered custom data so we can plan ahead and scale properly before we get too big. Fortunately we are no where near the 50gb limit as found using the subject area for custom data but it doesn't tell us other than 'System' where the custom data is coming from. I found documentation here:…
Is there a way to refresh our development environments in OAC with production data? There a lot of developments that didn't make the cut into production and/or was only used for testing and we would like to clean up dashboards, datasets, data flows, etc… Possibly similar to how receive environment refreshes in our Oracle…
Managers want the ability to assign delegates in Fusion Data Intelligence (FDI) so that delegated users can access and use reports on their behalf. Is that available in FDI now? If yes, anyone share docs about steps to implement that in FDI Thanks
