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 AUGUST 08, 2016

Applies to:

Oracle E-Business Tax - Version 12.0 to 12.0.7 [Release 12.0]
Oracle Receivables - Version 12.0.6 to 12.0.7 [Release 12.0]
Oracle Financials for the Americas - Version 12.0.0 to 12.0.7 [Release 12]
Information in this document applies to any platform.
Financials for the Americas - Version: 12.0 to 12.0.7


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

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