Migrating reports from 10g to 11.1.2 - problem with reports using parameter fields
Hello, I'm trying to migrate 10g reports to 11.1.2 and am finding that reports using parameters are failing. They either return no results or give an error:
REP-0788: The value of restricted LOV parameter P_STATUS is not among the selectable values.
where p_status is a parameter referenced in the sql query (as :p_status) that generates the report data. Is there some change in the way parameters are handled in 11.1.2. I was hoping to have an easy migration and have to simply re-compile the reports in the new version.
REP-0788: The value of restricted LOV parameter P_STATUS is not among the selectable values.
where p_status is a parameter referenced in the sql query (as :p_status) that generates the report data. Is there some change in the way parameters are handled in 11.1.2. I was hoping to have an easy migration and have to simply re-compile the reports in the new version.
1