APP-SQLAP-97733 Tax Distribution Error

Module: Payables

Oracle Version: Oracle R12

Error Message:

APP-SQLAP-97733: The system cannot generate tax distributions due to the following error: ZX ZX_GENERIC_TEXT N GENERIC_TEXT Tax Currency Amounts cannot be NULL as Tax and Trx Currencies are different.

Cause of Issue:

If you enter the transaction in the same currency as the tax currency then there are no issues and the invoice can be validated.

The issue was caused when there is no exchange rate available. In our case it was because we did not have an ‘Exchange Rate Type’ set against the tax. After entering the exchange rate type of corporate, the invoice validated. If you have a default exchange rate already in place then it is likely that the exchange rates for the transaction date between your ledger and the tax currency are missing.


Set the Tax.
Ask System Administrator to add Currency Exchange Rate, or if the tax already has an Exchange Rate Type set, ensure that the TAX CURRENCY (both on the Tax and Offset related) have a Valid Tax Currency value (not an obsolete one).


Submit a Comment

Your email address will not be published. Required fields are marked *

Additional Support

When available, we provide additional resources to a particular support item, such as User Guides, blog posts, support videos and links to recommended Oracle solutions.


User Guide

Video Support


Oracle Recommendations

GCC VAT Oracle Learning Series

Want to know how to set tax up for Oman, Kuwait, Bahrain, Qatar, United Arab Emirates and Saudi Arabia then sign up to our free webinar series.

Share This