My Oracle Support Banner

ORA-00001: Unique Constraint (ZX.ZX_REGISTRATIONS_U2) Violated In ZX_PARTY_MERGE_PKG.MERGE_PTP_SITES in FND Logfile (Doc ID 2930142.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Oracle Receivables - Version 12.0.0 to 12.2.12 [Release 12.0 to 12.2]
Oracle E-Business Tax - Version 12.0.0 to 12.2.12 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.11 version, Customers Module

When merging parties this error occurs:
debugging via fnd_log_messages reveals that "ORA-00001: Unique Constraint (ZX.ZX_REGISTRATIONS_U2) violated"



STEPS
The issue can be reproduced at will with the following steps:
1. Trading Community Manager responsibility
2. Party Merge
 

Changes

 

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
Changes
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.