Oracle Error ORA-36167: (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.

Oracle Error Message

ORA-36167: (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.

Reason for the Error

The user attempted to aggregate a FORMULA using an AGGMAP that is not valid for aggregating FORMULAs. The AGGMAP must specify PRECOMPUTE(NA) for all relation lines and must not specify any caching.

Solution

Correct the AGGMAP so it is legal for aggregating a FORMULA.