TEM - Error Name - ORA-00936: missing expression


What is the issue?

An error occurs while searching for any user from TEM Admin application:

Error Name: S1… (936): ora-00936: missing expression.

The following error occurs in TEM Admin application while you are searching for an employee from Basic Data > Employee > Employees.

Instructions:

The above error is received if there is a blank space used in the value being searched.

For example if a user name is saved as "JOHN WALTER" in TEM and the search is entered as "     JOHN WALTER"  or "JOHN WALTER        " then the error would be received.