Oracle Apex - Create button for BI report URL.

How to Call BI Publisher Report from Oracle Apex?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

You have created a report using shared component's report query and report layout options and now you want to call that report. Here in this tutorial, you will learn how to call a BI publisher report from Oracle Apex using a button. Follow these steps:

Call a BI Publisher Report from Oracle Apex Example

  1. In Oracle Apex, click on the Shared Components > Report Queries as shown in the below image:

Oracle Apex - Report Queries

  1. Now the list of the Report Queries will be displayed. Select the report query you want to call from Oracle Apex page using a button. Then set the Output Format as PDF and View File as Inline and copy the report URL as shown in the below image:

Copy BI Report URL - Oracle Apex

  1. Save the changes and open the page in which you want to add a button to call the report in Oracle Apex page designer.
  2. The create a button on that page and set the following properties shown in the below image:

Oracle Apex - Create button for BI report URL.

Now save the changes for the page and run. Then click the button to test your BI Report.

BI Report Print Button Example Oracle Apex.

See also:

This Post Has 11 Comments

  1. George November 5, 2020

    Can I use the Oracle BI Publisher Desktop version or do I have to install the full Oracle Business Intelligence

    1. Vinish Kapoor November 6, 2020

      You only need to install Oracle BI Publisher Desktop. Then you will get the BI Publisher add-on for MS Word to create report templates.

    2. George November 7, 2020

      Do I have to install a server to run Oracle BI Publisher Desktop?

    3. Vinish Kapoor November 7, 2020

      No. You only install Oracle BI desktop. Then in menu you will find an option to enable BI publisher plugin for MS Word.

  2. MUHAMMAD MANSOOR November 26, 2020

    sir g how to call report parameter emp_no against.
    plz tell me

    1. MUHAMMAD MANSOOR March 6, 2021

      Plz explain how to excel upload in oracle apex form 
      

  3. BRUNO SILVA February 1, 2021

    When I create an environment in the oracle database autonomous you don't have a print server! Do you know if this bi publisher is free? How do I configure it in the free oracle environment?

    1. Vinish Kapoor February 2, 2021

      I didn't find any option to configure BI in the free Oracle database autonomous. But you can try creating layout and query and test, I think it should work.

  4. MUHAMMAD MANSOOR March 6, 2021

    Plz explain how to excel upload in oracle apex form 

  5. shashi kumar June 16, 2021

    Hi actually i tried calling the BI report as you specifeid but iam geeting the error as The print engine could not be reached becasue either the URL specified is incorrect or a proxy URL needs to specified.

  6. srikanth November 24, 2021

    Getting Error if I navigate to Button URL

    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. Details about this incident are available via debug id "1036039547".

    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: 29247000000000
    error_backtrace:
    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    0x3a991ebd28 976 package body APEX_210200.WWV_FLOW_ERROR.INTERNAL_GET_ERROR
    0x3a991ebd28 1044 package body APEX_210200.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR
    0x3a991ebd28 1517 package body APEX_210200.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR
    0x3a9af3d160 2817 package body APEX_210200.WWV_FLOW.SHOW
    0x3b316b8218 173 procedure APEX_210200.F
    0x3b58aabb90 2 anonymous block

Comments are closed.