Oracle Error ORA-37172: illegal dimension type

Oracle Error Message

ORA-37172: illegal dimension type

Reason for the Error

The user specified an invalid member of the DIMTYPE field in the dimension sources argument

Solution

Specify one of the valid enumerated values in DBMS_AW