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

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

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

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