Home » BI Publisher
Category Archives: BI Publisher
Oracle XML Publisher / BI Publisher Tables
Oracle XML Publisher / BI Publisher Tables
This article from Oracle Apps Community
The article direct link Oracle XML Publisher / BI Publisher Tables
Summary
In this article you find a list of oracle XML publisher tables.
How to re-group XML data in RTF Template
How to re-group XML data in RTF Template
This article from Adiva Consulting
The article direct link How to re-group XML data in RTF Template
Summary
If we need the grouping, it is always advisable to generate the XML as per the required hierarchy. This makes the RTF design simple and perform better. But there are situation when we do not have control over XML structure and need to work on flat XML. Lets see how we can create multiple nested grouping in RTF template.
Oracle BI Publisher User Creds on a URL
User Creds on a URL
This article from Oracle BI Publisher Blog
The article direct link User Creds on a URL
Summary
A long while back I posted an entry on linking to a report via a URL. All was good but it only worked if you either:
1. Were hooking BIP up to SSO with your calling application or
2. You placed the report in the Guest folder which was unsecured.
You can now pass the username and password on the URL to avoid the two cases above and open up other possibilities.
SOA does not start with error “An unknown OPMN error has occured”
SOA does not start with error “An unknown OPMN error has occured”
This article from ORACLE BPEL IN DEPTH
The article direct link SOA does not start with error “An unknown OPMN error has occured”
Summary
When did I get this?
I have a fresh installation of SOA suite on my stupid Vista laptop.
I had a hard time getting this into it in the first place.
I was damn happy getting this into it and I though wow here I go.
But damn stupid thing, after re-starting my system I could not get the SOA suite working.
I capture what I did to get this wonderful thing working.
What is this error and why I write this?
The first bolt I got was this
“An unknown OPMN error has occurred”
“Error connecting to OPMN (is it running?): Connection refused: connect”
This was when I tried to start SOA suite from the “start SOA suite” from start menu.
Matrix (Cross-Tab) Report in BI Publisher
Matrix Report in BI Publisher
This article from Apps To Fusion
The article direct link Matrix Report in BI Publisher
Summary
A matrix (crosstab) report contains one row of labels, one column of labels, and information in a grid format that is related to the row and column labels. In other words, a matrix report displays the data in a grid. A distinguishing feature of matrix reports is that the number of columns is not known until the data is fetched from the database.
This article guide you step by step to build Cross-Tab/Matrix reports in XML Publisher.
Oracle BI Publisher Building Data Template [PDF]
Oracle BI Publisher Building Data Template
This article from Mohammad Fawzy
The article direct link Oracle BI Publisher Building Data Template
Summary
The BI Publisher data engine enables you to rapidly generate any kind of XML data structure against any database in a scalable, efficient manner. The data template is the method by which you communicate your request for data to the data engine. It is an XML document whose elements collectively define how the data engine will process the template to generate the XML.
you can download the bipublisher building data template document form the following link:
bipublisher_building_data_template.pdf