I have a requirement where DB adapter needs to poll two tables A, B which have a relation 1:M. I use polling operation and define relationship between the tables. generated xsd seems fine and the query also runs on sql developer . But post deployment my SOA process is unable to poll data.
query-
SELECT DISTINCT t1.field1,
t1.field2,
t1.field3,
t1.field4,
t1.field5,
t1.field6,
t1.field7,
t0.field1,
t0.field2,
t0.field3,
t0.field4,
t0.field5,
t0.field6,
t0.field7,
FROM A t0,B t1
WHERE (((t0.field4 IS NULL) OR (t1.field4 IS NULL)) AND (t0.field1 = t1.field1));