Idea Statement
Enhance Oracle Fusion Data Intelligence (FDI) incremental refresh to automatically detect and propagate source-side deletions from Oracle Fusion Cloud ERP, eliminating the need for full functional-area reloads to remove deleted records from the warehouse.
Current Behavior / Problem Statement
Currently, FDI incremental refreshes process inserts and updates but do not process source deletions. When a record is deleted in Oracle Fusion ERP, it continues to persist in the FDI warehouse until a full reload of the affected functional area is performed.
For example, a PAYMENT_SCHEDULE_ID deleted in Fusion ERP remains in DW_AR_SLA_SCHEDULES_CF after multiple incremental runs, until a full Accounts Receivables reload is executed. This is applicable for all functional Areas
This is documented and standard product behavior, but it creates a meaningful data-consistency gap between the source ERP and the analytics warehouse.
Business Impact
- Reconciliation discrepancies between Oracle Fusion ERP and FDI (mismatched record counts and balances).
- Reduced confidence in reporting accuracy, particularly during financial month-end close.
- Operational overhead — full reloads are not sustainable in large production environments due to high data volumes, limited refresh windows, downstream dependencies, and business-continuity constraints.
- Increased risk to time-sensitive financial and compliance reporting.
Proposed Enhancement
Introduce native deletion-handling within incremental refresh, for example through one or more of the following:
- Automatic soft/hard delete detection using source audit columns or change-tracking metadata.
- A deletion capture framework (e.g., delete log or change-data-capture table) that flags source-deleted keys for warehouse removal during incremental runs.
- A configurable option at the functional-area or table level to enable deletion propagation without a full reload.
- Reconciliation/exception reporting highlighting records present in FDI but no longer in the source.
Expected Benefits
- Accurate, near real-time consistency between Oracle Fusion ERP and FDI.
- Elimination of frequent, resource-intensive full reloads.
- Improved trust in FDI as a reliable financial reporting platform.
- Reduced operational cost, shorter refresh windows, and lower month-end close risk.
Priority / Business Justification
High — This gap directly affects financial reconciliation and month-end close reporting integrity. Native deletion handling would significantly strengthen FDI's position as an enterprise-grade analytics platform and reduce dependency on manual, high-cost workarounds.
