Latin Tax Error: Calculating Taxes for Memo Lines Raises Error: There are no applicable tax categories for the tax group (Doc ID 804659.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

You are creating an invoice with memo lines, and upon completing the transaction, you get the following errors:

(Please note that in your situation it will display actual values for XXXXX, YYYYY and ZZZZZ)

There are no applicable tax categories for the tax group. Please setup the tax category details for XXXX from YYYYY Organization Condition Class, to match the Tax Group details for ZZZZZ Tax Category.

Review of the log file shows the following errors. Please note this sample is specific to a customer's issue and the values shown in your debug log will be different:

--------------------
***Reason(s) for Unsuccessful group expansion***
Tax Group : LOCACAO
Organization Condition Class => Condition Name: ESTABLISHMENT_TYPE and
Value: INCORP_EMPREENDIMENTOS for Tax Category: COFINS_C does not match with
values of Class Code: DEFAULT
ZX_API_PUB: ADD_MSG()+
ZX_API_PUB: ADD_MSG()-
Exception while expanding Latin Tax Group
IN WHEN OTHERS OF CREATE_TAX_INFO_REC_TBL
EXCEPTION(process_tax_rec_f_sql in loop)
SQLCODE -20001Error Message ORA-20001:
#NAME?
-20001: ORA-20001:
-20001: ORA-20001:
ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte(-)
Errored out when calculate tax.
ZX_PRODUCT_INTEGRATION_PKG: calculate_tax (-)
LTE calculate tax returned errors
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
return status service = E

Errors in the tax calculation

Cause

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