This content has been marked as final. Show 4 replies
If you use the PAGE_ID you get the default report on the IAR page.
If you fetch the column REPORT_ALIAS from WWV_FLOW_WORKSHEET_RPTS ( and not the PAGE_ID ) and run that "page" then you should get the desired stored IAR.
These aliases can also be seen on the Saved reports tab of the Interactive report region, in version 4.2 there is also an example of a link to the saved report on that page but I'm not 100%sure if that was also there in 4.1 (just check and see).
f?p=101:10:&APP_SESSION.:IR_REPORT_47167 in which 47167 is the alias for the saved report.
But probably your problem is that you're using user reports and not saved default reports. Behind the user reports I don't see an alias so I'm not sure if this way will work for you. I will try to check when I find time (might take a while).