I did a quick google-around and sounds like this error usually occurs if you are using old client/driver to connect to Oracle. You computer should have installed an Oracle client and a Tableau Oracle driver. Maybe check if both are up-to-date. If not, upgrade and see if it fixes the problem.
You don't get this error on Excel and extracted data because the error comes from Oracle database management system, Tableau just displays to you what Oracle "said".