My Oracle Support Banner

Tax Is Not Calculating for Total and Partial Dispute From Collections Transaction Detail Form (Doc ID 1677522.1)

Last updated on JULY 10, 2020

Applies to:

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


You are using Taxware TWE.

You create two (2) Credits on an Invoice (each credit does a partial credit of a giving line).
The second credit creates the tax lines, but the TAX_AMOUNT is 0, not the correct amount.

For Example:
An Invoice has .41 Tax on an Invoice Line.
The first Credit is done for half the value of the Invoice Line and Tax is calculated at .21.
The next credit is created and this creates ZX_LINES and ZX_DET_FACTOR lines but the Tax amount is zero.

Note on the transaction diagnostics, for the second credit created, the unrounded Tax Amount is -.21.

You placed a trigger on the ZX_DETAIL_TAX_LINES_GT for testing and found, in the FND log, that the Tax Amount was reading as -.21 (for State Tax)

TWE: New Tax Amount = -.21
TWE: New Tax Rate = 6
TWE: New Unrounded Tax Amount = -.21
TWE: New Tax = STATE
TWE: Old Tax Amount = -.21
TWE: Old Tax Rate = 6
TWE: Old Unrounded Tax Amount = -.21
TWE: Old Tax = STATE

until the following code:

ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.BEGIN ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(+)

The amount read as :

TWE: New Tax Amount = 0
TWE: New Tax Rate = 6
TWE: New Unrounded Tax Amount = -.2
TWE: New Tax = STATE
TWE: Old Tax Amount = -.21

As a result of the above values, ZX_LINES has TAX_RATE of 6% for State, but zero Tax Amount.

Current version: zxditaxlndetpkgb.pls 120.91.12010000.19




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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