Oracle Error ORA-36181: A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.

Oracle Error Message

ORA-36181: A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.

Reason for the Error

The user attempted to add both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties to a single variable.

Solution

Remove the existing property before applying the new one.