Oracle Error ORA-37139: (XSCCOMP14) Cannot AGGREGATE workspace object using AGGMAP workspace object because you can not AGGREGATE a variable dimensioned by a COMPRESSED COMPOSITE using an AGGMAP with a PROTECT clause.

Oracle Error Message

ORA-37139: (XSCCOMP14) Cannot AGGREGATE workspace object using AGGMAP workspace object because you can not AGGREGATE a variable dimensioned by a COMPRESSED COMPOSITE using an AGGMAP with a PROTECT clause.

Reason for the Error

The user tried to AGGREGATE a variable dimensioned by a COMPRESSED COMPOSITE with an AGGMAP that included a PROTECT clause.

Solution

Modify the aggmap or create a new aggmap that does not include a PROTECT clause and reaggregate.