Why there is rounding difference between XLA_AE_LINES ACCOUNTED_DR and UNROUNDED_ACCOUNTED_DR? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why there is rounding difference between XLA_AE_LINES ACCOUNTED_DR and UNROUNDED_ACCOUNTED_DR?

edited Jun 16, 2025 2:45AM in Subledger Accounting & Accounting Hub 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!