Oracle Communities

Oracle Analytics and AI

Child Item

FDI GL Balances Data Not Matching with Fusion After P2T

Hi Experts,

After the recent P2T refresh, GL balances in FDI are not matching the balances in Fusion.

We compared ledger, period, and account combinations, and Fusion shows correct balances. However, FDI is showing different totals for the same data.

The data pipeline completed successfully with no errors.

Could you please confirm:

Is any additional step required in FDI after P2T?
Do we need to run a full reload?

Please let us know what checks are recommended.

Regards

Saptadip

Find more posts tagged with

Oracle Fusion Analytics

Analysis and Data Visualization

OAC

Fusion ERP Analytics

Fusion Data Intelligence FDI

Accepted answers

https://community.oracle.com/products/oracleanalytics/discussion/comment/74833#Comment_74833

That's great news.

Would you mind selecting the post that helped you to find the resolution?

Thank you.

All comments

https://community.oracle.com/products/oracleanalytics/discussion/28142/fdi-gl-balances-data-not-matching-with-fusion-after-p2t

Hi Saptadip,

Quick Question: Have you performed the Full Load after P2T refresh?

Ideally a full reload (or Reset and Reload Data Source) of the data source is highly recommended in FDI immediately after a Production-to-Test (P2T) refresh to ensure data consistency between the newly refreshed Fusion Applications source and the data warehouse.

Please take a look into the following Oracle Document especially Point4 for more info:

https://docs.oracle.com/en/cloud/saas/analytics/25r3/fawag/reset-reload-data-source.html

Hope this help.

Thank you.

@Bhaskar Konar Thank you ,

Reset and Reload submitted. Request is in progress.

Hi Saptadip,

Additionally, please take a look into the following post which might be useful too.

FDI:FAW: Fusion Apps P2T/T2P process impact on Fusion Data Intelligence - Data Mismatch & DFF change — Oracle

Hope this help.

Thank you.

@Bhaskar Konar Thank you

https://community.oracle.com/products/oracleanalytics/discussion/comment/74789#Comment_74789

Thank you @s.datta !

Hopefully it will resolve the data mismatch.

@s.datta , I believe Reset and Reload will solve this issue.

In general, these are recommended Best Practices after every P2T:

Pause pipelines
Validate connection
Reset extract dates
Run Full Reload
Reconcile balances
Resume incremental

Hope it helps!

https://community.oracle.com/products/oracleanalytics/discussion/comment/74827#Comment_74827

Thank you.

Yes, issue has been fixed after Reset and Reload.

https://community.oracle.com/products/oracleanalytics/discussion/comment/74833#Comment_74833

That's great news.

Would you mind selecting the post that helped you to find the resolution?

Thank you.