FTR SHOWS INCORRECT VALUES FOR TAXABLE/TAX ACCOUNTED AMT FOR REPORTING CURRENCY

(Doc ID 2318701.1)

Last updated on OCTOBER 24, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Tax Reporting

ACTUAL BEHAVIOR
---------------
While running the Financial Tax Register for Ledger ABC, the columns Taxable Accounted Amount and Tax Accounted Amount are showing incorrect values.

The primary Ledger is XYZ and is using a Corporate exchange rate type while the Ledger ABC is using a Local exchange rate type.

Example considered: Invoice number 100 in the Financial Tax Register report, ran for ABC, shows the wrong values:
Taxable Accounted Amount = 4161.46
Tax Accounted Amount = 957.14


These values incorrectly follow the corporate rate.

EXPECTED BEHAVIOR
-----------------------
The expected amounts are Taxable Accounted Amount = 3784 and Tax Accounted Amount = 870.32, these values can be find in the Subledger Journal Entry for ABC.
(These are the figures converted via the Local Rate posted in GL and the report should match them).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Tax Managers
2. Navigation: Requests > Run
3. Run the Financial Tax Register report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users do not get the expected values in Financial Tax Register.

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