Why there is rounding difference between XLA_AE_LINES ACCOUNTED_DR and UNROUNDED_ACCOUNTED_DR?
Summary: ACCOUNTED_DR amount in XLA_AE_LINES is not correctly rounded when compared with respect to the value of column UNROUNDED_ACCOUNTED_DR
example:
Value of column ACCOUNTED_DR is recorded as 8.16
Value of column UNROUNDED_ACCOUNTED_DR is recorded as 8.00970873813
Client expectation is to have Accounted_DR value as 8.01
Note: This issue is primarily evident when the number of xla_distribution_links lines are greater than 150.
Customer recommendation/expectation is
"populate the XLA_AE_LINES.ACCOUNTED_DR with rounded (sum of (UNROUNDED_ACCOUNTED_DR amount in xla_distribution_links table))"
This ask is logically correct considering the rounding amount difference issue observed.