If a revision column name in an Oracle db is defined with spaces in it, The Oracle connector generates a wrong query to check the db revision.
This is a product defect (30901)
Switch off revision filtering.
This will be fixed on a future release of the product. If you require this immediately corrected, please contact support for a hotfix referencing the defect ID 30901.