Oracle Error ORA-24180: invalid transformation expression, the transformation expression does not evaluate to the target type/attribute

Oracle Error Message

ORA-24180: invalid transformation expression, the transformation expression does not evaluate to the target type/attribute

Reason for the Error

The transformation expression does not evaluate to the target type or the target type’s specified attribute.

Solution

Provide valid transformation expression which evaluates to the target type or the target type’s specified attribute.