Oracle Reports (MOSC)

MOSC Banner

Report failing with "SQL profile or patch name specified is invalid" But there is no profile or patc

edited Jan 25, 2019 6:06AM in Oracle Reports (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center