Oracle Solution for Error ora-36995

Solution for Oracle Error ORA-36995

ORA-36995: (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.

What triggered the Error:

more than 1 hierarchies in the current computing scope.

What should we do to fix it:

use inhierarchy to limit