My Oracle Support Banner

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 13, 2019

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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