FTR SHOWS INCORRECT VALUES FOR TAXABLE/TAX ACCOUNTED AMT FOR REPORTING CURRENCY (Doc ID 2318701.1)

Last updated on MAY 20, 2024

Applies to:

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

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