My Oracle Support Banner

ORA-00001: Unique Constraint When Loading Member Attributes (Doc ID 554160.1)

Last updated on MARCH 25, 2019

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FEM

Symptoms

When attempting to update dimension member's attribute, the following error occurs.

Error:
ORA-00001: unique constraint (FEM.FEM_<dimension>_ATTR_PK) violated.

Steps:
1. Navigation:  Configuration Rules -->Dimension -->Members -->Create from Spreadsheet
2. Pick-up a dimension that have at least one attribute with Allow Multiple Assignments flag set (e.g. Customer).
3. Edit an existing member by filling in a new value for a non required attribute and also provide the existing value for the attribute with Allow Multiple Assignments flag set.
4. Upload the spreadsheet.
5. Process fails with the error.

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
References


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