Tax Is Not Calculating for Total and Partial Dispute From Collections Transaction Detail Form

(Doc ID 1677522.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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: Updating ZX_DET_TAX_LINES_GT
***********************************
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

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