Use Tax Liability Report (ZXXINUTR) Shows Invoice Multiple Times (Doc ID 2103965.1)

Last updated on FEBRUARY 08, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Tax Reporting

ACTUAL BEHAVIOR
---------------
Use Tax Liability Report (ZXXINUTR) shows invoice multiple times if the tax rates are updated.

When the tax rates were updated, the old tax rate was set to inactive, but the end date was not entered.

EXPECTED BEHAVIOR
-----------------------
Expect the invoice to be shown only once on the Use Tax Liability Report.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Update a tax rate code by creating a new row. Inactivate the old rate, but do not add an end date the rate.
2. Run the Use Tax Liability Report for an invoice that uses the tax rate.
3. The invoice will show one (or more) times on the report, depending upon the number of inactive, not-end dated rows when a new rate is also created.

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