Oracle Solution for Error ora-36636

Solution for Oracle Error ORA-36636

ORA-36636: (XSDUNION04) The unique concat dimension workspace object

cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.

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 dependent unique concat dimensions to NOT UNIQUE and retry.