AutoInvoice Failing with Error ERROR_FROM_FUNCTION Jl_zz_tax.calculation When Using Latin Tax Engine (Doc ID 1981757.1)

Last updated on MARCH 04, 2016

Applies to:

Oracle Financials for the Americas - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Brazil AR

AutoInvoice Error:EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calc/Unable to find a default tax code

The issue in the debug log for the credit memo is showing the following problem:

... I: Tax_amount =
... I: Tax_vendor_return_code =
... I: Tax_precedence =
... I: Compound_amount =
... I: Tax_header_level_flag = N
... I: Tax_rounding_rule = NEAREST
... I: Trx_type_id = 5856
... I: Ship_From_Warehouse_id =
... I: Amount_includes_tax_flag = N
... I: Customer_trx_charge_line_id =
... I: Poo_id =
... I: Poa_id =
... I: Taxable_amount =
... I: Taxable_basis = BEFORE_EPD
... I: Override Tax Rate =


Based on the above, looks like the jlzzar.odf included in Patch 17528681 has overwritten the view created from jlzztxrm.sql 115.10 as part of Patch 8723112.

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