Oracle error
ORA-01722
ORA-01722: invalid number
What usually causes it
A string that isn't a number was converted to one, often by an implicit conversion in a comparison.
What to check first
Compare values of the same data type. On 12.2 and later, VALIDATE_CONVERSION finds the offending rows.