Forum Stats

  • 3,838,996 Users
  • 2,262,435 Discussions
  • 7,900,830 Comments

Discussions

How to call BI report in oracle apex ?

Awais Majeed
Awais Majeed Member Posts: 111 Bronze Badge
edited Jun 21, 2019 2:20PM in APEX Discussions

How to call BI report in oracle apex?

Tagged:

Answers

  • Jaydipsinh Raulji
    Jaydipsinh Raulji Member Posts: 81 Bronze Badge
    edited Jun 21, 2019 2:20PM

    Hi,

    You can create a SOAP based web service reference in apex to call the BI Report.

    Then utilize APEX_WEB_SERVICE.PARSE_RESPONSE_CLOB to parse response collection & WPG_DOCLOAD.DOWNLOAD_FILE to download report file.

    e.g.

    declare  l_response_msg CLOB;BEGIN  l_response_msg := apex_web_service.parse_response_clob(  p_collection_name=>'STELLENT_CHECKIN',  p_xpath=>'//idc:CheckInUniversalResponse/idc:CheckInUniversalResult/idc:StatusInfo/idc:statusMessage/text()',  p_ns=>'xmlns:idc="http://www.stellent.com/CheckIn/"');END;

    Thank You.