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 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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.