Oracle Solution for Error ora-36024

ORA-36024: (XSHIERCK05) Valueset workspace object

must contain values of one of the extra dimensions of relation workspace object

.

What triggered the Error:

The HIERCHECK command specified a valueset over an invalid dimension.

What should we do to fix it:

Specify a valueset containing values of one of the self-relation's extra dimensions (the dimensions in the relation's dimension list, minus the self-related dimension itself).