This discussion is archived
4 Replies Latest reply: Dec 3, 2012 4:18 AM by 973460 RSS

Help required to show the required saved report when the page is opened.

973460 Newbie
Currently Being Moderated

I have developed a page say "Saved Reports" showing the list of saved reports of a user. In the same page, I have provided link to call each saved report. by creating branching using Branch to function returning a Page
I copy the function below:-
x_page_id NUMBER;

CURSOR cur_get_page_id

SELECT page_id
FROM apex_application_pages
WHERE application_id = :APP_ID
AND page_title = :P14_Report_name;

CURSOR cur_get_private_page_id

SELECT page_id
WHERE flow_id = :APP_ID
AND application_user = :APP_USER
AND name = :P14_Report_name;
OPEN cur_get_page_id;
FETCH cur_get_page_id
INTO x_page_id;
CLOSE cur_get_page_id;

IF x_page_id IS NULL THEN
OPEN cur_get_private_page_id;
FETCH cur_get_private_page_id
INTO x_page_id;
CLOSE cur_get_private_page_id;

RETURN x_page_id;


When I click the link it is going to the correct page that contains the saved report. If the page has more than one saved report the first report is listed. I want to show the correct report (i.e. which is called from "Saved Reports" page).

I have to pass the saved report name and change the saved report to the passed report in the IR saved report dropdown list which is not currently happening.

I can get the saved report name that is shown to the user by the script below
'ID: ' +
$('#apexir_SAVED_REPORTS').val() +
', Text: ' +
$('#apexir_SAVED_REPORTS :selected').text()

But I cannot change the report to the required one. I tried
But no luck.
Please help me to resolve.

I am using Oracle APEX version:

Any help on this is highly appreciated.

Thanks in advance.

Edited by: ravichandran.swaminathan on Nov 15, 2012 10:42 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points