My Oracle Support Banner

PIM Copy UDA API (EGO_USER_ATTRS_DATA_PUB.COPY_USER_ATTRS_DATA) Error: ORA-0001: Unique Constraint Violated (Doc ID 1586204.1)

Last updated on AUGUST 12, 2021

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.


The PIM copy attribute API (EGO_USER_ATTRS_DATA_PUB.COPY_USER_ATTRS_DATA) raises a unique constraint violation (ORA-0001) when the user enables a master organization in a child organization, then calls the API to copy attributes.

How can this be fixed or avoided?

ORA-0001: Unique constraint violated

1. In PIM: Enable the master organization in the child organization.
2. Call the public API to copy attributes to the child organization.
3. Receive the error.


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.