My Oracle Support Banner

GST - After RUP9, System Is Truncating 'Tax Conversion Rate' To 2 Places After Decimal (Doc ID 2324685.1)

Last updated on APRIL 15, 2019

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.


On R12: GST Order Management


After applying RUP9, the system is truncating the "Tax Conversion Rate" to 2 places after the decimal.


Created an export sales order with User defined "Tax Conversion Rate" = 0.571.
But in India Tax Details, system is using Tax Conversion Rate = 0.57.
Due to this issue, there is 165 Rupee gap (less) in the Tax amount. This equates to $2.57 US dollars.
This difference is on just 1 line of 1 order. Adding all lines from all orders will make the difference in the Tax huge.

The calculations of the tax can be found in the LOCOMLIST output in tables JAI_TAX_LINES, JAI_TAX_JOURNAL_ENTRIES and GL_INTERFACE.


System should use all 3 digitis to the right of decimal of the "Tax Conversion Rate"

For example, system should use Tax Conversion Rate of 0.571, not just 0.57.

This worked as expected before RUP9 was applied


1. Create sales order
2. Check the India Tax Details
3. See the tax Conversion Rate shows as .57 (instead of .571.


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.