My Oracle Support Banner

OM: Error Saving a Sales Order For Brazil Error: 'There Are No Applicable Tax Categories For The Tax Group' (Doc ID 3036237.1)

Last updated on JULY 23, 2024

Applies to:

Oracle Financials for the Americas - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Using Americas Globalization Order Management (OM) and seeing error when attempting to enter and save a new sales order for Brazil.

The form error displays in a pop up box as: There are no applicable tax categories for the tax group.

The OM Debug Setup Test shows the following (How to generate a debug file in OM (Doc ID 121054.1)):

Message returned by tax API ZX_API_PUB.calculate_tax: 1return statusE
Message returned by tax API ZX_API_PUB.calculate_tax: There are no applicable tax categories for the tax group. Please set up Tax Category details for 'TAX_GROUP_NAME' from DEFAULT Contributor Condition Class, to match the Tax Group details for the 'TAX_CATEGORY_NAME' Tax Category return statusE
There are no applicable tax categories for the tax group. Please set up Tax Category details for 'TAX_GROUP_NAME' from DEFAULT Contributor Condition Class, to match the Tax Group details for the 'TAX_CATEGORY_NAME' Tax Category.
LEAVING OE_MSG_PUB.ADD
tax engine call returned error


The FND log of the process shows the following errors (How to enable and retrieve FND debug log messages (Doc ID 433199.1)):

JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()-
#NAME?
Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class
-- Number of Tax Lines for this transaction line: 0
***Reason(s) for Unsuccessful group expansion***
Tax Group : 'TAX_GROUP_NAME'
Contributor Type => Condition Name: CONTRIBUTOR_TYPE and Value: CONTRIBUINTE for Tax Category: 'TAX_GROUP_NAME' does not match with values of Class Code: DEFAULT
APP-JL-62587: There are no applicable tax categories for the tax group. Please set up Tax Category details for 'TAX_GROUP_NAME' from DEFAULT Contributor Condition Class, to match the Tax Group details for the 'TAX_CATEGORY_NAME' Tax Category.
Exception while expanding Latin Tax Group
APP-JL-62587: There are no applicable tax categories for the tax group. Please set up Tax Category details for 'TAX_GROUP_NAME' from DEFAULT Contributor Condition Class, to match the Tax Group details for the 'TAX_CATEGORY_NAME' Tax Category.
IN WHEN OTHERS OF CREATE_TAX_INFO_REC_TBL
APP-JL-62587: There are no applicable tax categories for the tax group. Please set up Tax Category details for 'TAX_GROUP_NAME' from DEFAULT Contributor Condition Class, to match the Tax Group details for the 'TAX_CATEGORY_NAME' Tax Category.
EXCEPTION(process_tax_rec_f_sql in loop)
SQLCODE -20001Error Message ORA-20001: APP-JL-62587: There are no applicable tax categories for the tax group. Please set up Tax Category details for 'TAX_GROUP_NAME' from DEFAULT Contributor Condition Class, to match the Tax Group details for the 'TAX_CATEGORY_NAME' Tax Category.
#NAME?


The Latin America Tax Analyzer shows a data issue for the same tax category (EBS Latin Tax Analyzer(Doc ID 2389945.1))
Error: Tax records exist in AR_VAT_TAX_ALL, but do not exist in ZX/JL tables.

Findings and Recommendations:
For more information, please read Doc ID 1333342.1 Need A Report Or Query To Make Sure All The LTE Tax Categories Are Migrated To Ebtax ZX Tables.

Tax Code Does Not Exist in ZX
TAX_CODE
'TAX_CATEGORY_NAME'
Error: AR_VAT_TAX_ALL.TAX_CODE does not exist in ZX_OUTPUT_CLASSIFICATIONS_V.MEANING. This may cause AutoInvoice to raise error:
This Tax Rate does not exist.

Findings and Recommendations:
For more information, please read Doc ID 1524582.1 Latin Tax Engine (LTE): AutoInvoice Completes with Error - Tax Rate Does Not Exist.


STEPS
-------
1) Responsibility: Order Management Super User (or equivalent).
2) Navigation: Orders, Returns > Sales Orders.
3) Enter information and save (or click book) and the error occurs.
4) Due to this error the sales order cannot be saved.

Note: There are no Applicable Tax Categories for the Tax Group (Doc ID 1133973.1) has been reviewed and setup is correct and in place and error remains.

 

Changes

 Upgraded the E-Business suite from 12.1.3 to 12.2.13.

Cause

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
Symptoms
Changes
Cause
Solution
References


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