Data Validation Recommendations and Tips
Here are some guidelines and tips related to data validation in Oracle Fusion Data Intelligence.
- Perform data validation daily, or as needed.
- You can run data validation for both open and closed periods.
- If there is data validation mismatch between Oracle Fusion Cloud Applications and Fusion Data Intelligence, and data is refreshed more frequently than daily, only run your validation after the pipeline runs finish.
- Fusion Data Intelligence data is valid on the last pipeline run date only. Any changes in Oracle Fusion Cloud Applications after the pipeline run date aren't synced with Fusion Data Intelligence, causing a potential mismatch between Oracle Fusion Cloud Applications and Fusion Data Intelligence.
- If source records from Oracle Fusion Cloud Applications are deleted, you can review the rejected records in the Warehouse Refresh Statistics subject area.