Definition Query not working after join?

forestknutsen1

I have a query that is failing after a join. I have greatly simplified the query to try and pin down the problem. We are using a SDE source with in Oracle 12c.

The cut down query...

exists (select * from ARCFM8.Transformer)

Working fine before the join....

Not working after the join....

Suggestions?

forestknutsen1

Thanks for taking the time to reply Abdullah.

I too noticed the table name change in the dialog. Unfortunately changing it does not affect the query error behavior.

\

It is also weird because the fully qualified name for the transformer fields should be ARCFM8.Transformer.{field name}. And not ARCFM8.Transformer_Transformer_FM.{field name}. 

Even very simple queries fail...