When Creating a Transaction with Tributary Substitution received an Unexpected Error has Occurred (Doc ID 2068592.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Financials for the Americas - Version 12.1.3 and later
Oracle E-Business Tax - Version 12.1.3 and later
Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When trying to save/create a transaction in Receivables Transaction Workbench and after entering the line, you are getting an error message:

          Unexpected error has occurred. Please contact your System Administrator


The error seems to be related to Tributary substitution calculation since the error happens only for transaction type assigned to tax group with ICMS Tributary substitution.
Using Latin Tax Engine for Brazil.

In Debug file we can see follow lines:

p_rule = GET_EXC_FISC_CLAS_TX_CODE
o_tax_code =
o_base_rate =
o_rule_data_id =
get_category_tax_rule: -O- Rule Id:
get_category_tax_rule: -O- Tax Code:
get_category_tax_rule: -O- Base Rate:
get_category_tax_rule: -O- Rule Data Id:
get_category_tax_rule()-
ZX_API_PUB: ADD_MSG()+
ZX_API_PUB: ADD_MSG()-
calculate_latin_tax: EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax
EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate
ZX_API_PUB: ADD_MSG()+
ZX_API_PUB: ADD_MSG()-
JL_ZZ_TAX.calculate()- : tax_vendor_return_code 9
-20001: ORA-20001:

 

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