E Frequent Data Refresh V2 Data Lineage (Preview)
This section provides details about the updated Frequent Data Refresh feature for Oracle Fusion ERP Analytics.
Topics
Overview
Frequent Data Refresh (FDR) for Fusion ERP Analytics updates data at short intervals to keep information current and accurate.
You can use the new Frequent Data Refresh V2 (FDR V2) feature to get the latest information for relevant functional areas and custom data settings. For the selected modules, data is refreshed across all necessary tables, and the FDR flag is added to the relevant subject areas. FDR aims to bring transaction information for base datasets.
Derived data, such as aggregate tables and snapshots, aren't part of the FDR process. Dimensional data is excluded from the default FDR because it's considered non-transactional data.
You can add available dimension tables and data augmentation tables to the frequent refresh tables based on your reporting needs.
Review the functional areas currently available for FDR V2 to ensure you select the appropriate ones.
FDR V2 Database Objects Spreadsheet
Use this spreadsheet that contains details of the database objects supported for FDR V2. This sheet also includes the information about the date columns that are used to construct the lambda objects.
For more details about Lambda objects, see Frequent Data Refresh Delta Tables and Lambda View Details.
FDR V2 Metrics Spreadsheet
Use this spreadsheet that contains details of the metrics supported for FDR V2.
Frequently Asked Questions
How do I use the Scenario dimension when analyzing FDR data?
GL Balance Sheet and GL Profitability subject areas are associated with two FDR flags FA_GL and FA_GL_BUDGET. To use the Scenario dimension, you must enable FDR for budgets. When you include the Scenario dimension, always use only the GL Budget FDR flag. For other analyses without the Scenario dimension, always use only the GL FDR Flag.
Why don't I see project invoices of all statuses when I use the FDR flag in the Project Invoices subject area?
FDR is only supported for project invoices that are in Accepted status. Invoices in other statuses aren't frequently refreshed and aren't available.
Why don't I see unposted journals when I use the FDR flag in the GL Detail Transactions subject area?
FDR is only supported for journals that are posted. Unposted journals aren't frequently refreshed and aren't available.