Oracle Solution for Error ora-33247

ORA-33247: (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object

, from leaf dimension workspace object

.

What triggered the Error:

A value cannot be renamed in a dimension if the new value conflicts with an existing value in a unique concat dimension containing this dimension.

What should we do to fix it:

The concat(s) causing the conflict could be CHGDFNed to NOT UNIQUE, or either of the duplicate values could be changed to make them UNIQUE.