APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling a BI Publisher report using a button from a page

gkthomasAug 20 2022 — edited Aug 20 2022

I have a report query report , which uses RTF template for BI Publisher . The report output is PDF and report layout is RTF created in BI Publisher desktop . Test report works fine . When the report is called as a list item , it is working fine as well.
However when I call the report using a button, on an apex page, I get an error page.
In the button ,behavior the action: Redirect to URL. and the URL is the print URL seen on the Report query section. When I click the button , from the page. I get the following error
Can someone help me to find what am I doing wrong?
I am on Oracle APEX 22.1.2. using chrome browser.
Error page
***************************************************************
This page cannot be invoked using a URL or using a GET or POST to the show procedure, it must be called using a "Branch to Page" branch type.
Contact your application administrator.
Technical Info (only visible for developers)
is_internal_error: true
apex_error_code: WWV_FLOW.PAGE_PROTECTION.SHOW_NO_URL_ALLOWED
component.type: APEX_APPLICATION_PAGES
component.id: 70731000000000
component.name: Global Page
error_backtrace:

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0xfd3f0098       980  package body APEX_220100.WWV_FLOW_ERROR.INTERNAL_GET_ERROR
0xfd3f0098      1048  package body APEX_220100.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR
0xfd3f0098      1521  package body APEX_220100.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR
0x102ab9f08      2817  package body APEX_220100.WWV_FLOW.SHOW
0x10274b768       173  procedure APEX_220100.F
0xfd407740         2  anonymous block

Added on Aug 20 2022

#apex, #apex-discussions

2 comments

1,599 views