My Oracle Support Banner

R12: AP: EBTax: When Using Tax Control Amount And Entering Multiple Item Lines, Click Calculate Tax Between Item Line Entry: The Tax Amount Is Prorated Wrongly And Invoice Goes On 'Tax Amount Range' Hold (Doc ID 1569193.1)

Last updated on JULY 28, 2020

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.


When creating a Payables invoice with a Tax Control Amount AND midway through entering the lines, the tax amounts do not get prorated as expected. So when the invoice is validated, it goes on 'Tax Amount Range' hold.

Steps of scenario
1 - Create Invoice num XXX of amount 200.04 with Tax Control Amount 15.04.
2 - Enter one Item line of amount 100.00 with TCC '10% AP' (rate amount 10%)
3 - Hit 'Calculate Tax'; this creates one Tax line (Line 2) of amount 15.04.
4 - Enter two more Item lines: one of amount 50.00 with with TCC '10% AP', the other of amount 35.00 with TCC 'Free AP' (rate amount 0%).
5 - Hit 'Calculate Tax':
- Line 2 (the tax line) disappears
- Two new Tax lines created: one of amount 11.29, the other of amount 3.75. Both are stamped with Tax Rate Name '10% AP' but the Tax Rate values show 11.2875049900... and 7.504990019960...
Customer advises "...the tax amounts are not prorated correctly"
6 - Validate the invoice: it goes on 'Tax Amount Range' hold (Invoice tax amount does not fall within range)


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.