My Oracle Support Banner

Financial Tax Register RXZXPFTR Shows Incorrect Taxable Amount And Tax Amount for Receipts (Doc ID 2354206.1)

Last updated on JANUARY 17, 2020

Applies to:

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


On : 12.1.3 version, Tax Reporting

Financial Tax Register RXZXPFTR for Oracle Receivables shows incorrect taxable amount and tax amount for specific receipts

The report (Financial Tax Register) shows a taxable amount of -148.50 and a tax amount accounted of -28.21. The correct values are zero and this should be shown in the report accordingly.
Application records missing in the ZX reporting table "ZX_REP_TRX_DETAIL_T". In the example case the record for the entry of 28.21 (credit), as included in the AR_Distributions_All (line ID 4647721), is missing in the FTR report ( "ZX_REP_TRX_DETAIL_T").

Expect report to display correct values for the receipts

The issue can be reproduced at will with the following steps:
1.Responsibility: Receivables Manager
2. Navigation: Requests > Run Requests
3. Run the report using both Transaction and Transaction line Summary parameters > Compare the outputs and notice there are differences


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

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