Tax Rounding Issue: Rounding on Invoice in R12 Does Not Match Rounding R11i (Doc ID 1301187.1)

Last updated on JULY 15, 2020

Applies to:

Symptoms

In Release 11i, the tax amounts round DOWN. Where as R12 the tax amounts Round UP.

In the example below, the following invoice amount would be 45000 in R11i, whereas it is 45001 in R12:

line_amt unrounded_tax_amt tax_amt
   73.00              3.65    4.00
  325.00             16.25   16.00
40182.00           2009.10 2009.00
 1862.00             93.10   93.00
  416.00             20.80   21.00
-------- ----------------- -------
42858.00           2142.90 2143.00

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.