Oracle Error ORA-56904: pivot value must have datatype that is convertible to pivot column

Oracle Error Message

ORA-56904: pivot value must have datatype that is convertible to pivot column

Reason for the Error

Datatype of pivot value is not convertible to the datatype of pivot column.

Solution

Check and correct pivot value.