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.

Goal

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?

ERROR
ORA-0001: Unique constraint violated

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

Solution

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
Goal
Solution
References


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