Oracle Solution for Error ora-37138

ORA-37138: (XSCCOMP13) You cannot delete values from workspace object

because it is an aggregated COMPRESSED COMPOSITE.

What triggered the Error:

The user tried to MAINTAIN DELETE from an aggregated COMPRESSED COMPOSITE.

What should we do to fix it:

In order to perform this sort of maintenance the composite must first be cleared. This can be done by running the CLEAR AGGREGATES command on the variable dimensioning the composite. Note that this will remove all data computed during the last AGGREGATE command.