Reason for 1p Rounding differences between CM and GL on reconciled Transactions

On some transactions we have found that Oracle has posted a different value in GL to the amount showing on a reconciled payment in Cash Management. The difference is by 1p. examples attached.

Notes

• The CM team have been inputting the User exchange rates
• This 1p rounding only occurs on some transactions
• Surely Oracle should post the functional currency amount to the “Cash” GL code – this should be the bank statement amount?
• The CM team have to raise a manual journal to correct this.

I have noticed on the APList  Diagnostic  for one payment/invoice that on the XLA_AE_LINES (Payment) table, that the debit and credit that is a 1p difference to the Cash Management reconciled amounts, has Accounting Class Code: 'BALANCE' , and Product Rule Type code: 'Currency Balancing Line', could this be any thing to do with the 1p differences.