Solution to the issue was casting oracle values as number in source.

What's interesting is that another solution that worked was to specify N number of rows to fetch in source (worked even without cast function).