Credit Memo Tax Rate Percentage is Not Rounding and Showing Decimals When Crediting an Invoice (Doc ID 1991560.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

You are crediting an Invoice, showing a tax rate percentage of 21.
The credit memo is showing 20.999995.  
Percentage amount is not rounding.

Steps to Reproduce:

Tax Rate Code setup:
Option for Adjustment for Ad Hoc Amounts is set to Tax rate.

Transaction data:
Create an invoice with tax rate : 21% enter line amount 3692.62 tax amount showing on tax line : 775.45 tax rate showing on tax line : 21
Tax line in backend table ZX_LINES TAX_RATE 21
LAST_MANUAL_ENTRY null
UNROUNDED_TAX_AMT 775.4502

Credit the Invoice:
The Tax amount showing on tax line : -775.45 tax rate showing on tax line : 20.999995
Tax line in backend table ZX_LINES TAX_RATE 20.99999458379145430616
ORIG_TAXABLE_AMT -3692.62 ORIG_TAX_AMT -775.4502
UNROUNDED_TAX_AMT -775.45
LAST_MANUAL_ENTRY TAX_AMOUNT
TAXABLE_BASIS_FORMULA STANDARD_TB

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms