The "ORA-01722 invalid number error" usually occurs because of conversion. (ex: converting a string to number). Have you used any expression or function in the query. Check with the datatype too.

How do I fix invalid number?

To resolve this error: Only numeric fields or character fields that contain numeric values can be used in arithmetic operations. Make sure that all expressions evaluate to numbers.

What is invalid number in SQL?

ORA-01722 invalid number. Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. Only numeric fields or character fields containing numeric data may be used in arithmetic functions or expressions.