How to fix the Oracle error ORA-36914: (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and its ancestor.?

In this post, you’ll learn more about the Oracle ErrorORA-36914: (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and its ancestor. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36914: (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and its ancestor.

Reason for the Error ORA-36914: (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and its ancestor.

The LOAD_STATUS valueset is not allowed to contain both a dimension value and an ancestor of that value.

How to fix the Error ORA-36914: (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and its ancestor. ?

You can fix this error in Oracle by following the below steps

Perform a limit remove ancestors on the valueset and confirm that the result matches the intended load.