Issue with running query on Oracle Database

[ptc-6292144]

Hello,

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

Error executing service

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!

[ptc-6292144]

I was able to figure it out. I needed to put the parent in the query when selecting the table

[rodbastidas]

Hey, I have the same issue, what parent you put into query?