Financial Tax Register RXZXPFTR Shows Incorrect Taxable Amount And Tax Amount for Receipts

(Doc ID 2354206.1)

Last updated on JANUARY 29, 2018

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


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