R12: EBTax: Tax Account On Tax Rate Cannot Be Updated For A Specific Tax Rate - ORA-00001: Unique Constraint (ZX.ZX_ID_TCC_MAPPING_ALL_U2) Violated (Doc ID 1446321.1)

Last updated on MAY 26, 2016

Applies to:

Oracle E-Business Tax - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to update the Tax Account on Tax Rate for a specific Tax Rate the following error message arises:

ERROR
--------
Error Page. Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: Schending van UNIQUE-beperking (ZX.ZX_ID_TCC_MAPPING_ALL_U2).
ORA-06512: in "APPS.ZX_RATES_PKG", regel 1145
ORA-06512: in "APPS.ZX_RATES_PKG", regel 883
ORA-06512: in regel 1

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