My Oracle Support Banner

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

Last updated on OCTOBER 30, 2018

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

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
Symptoms
Cause
Solution


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