Removing this criteria, or changing it to, for example, R%999, allowed the report to be viewed. Complicated queries in parameter fields may be parsed incorrectly by the application and will cause an error. The subsequent ORA-00054 errors mean that the temp table is now locked and the session needs to be killed before attempting to run the report again. Please contact Support to have the session killed.
Connect and collaborate with fellow Blackbaud users.