FDI GL Balances Data Not Matching with Fusion After P2T

s.datta · Feb 17, 2026 9:43AM

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

Bhaskar Konar · Feb 18, 2026 8:35AM

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

Hi @s.datta,

That's great news.

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

Thank you.

Bhaskar Konar · Feb 17, 2026 11:01AM

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.