SQL executing giving wrong results in OHR
Hi,
We are currently in the exercise of upgrading our Oracle database from 11g to 12c in Oracle EBS environment.
We have a problem with incorrect query results when we have the Adaptive Query Optimizer feature enabled.
When we run a query where the result column is a 2-level correlated subquery, if the child inner query (more than 1 level) joins to the grandparent outer query, there will be no result returned (NULL).
This is not expected.
The workaround is to always join to immediate parent and not the grandparent outer query.
But this is not always possible and we are afraid this might affect all Oracle EBS standard programs as well (I do not see the reason why it shouldn't).