Report failing with "SQL profile or patch name specified is invalid" But there is no profile or patc
I have an oracle report - 11g FMW that returns 12 records.
It fails to execute when it has to process a lot of records (5~6 mil).
It was failing with "REP-300: SQL profile or patch name specified is invalid". I removed the profile and ran the report again and the issue was resolved.
After a few weeks - the report began to fail with a timeout. The timeout setting is 6 mins and the sql alone completes in ~2 mins (same params etc).
Now it is failing again with "REP-300: SQL profile or patch name specified is invalid". There is no profile in DBA_SQL_PROFILE and there is no SQL Patch in DBA_SQL_Patch.