Hi there,
Greetings.
Oracle 11.2.3.0 Enterprise Edition
Apex 4.2.3
We are having a weird issue with an apex interactive report, in which the query returns the duplicate rows. We checked the query for any possible reason that query returned the duplicate rows, but found that if we run the same query in the Apex SQL workshop, or in sql plus, it returns the correct numer of rows.
Below is the simple query:
{code}
select vpas.*, birth_family_name birth_family_name_opt
from vr_apr_apms_405_r vpas
where person_id = 23001
{code}
We ran the page in debug mode and found that the Query was running twice. Attached is the screen shot of the debug information. (
We couldn't figure out why apex is running the query twice. We could delete and recreate the report region, but the report contains more number of columns with the customized column title and sorting order, recreating would be a tedious job for us. Can any one help to figure out why apex is causing this trouble?
Thanks in advance.
Natarajan