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
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Hello Team, In the fusion source, we have the records maintained in multiple language say in english as well as in arabic.. ex: dept name is stored in both english and arabic in oracle fusion source with 2 records with different language code like EN and AR. But the same data in FDI is getting extracted only with the…
Hi Team, can oracle provide a standard decks to have a demo and presentation with new customer? Please share any links or attachments if available. Thanks, Manoj
hello, Is there a way to hide the "back" button in the FDI menu bar? Thank you in advance for your help!
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
