Duplicate records in FA_BALANCE_EXTRACT table
Summary:
We are having issues with reconciling FA amount with GL amount due to some of the asset transactions have duplicate entries in the FA_BALANCE_EXTRACT table. Our sub-ledger report is using the FA_BALANCE_EXTRACT table so for some accounts, we are having variances with GL account due to this.
Can anyone help me to understand how did this happened and how to rectify the table.
Thanks,
Subhasish
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
0