Oracle Error ORA-37147: (XSCCOMP21) The variable workspace object must be in the current operation group of the COMPRESSED COMPOSITE workspace object.

Oracle Error Message

ORA-37147: (XSCCOMP21) The variable workspace object must be in the current operation group of the COMPRESSED COMPOSITE workspace object.

Reason for the Error

The variable dimensioned by the COMPRESSED COMPOSITE was not in the object list of the current operation group. For AGGREGATE, all variables dimensioned by the same COMPRESSED COMPOSITE also must use the same aggmap

Solution

Add the variable into the object list of the current operation group.