An Oracle blog about BI Publisher

APEX integration with Publisher Web Services

Guest Author

At ODTUG a few weeks back I saw Marc Sewtz's excellent presentation on the integration between Oracle Application Express (APEX) and BI Publisher. Lots of good examples and tips.

He mentioned a recent white paper on integrating Publisher with APEX via the Publisher web services by Jason Straub. Delighted to see this. Trying to pull it all together in one place, here is a collection of great references for APEX developers wanting to integrate with BI Publisher.

PDF Printing in APEX

from the APEX OTN pages

Apex Integration I


Apex Integration II

by Tim

Calling BI Publisher report from APEX via URLs

by Dimitri

BI Publisher Web Services and APEX

by Venkat

Call BI Publisher Web Services from APEX

by Tyler

and the most recent addition to the series ...

Integrating Oracle Application Express with BI Publisher

white paper by Jason

A fine example of evolutionary collaboration.

Thank you all.

Join the discussion

Comments ( 1 )
  • Prem Monday, August 31, 2009
    Hi Tim,
    I am new to BI Publisher. I have managed to build a RTF template to print a check on a pre printed stationery (For Oracle Apps). There are two issues I have:
    1. The check I need to print has the invoice lines on top repeated twice and the actual check at the bottom. The isse is when i print multiple invoice lines and it exceeds the section allocated for invoice lines, it pushes content down and my alignment is destroyed. What i need to do is once a certain number of lines are printed it should print the balance lines in a different file and continue the check as usual. I figured that bursting may be an option but most of the stuff on the internet points to pushing the content through email when bursting. Is there anyway to achieve this.
    2. When displaying output in columns I want to achieve this in a table not using word colums

    c1 c2
    Invoice Num - Amount Invoice Num Amount
    1 10 4 10
    2 9 5 9
    3 20 6 34

    Extral lines after the end of this section should go into a differnt file
    Any help will be greatly appreciated. Thanks
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.