My Oracle Support Banner

Tax Rounding Issues: 11i Round Up/down, R12 Round Up (Doc ID 1565196.1)

Last updated on MARCH 16, 2023

Applies to:

Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
OEXOEORD.fmb - Sales Order form


On : 12.1.3 version, Finance & Accounting

In 11.5.10 on sales order the tax rounding for multiple lines is one line rounds up and the next
line rounds down. Hence the order total tax amount is same as AR amount. It is correct tax.

In R12.1.3 same order and lines have each line rounding up. Hence the order total tax amount
is greater than tax amount in AR. OM tax amount is incorrect.

This occurs for all currencies, however is very noticeable using  TWD (Taiwan) which uses whole
number (integer) without decimals.

R12.1.3 to have correct total tax amount.

The issue can be reproduced at will with the following steps:

1. Customer set-up for the Bill To site
    Navigation = Customers > Customers (will open HTML page)
    Search for Customer #
    At Site Addresses, select site address,  Click on Details
    Select TAX PROFILE button, see Rounding Level = Header

2. Create sales order header, currency = TWD
    Add five (5) identical lines (item, qty, price):  quantity = 1 and unit selling price = 75,330 with 5% bus TAX selected
    See tax per line is (5 * 75,330 = 3766.5) rounded to 3767
    Order Subtotal is ( 5*75,330)  = 376,650 
    See tax on order is  (5*3767)  =   18,835

   Expected Header TAX calculation is 376,650 *5% = 18832.5 , to be rounded to 18,833.

   Note difference:  18,835 versus 18,833.



Upgrade from 11.5.10 to R12.1.3


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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