Hi All,

I have a db query, Select * from {class:A} f where f.PXINTERACTIONID in
(select interactionid from {class:B}
where passedlimit='false' and campaignrunid = '{ASIS : MTemp.CAMPAIGNRUNID}' )

The problem is when I hard code the schema and table names then only above query runs, else we get an error "ORA-00942: table or view does not exist ". However I when I do Test Connectivity from Connect-Sql rule with class references, the schema and table name are picked up correctly and test connectivity is successful.

Database Table mapping is also in place and Test Connectivity work fine.

Any suggestions why this could be failing?

***Edited by Moderator: Pallavi to update platform capability tags***