Customer Interface Failed With Error ORA-00001: Unique Constraint (ZX.ZX_PARTY_TAX_PROFILE_U2) Violation Error (Doc ID 2144515.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

Oracle E-Business Tax - Version 12.0 to 12.2 [Release 12.0 to 12.2]
Oracle Trading Community - Version 12.0 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms

 On : 12.2.4 version, Customer Interface

Customer Interface failed with the following error in the log file:

Error:
hz_insert.party_type_code)
[05-05-2016 10:26:50] IMPORT_WRAPPER : ORA-00001: unique constraint (ZX.ZX_PARTY_TAX_PROFILE_U2) violated
[05-MAY-2016 10:26:50] End Call ZX_PTP_IMPORT.IMPORT_WRAPPER for INSERT with status :U
05-MAY-16 Error in Call ZX_PTP_IMPORT.IMPORT_WRAPPER for INSERT :ORA-00001: unique constraint (ZX.ZX_PARTY_TAX_PROFILE_U2) violated
Import_tax_attributes -

Steps To Reproduce:

1) Populate the customer interface tables to import customer, sites, profiles and contacts.

2) Run Customer Interface the error occurs

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