Oracle Solution for Error ora-37140

ORA-37140: (XSCCOMP15) Cannot AGGREGATE partitioned variable workspace object

using AGGMAP workspace object

because you cannot use the base of a COMPRESSED COMPOSITE as a partition dimension.

What triggered the Error:

The user tried to run aggregate on a partitioned variable with a partition dimension that is a base of a COMPRESSED COMPOSITE.

What should we do to fix it:

Repartition the data, drop the partition dimension from the aggmap, or don't use COMPRESSED COMPOSITES.