Oracle Error ORA-36017: (XSHIERCK10) The definition of hierarchy workspace object over number in level number is not star consistent. The collision parents include number.

Oracle Error Message

ORA-36017: (XSHIERCK10) The definition of hierarchy workspace object over number in level number is not star consistent. The collision parents include number.

Reason for the Error

The definition of the hierarchy was not star consistent.

Solution

Change the definition of the hierarchy.