Oracle Solution for Error ora-37147

ORA-37147: (XSCCOMP21) The variable workspace object

must be in the current operation group of the COMPRESSED COMPOSITE workspace object

.

What triggered 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

What should we do to fix it:

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