Duplicate invoice records in XLA_TRIAL_BALANCES table
Hi,
We are on Oracle EBS 12.1.3 and recently we noticed an issue with our AP trial balance for one of the ledgers. There is a variance between AP trial balance and GL. Upon further research, we found out that one particular invoice has two records in XLA_TRIAL_BALANCES table. It is the exact variance amount between AP and GL. I think if we remove one of the records from the XLA_TRIAL_BALANCES table, then we will tie out AP and GL. My question is whether we can remove this duplicate record from XLA_TRIAL_BALANCES table?
regards,
Jagan