SQL Statement Working in SQL Developer But Not Database Connector
I am in the middle of writing an Orchestration to extract all suppliers created last week for loading into an external system. I have an SQL statement that works fine in SQL Developer, but when run in the Orchestration using a Database Connector I get an ORA-00900 Invalid SQL Statement error. We have table F0101 being audited using the 21CFR11 functionality within E1 and the SQL is referencing the Audit table, A0101. Could this be the issue?
Any suggestions or help would be most welcome. We are running E1 on Oracle Cloud with Apps 9.2.3.3 and TR 9.2.8.4.
Thanks
Jonathan
*****************************
select aban8, abalph, nvl(aladd1, ' ') as aladd1, nvl(aladd2, ' ') as aladd2, nvl(aladd3, ' ') as aladd3, nvl(aladd4, ' ') as aladd4, nvl(aladds, ' ') as aladds, nvl(alcty1, ' ') as alcty1, nvl(alcoun, ' ') as alcoun, nvl(aladdz, ' ') as aladdz, nvl(alctr, ' ') as alctr, nvl(drdl01, ' ') as drdl01, nvl(abtax, ' ') as abtax, nvl(absic, ' ') as absic from TESTDTA.f0101 left outer join TESTDTA.f0116 on alan8 = aban8 left outer join TESTCTL.f0005 on drsy = '00' and drrt = 'CN' and trim(drky) = trim(alctr) where exists (select aban8 as t1an8 from TESTDTA.a0101