R12: AP: Tax Amount Is Calculated To 0 / Tax amount is not calculated correctly (Doc ID 2583221.1)

Last updated on MARCH 08, 2023

Applies to:

Symptoms

 PROBLEM DESCRIPTION
===================
R12: Incorrect Tax Amount / ROUNDING_LEVE:HEADER & ROUNDING_RULE:DOWN

When 0 < UNROUNDED_TAX_AMT of all invoice line < 1 or
-1 < UNROUNDED_TAX_AMT of all invoice line < 0,
Tax Amount is calculated to 0.

ACTUAL BEHAVIOR
---------------
Tax Amount is calculated to 0.

Tax amount is not calculated correctly.

EXPECTED BEHAVIOR
-----------------------
Tax amount is calculated correctly.

STEPS
-----------------------

Tax Rate 8%

1.Supplier : Tax Details

Rounding Level :Header
Rounding Rule: Down

Supplier Sites
Rounding Level :Header
Rounding Rule: Down

2.Create a invoice(Standard or Credit)

1)CREDIT memo
INVOICE_AMOUNT=-42
INVOICE_TYPE_LOOKUP_CODE =CREDIT
INVOICE_CURRENCY_CODE=JPY

AP_INVOICE_LINES_ALL
LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT
1 ITEM -6 <--UNROUNDED_TAX_AMT -0.48
2 ITEM -9 <-- UNROUNDED_TAX_AMT -0.72
3 ITEM -12 <-- UNROUNDED_TAX_AMT -0.96
4 ITEM -6 <-- UNROUNDED_TAX_AMT -0.48
5 ITEM -6 <-- UNROUNDED_TAX_AMT -0.48
6 ITEM -3 <-- UNROUNDED_TAX_AMT -0.24

2.Validate the invoice.
Tax Amount is calculated to 0.
AP_INVOICE_LINES_ALL
LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT
1 ITEM -6
2 ITEM -9
3 ITEM -12
4 ITEM -6
5 ITEM -6
6 ITEM -3
7 Tax 0 <--It should be -3

2)Standard Invoice
INVOICE_AMOUNT=42
INVOICE_TYPE_LOOKUP_CODE =STANDARD
INVOICE_CURRENCY_CODE=JPY

AP_INVOICE_LINES_ALL
LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT
1 ITEM 6
2 ITEM 9
3 ITEM 12
4 ITEM 6
5 ITEM 6
6 ITEM 3

2.Validate the invoice.
Tax Amount is calculated to 0.
AP_INVOICE_LINES_ALL
LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT
1 ITEM 6
2 ITEM 9
3 ITEM 12
4 ITEM 6
5 ITEM 6
6 ITEM 3
7 Tax 0 <--It should be 3

Cause

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