We just created a user defined scan "usersql2" (User SQL Numeric Type 02) and this error is in the uv_scan_s.log:
Oracle error returned from usersql
Error number - 1007
ORA-01007: variable not in select list
The user defined scan was created incorrectly. The results of the SQL statement must return two columns. Modify the SQL so that it returns two columns.