Stack Overflow
Stack Overflow

Questions tagged [bi-publisher]

Business Intelligence Publisher - Oracle's reporting application.

First released in 2003 as part of Oracle's E-Business Suite it has now been integrated into many of the Oracle products and is also available as a standalone application. It is capable of generating XML data from SQL queries, XML files, web services, LDAP, MDX queries, Excel files and Oracle ADF View objects.

532 questions
0
votes
0 answers

SUM for expression field in RTF BI Publisher

currently, I got some problem in doing my RTF Template. the units field, im using expression '' the problem is, when i want to make the…
Ashraf Syamim
  • 1
  • 1
0
votes
1 answer

Repeat Column Headers in BI Publisher Excel Templates in fusion

In fusion BIP report, when data in excel template exceeds 65536 rows it gets splitted into multiple sheets. I have a requirement to repeat column headers in BI publisher excel templates when the data split into multiple sheets. For every sheet…
ann 14
  • 1
0
votes
1 answer

Oracle BI Publisher: Error occurred on retrieving data xml

While viewing a report in BI Publisher, the interactive viewer starts loading then displays the following error: if I choose a different way to view (HTML, Excel) it works fine. I checked the permissions of my user and added all of them to the data…
Rima
  • 457
  • 2
  • 7
  • 18
0
votes
1 answer

"if" and "or" condition in the RTF template not working

I am trying to use or condition in the rtf template but its not working and not taking all the conditions. This is not working and i am still getting the…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
0 answers

BI Report query to get shipping method and carrier name for sales order lines in oracle fusion

I'm trying to create a BI Report which queries sales order lines details, including shipping method and carrier name. But I'm unable to find the correct joins for this. Till now I have an alternative query which retrieves carrier_name for the sales…
Nirbhay
  • 59
  • 4
0
votes
1 answer

Oracle loud BI Reporting : Xls template

I am developing a report in BI report using xsl template. I have a doubt regarding adding two fields. In rtf template we use . But if I do the same in xls template, it shows an error 'Namespace prefix 'xdofx' used but not…
Swetha Ravikrishnan
  • 13
  • 4
0
votes
2 answers

BI Publisher not compiling ?

I'm using MS Word to create rtf templates for Oracle BI Publisher. My goal is to conditionally assign a color to the title in the header section. My xsl code looks like this:
C. H.
  • 38
  • 5
0
votes
1 answer

How to make a field (column value) span multiple rows in Excel Templates to be used in Oracle BI Pub Reports?

I am creating an Excel Template for BI Pub Reports, Sample XML is generated using Oracle BI Pub Data Model. My Data Model is like this :- My sample XML is here:-