APEX IR Saved Report Aliases
In APEX you can save Interactive Reports (IR) default reports as both Primary and Alternate. Both of these types of default reports are available to all users. To save an alternate report, click the Actions
button then Report > Save Report
(Note you must be logged into the APEX developer to save default reports). Select the option to save As Default Report Settings
and the save screen will look like below:
{% asset_img ir-save-report.png %}
In the APEX developer you can now see the saved report (Managers
in this case) and modify its alias. By default a random number will be assign as the alias. You can modify this alias name.
{% asset_img ir-report-attributes.png %}
You can then use the alias to link to a saved report anywhere in your application.
The following query will get a list of all the default reports, their aliases, and a report link for a given page:
select
pr.region_name,
nvl(pir.report_name, 'Primary') report_name,
pir.report_alias,
pir.report_link_example
from dual
join apex_application_page_ir_rpt pir on 1=1
join apex_application_page_regions pr on 1=1
and pr.application_id = pir.application_id
and pr.page_id = pir.page_id
and pr.region_id = pir.region_id
where 1=1
and pir.application_id = :app_id
and pir.page_id = :app_page_id
and pir.status = 'PUBLIC'
;
REGION_NAME REPORT_NAME REPORT_ALIAS REPORT_LINK_EXAMPLE
___________ ______________ _____________ __________________________________________
Report 1 Primary 167050 f?p=&APP_ID.:3:&APP_SESSION.:IR_167050
Report 1 Sal GTE 2000 180055 f?p=&APP_ID.:3:&APP_SESSION.:IR_180055
Report 1 Managers MANAGERS f?p=&APP_ID.:3:&APP_SESSION.:IR_MANAGERS