My Oracle Support Banner

Troubleshooting Latin America Tax Release 12 Tax Calculation Issues (Doc ID 784692.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Receivables - Version 12.0.0 to 12.2.3 [Release 12.0 to 12.2]
Oracle Financials for the Americas - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Oracle E-Business Tax - Version 12.0 to 12.2.3 [Release 12.0 to 12.2]
Information in this document applies to any platform.
FORM:ARXTWMAI.FMB - Transactions
EXECUTABLE:RAXTRX - Autoinvoice Import Program
JLZZPDWT.FMB - Set up withholding tax types
JLZZTATC.FMB - Tax Condition Classes
JLZZTCAC.FMB - Define Customer Site Tax Profile
JLZZTCAV.FMB - Associate Tax Category with Conditions and Values
JLZZTCTD.FMB - Tax Category Details
JLZZTCTG.FMB - Tax Categories
JLZZTCTS.FMB - Tax Category Schedules
JLZZTECS.FMB - Tax Exceptions by Customer Site
JLZZTEFS.FMB - Tax Exceptions by Fiscal Classification
JLZZTEIT.FMB - Tax Exceptions by Items
JLZZTLMR.FMB - Associate Tax Legal Messages
JLZZTLOC.FMB - Tax Locations
JLZZTTNR.FMB - Tax Exceptions by Transaction Condition Values


The purpose of this troubleshooting note is to assist users of the Latin America Tax Engine in diagnosing why taxes are not calculating as expected. This note does not provide "steps to implement". For this type of instruction please refer to the Oracle Financials for the Americas User Guide Release 12 Part No. B31525-02.

Troubleshooting Steps

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
Troubleshooting Steps
 1. Troubleshooting possible defects and bugs related to latin tax calculation
 2. Release 12 Documentation Clarification and Correction
 3. Troubleshooting - Basic Setup
     a. Has Latin Tax Ever Worked?
     b. Verify that the Tax Determination Method is set to Latin Tax
     c. Verify that you have not checked the checkbox " Use Subscription of the Legal Entity"
     d. Make Sure Regime is Properly Subscribed at the Operating Unit Level
     e. Obtain a Tax Debug Log
     f. Make Sure Transaction Type Has "Default Tax Classification" Checkbox Checked
 4. Troubleshooting - Finding a Tax Rate
     a. Verify that Latin Tax Engine is being called
     b. Verify the Transaction Condition Class
     d. Verify the Contributor Class
     e. Find the Valid "Value Code" for the "Class Code"
     f. Validate the Tax Group Setup
    g. Make sure you have a tax rule defined
     h. Verify that a tax code exists on the rule target.
 5. Troubleshooting - Unable To Select Class Code On Customer, Organization, Memo Line or Inventory Category
 6. Troubleshooting - Tributary Substitution
 7. Troubleshooting - Taxable Base Determination
 8. Troubleshooting - Upgrade Issues
 9. Troubleshooting - Quantity Based Taxes
 10. Troubleshooting - Legal Messages
 11. Troubleshooting -Manual Tax Lines with Latin Tax Engine
 12. Troubleshooting -Document Letter Setup
     a. Query your Document Letter
     b. Query The Inventory Organization Location from your invoice
     c. Navigate to Latin Tax Condition Classes form (In Latin Tax setup)
     d. Find the customer on the invoice you are entering
     e. Query the customer site from the invoice
     f. Navigate to the Latin Tax Condition Classes form
     g. Validate that your setup matches the document letter
     h. Correct Your Setup
     i. Typical Errors returned for invalid document letter setup:
 13. Tables used to store Latin Tax setup
 14. Logging a service request

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