Oracle Reports (FMW)11g (11.1.2.2.0) issues
I recently built an Oracle 11.1.2.2.0 Forms and Reports application server which normally works fine. However I have uncovered an unusual issue with reports which I'm having trouble cracking. It might need to log an SR with this but will try here first in case anyone has come across it before.
Running reports via the in-process or standalone reports server normally executes fines. We have noticed a situation where a report may fail either due to invalid parameters being entered, or the query in the report fails due to the SQL error. The full descriptive error details are being written as expected to the EM report server job queues and the various report server log files.