R12.1.3 : XLA_TRIAL_BALANCE table is missing data for some invoices?
We regularly Run Create Accounting program which creates and Transfer the data to gl and also updates the XLA_TRIAL_BALANCE table.
On one occasion Create accounting program and Transfer to Gl has completed successfully but
Open Account Balances Data Manager program errored and no error messages which has led to mismatch of GL_BALANCES and XLA_TRIAL_BALANCE. the difference is the latest journal batch went to GL and nothing happened on XLA trial balances.
How can we populate XLA_TRIAL_BALANCES table with this information.
After this issue has occured, many a times Crete accounting is run and everything is fine...