Oracle Error ORA-56901: non-constant expression is not allowed for pivot|unpivot values

Oracle Error Message

ORA-56901: non-constant expression is not allowed for pivot|unpivot values

Reason for the Error

Attempted to use non-constant expression for pivot|unpivot values.

Solution

Use constants for pivot|unpivot values.