Oracle Solution for Error ora-36638

ORA-36638: (XSDUNION17) Concat dimension workspace object

cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object

.

What triggered the Error:

A non-unique concat dimension cannot be used as a base of a dependent unique concat.

What should we do to fix it:

CHGDFN any non-unique concat base dimensions to UNIQUE and retry.