ORA-00001: Unique Constraint When Loading Member Attributes
Last updated on OCTOBER 04, 2016
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
ORA-00001: unique constraint (FEM.FEM_<dimension>_ATTR_PK) violated.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms