Issue with running query on Oracle Database

I have an Oracle Database setup as a thing, and when creating a service as a SQL Query I can see all of the tables within the database (so I have a connection) however, when I try to run a query I get the following error message

Unable to Invoke Service AcquireLBSProduced on BeloitPPT : ORA-00942: table or view does not exist

 Unsure why I get the message because the table does indeed exist as I can see it in the tables list when creating the service. Any help is appreciated!