failed to parse SQL query: ORA-01403: no data found
I'm going to post and answer my own question in the hope that others will not have to struggle with this error.
Using a report of the type PL/SQL Function Body Returning SQL and using generic columns you may run into this error
failed to parse SQL query:
ORA-01403: no data found
The SQL will run stand alone but the report fails.
There is a setting just below the source you should check:
"Maximum number of generic report columns"
In my case the number of columns was dynamic and when it exceeded the number set as the maximium number of generic columns I received the 1403 error.
Hope this helps someone.
Greg