are you sure that report query doesn't have schema definition.
There is no schema on the select that is why if I modify the IR page and save it the report refreshes with the correct data.
I can't change the report manually since we would deploy this to many clients, thanks
it looks like the error is coming from the Fetch Row page process (in Pre-rendering section) on the target page. Please, make sure that the Table Owner attribute is correctly specified in the Fetch Row process.
It seems like this is an APEX BUG/Limitation on selecting ROWID with multiple table from.
SELECT a.rowid, b.empno
FROM dept a, emp b
WHERE b.deptno = a.deptno
This would always work in SQL but not in APEX when you inserted a lot of data after an import of an app. It seems like if you change the IR query even if the same it would work fine. IR does not seem to refresh.