ORA-24180: invalid transformation expression, the transformation expression does not evaluate to the target type/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.