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
1
vote
1 answer

BI-Publisher 11g - Create Report with differents Datasources

I need to create a report with different datasources. In my data model I already have the different datasources, my problem is that I don´t know how to create a report (template) with that data model. Please help!! it would be very helpful
Pablo Fontana
  • 21
  • 4
1
vote
2 answers

BI Publisher - ignore section - based on info from XML input data

I have the following scenario: I'm developing a rtf report in BIP desktop 11 containing 3 sections: intro, content, ending. Based on xml input data, each section may generate one or multiple pages. Because each section has it's own unique header and…
Cristian Dumitrescu
  • 63
  • 7
1
vote
1 answer

Passing parameters in BIP reports

I need to pass parameters to BIP report, I am using Siebel and reports are generated by the data from IO mapping (not sql query) If I need to filter out some data should I manipulate it in siebel or should I just pass the parameters to BIP who…
Njk
  • 41
  • 1
  • 6
1
vote
1 answer

Show different page on a page break in RTF template (BI publisher)

I am trying to call a different page after every page break as shown below. The problem here is that my conditions (test2) can only be displayed within the same page as the header / total page but not break into a new page. I tried using…
Synetrix
  • 59
  • 2
  • 12
1
vote
3 answers

how to change pdf output to excel in oracle apps

I have an existing report in AP non-withholding tax, now the report layout was created in report builder in paper layout, the report output was in PDF. Now the user wants the output to be in Excel format, the report doesn't have template and data…
michael
  • 21
  • 6
1
vote
1 answer

How to get Data Header in eText File Template - BI Publisher

I am trying to get a header on my data table, however when I create another group it is repeating the header the same number of times as my data. So if I have 10 rows of data I get 10 header rows. I have attached my eText…
user1660680
  • 97
  • 2
  • 11
1
vote
1 answer

printing pdf in oracle apex 5.1 using bi publisher 11g trial edition

i already installed web logic server and bi publisher but when i open the localhost:7001/xmlpserver/ this was the result how to fix this? i need to generate a pdf report from oracle apex 5.1 the oracle web logic server is opening this was the…
blank
  • 21
  • 5
1
vote
1 answer

apostrophe in BI Publisher

I am working on a rtf file which displays data based on an xml source file. XML Source File: ... Something ... In the rtf file, I have a checkbox that I want to check for a specific value. For example, if I want the box to…
Cristian Dumitrescu
  • 63
  • 7
1
vote
0 answers

The report cannot be retrieved because of an error, please contact the administrator

I have some issues sometimes with reports. Sometimes it works fine, sometimes when I click on it, I have the issue shown in the screenshots. Please help!
Nina
  • 11
  • 1
1
vote
2 answers

What is the proper way of formatting date in select query Oracle SQL

For suppose if I want sysdate, SELECT SYSDATE as system_date FROM DUAL; should output in the following format 14-Feb-2018 T19:50:02+00:00 i.e., DD-MMM-YYYY Thh:mm:ss+HH:MM
Sai Nikhil
  • 1,237
  • 2
  • 15
  • 39
1
vote
1 answer

Creating a sequence number in RTF templates for BI Publisher

I have a RTF template with a column EVENT. I want to display the events in the EVENT column as 'event-1", 'event-2', etc... at run time. I tried using the following codes in the text/form field but none are working and instead giving me the same…
namrata
  • 11
  • 1
  • 3
1
vote
1 answer

Using SUM in XSL concatenates value instead of adding it in Excel template

I am having an issue where the fields I am trying to sum is getting concatenated in XSL. I have tried the solutions given at the following threads but none of them is working for me. The requirement is to create the excel template for Report where…
user9302368
1
vote
1 answer

NLS_DATE_LANGUAGE issue with a few languages

I have written the following code to fetch a date based on the users NLS_LANGUAGE variable. I am writing this code in BI Publisher inbuilt in Oracle Fusion but i doubt that it will matter. I have seen that it works fine for AMERICAN, SPANISH, etc…
prince
  • 854
  • 2
  • 9
  • 36
1
vote
1 answer

BIP Scheduling through Web services and Repeat Interval

I am trying to Schedule a report in BI Publisher through web Service. And I want my report to be scheduled monthly once automatically. I am using Repeat Interval for passing my frequency. But the problem is It accepts the value in milliseconds. So…
Bharathi Murugan
  • 13
  • 4
1
vote
3 answers

Right align xml data while generating PDF using fo:list-block

I have number list in my XML input And I am able to align list body(text content) to align right, but numbers remain aligned to left. How can I align entire list including numbers/bullets to right, by default is comes to left. Any help or pointers…
Ashu
  • 43
  • 8
1 2 3
…
35 36