BIP Integration with Oracle Forms

We have had quite a few enquiries about how BIP might/can integrate with an Oracle Forms application. I have been doing some digging and testing but again I need to thank another Oracle team for doing all the leg work. Jurgen Menge and his sales consulting team in Germany have been looking at this for a while and come up with multiple possibilities, each of course with thier own pros and cons. So if you are looking for a way to integrate your Oracle Forms application with BIP read on.


1. Calling BI Publisher application via URL
 - using Forms Built-In web.show_document(<url>);
 - principally the same mechanism as calling Oracle Reports except you would use
   the run_report_object function.
 - some restrictions concerning security and functionality namely you will need SSO to hook the
   two applications together to prevent dual sign on.


2. Integrate BI Publisher classes into Forms using API functions
 - write some class based on the BI Publisher APIs taking data, template, output format, etc 
 - import the class using Forms Java Importer (PL/SQL wrapper will be generated inside Forms)
 - add BI Publisher libs into classpath for Forms server
 - program some trigger or button to call the PL/SQL functions of the wrapper
 - restriction: BI Publisher libs on the same server as the Forms service is running


3. Writing a servlet using API functions
 - write a servlet based on the BI Publisher APIs similar to #2
 - using Forms Built-In web.show_document(<url>); to call the servlet
 - BI Publisher libs can be on a different server as the Forms service is running
 - great flexibility concerning parameters, functionality, security etc.


4. Calling BI Web Services from Forms
 - the same as 2. but importing the web service stub instead the class
 - stub can be generated in JDeveloper
 - keep in mind that Web Service API is still not public
 - Forms service can run on different server than the Web Service


I have tested 1, 2 and 3 ... 4, I have not and we have not currently documented the web services but I want to let you know that we are working on completely web service enabling the BIP server in a coming release so integration of applications with the BIP server will become more straightforward.

For those of you on EBS 11i, as you know the Forms version in there is 6i, I think your options are going to be more limited for direct integration with the java APIs. There is relief in sight, we are now looking at a solution built on top of the forms personalization layer to allow direct integration into the XMLP functionality, so you can hit a button and generate a document there andthen without the need to wait for the concurrent manager to process and request ... more soon. 

Comments:

Respected Tim Dexter, Thanks for the blog "BIP Integration with Oracle Forms" this gives some idea on calling a BIP report from forms. On the same time I request you to elaborate these methods, and please tell how can we pass the parameters.

Posted by jacob alexander on March 03, 2007 at 11:00 PM MST #

can you please elaborate

Posted by jacob alexander on March 05, 2007 at 10:42 PM MST #

Hi Jacob Im working on another posting with my examples Tim

Posted by Tim Dexter on March 07, 2007 at 01:48 PM MST #

I used you mehtod 1 : using Forms Built-In web.show_document() to put a BI report into form. When I run it from the form button, I got the BI sign on screen. I already sign on when I run the form, How can I avoid signon again, like you said "to prevent dual sign on." Thanks.

Posted by Bin on September 09, 2008 at 02:51 AM MDT #

using Forms Built-In web.show_document() to put a BI report into form. When I run it from oracle form , I got the BI sign on screen., How can I avoid signon while calling from oracle form. Kindly help from the above scenario....

Posted by Prakash Ramamoorthy on October 13, 2010 at 09:38 PM MDT #

using Forms Built-In web.show_document() to put a BI report into form. When I run it from oracle form , I got the BI sign on screen., How can I avoid signon while calling from oracle form. As well as how to pass parameter to BI Publisher from oracle form.. Kindly help from the above scenario.... Very urgent........

Posted by Prakash Ramamoorthy on October 13, 2010 at 09:41 PM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today