Latin Tax Engine Issue: Saving Transaction with IPI in ICMS Calculus Base and Receive Error - An Unexpected Error Has Occurred. Please Contact Your System Administrator

(Doc ID 973122.1)

Last updated on DECEMBER 14, 2016

Applies to:

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


When saving a transaction with a configuration including the IPI in the calculus basis of ICMS the system errors out with message

An unexpected error has occurred. Please contact your system administrator.

Debug Log shows:
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt -1: ORA-00001: unique constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) violated ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt.END ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-) ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt Incorrect return_status after calling ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt RETURN_STATUS = U ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt.END ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-) ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX ZX_API_PUB: CALCULATE_TAX:ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors ar.plsql.arp_etax_services_pkg.record_tax_accounts return status service = U


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