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

Oracle BI Publisher multiple select parameters

I have a requirement to have multiple select parameters on a BI Publisher report. I am passing the parameters to a function that turns a comma separated list of values to a table. I then use the tables from the csv parser function in "IN"…
rdittmer
  • 13
  • 1
  • 4
0
votes
1 answer

Oracle BI Publisher Report output is not opening in LibreOffice

We are using Oracle BI Publisher as repoting tool. We have designed the template in RTF format and uploaded into bi publisher also using the query to generate report output as Excel format. But the excel output is not opening in LibreOffice 4.3. How…
Manmeet Kaur
  • 1
  • 1
0
votes
1 answer

Check for a value in XML in Oracle BI Publisher 11g

Below is my xml sample. Here's what I want Loop through all cars If a car has a "Sport" style then display them, otherwise, ignore it So in the example below, I will display Ferrari and 2 values of Convertible and Sport I have…
Andy
  • 195
  • 2
  • 5
  • 13
0
votes
1 answer

BI Publisher Interactive Template no data found

Version 11g Release 1 (11.1.1.7) I have created the data sources in BIP with seperate single data set using a simple select * SQL for each data source. The view sample data works fine. The issue comes when trying to create a report template using…
Rhasz
  • 11
  • 1
  • 5
0
votes
1 answer

javax.xml.ws.soap.SOAPFaultException: org.xml.sax.SAXException: Found character data inside an array element while deserializing

I'm using bi publisher webservices api to assign roles to users. The code for this is SecurityService_Service sevice = new SecurityService_Service(); SecurityService securityService = sevice.getSecurityService(); List rolesList=new…
Obulesu Bukkana
  • 995
  • 4
  • 13
  • 25
0
votes
0 answers

Print Two different Nodes as siblings in 3 Columns

i would like to get Box and Folder Elements as Siblings in 3 columns with Box order. …
user3532882
  • 3
  • 2
0
votes
2 answers

Passing parameter from jsf to bi publisher report

I've been trying to solve one tricky problem. How does one pass a parameter, say, an integer from jsf page to the actual bi report? In more detail: [jsf page]---backing bean takes parameter(an id)---?--- bi report with parameter input(id) So far, I…
user1150569
  • 13
  • 4
0
votes
0 answers

PeopleSoft BI Publisher showing Error generating report output: (235,2309)

I am Using Peoplesoft. I am creating a sample report in BI Publisher. I have created PS Query, DataSource, Report defn and all. While generating the report in Query Report Viewer, It is showing the following error. Error generating report output: …
Lemon
  • 13
  • 1
  • 6
0
votes
1 answer

why custom dateformats not working in oracle bi web service parameter?

I am using Soap-UI to call Oracle-BI web service runReport to generate a report. Its working fine for reports with no report parameters. But when I am passing Date parameters with dateFormatString defined, the report doesn't show any result.…
th1rdey3
  • 4,176
  • 7
  • 30
  • 66
0
votes
1 answer

Oracle BI - publisher error "unable to extend table APPLSYS.FND_CONC_PP_ACTIONS"

We're geting this error when we remote-login into the BI publisher server. is there anything we can do about it? I read through a website that describes it, but not sure how to go about this. Does the fact that we VPN into it affect things(i.e…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
0
votes
1 answer

How do you see what responsibilities are present in your version of the e-Business suite?

Just curious , my boss asked me to "see what responsibilities are present " in the Oracle e-Business suite . For example , maybe we have XML BI Publisher, Order Management, etc responsibilities . I'm not exactly sure where to go to find this…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
0
votes
1 answer

Issue in printing brought-forward and carry-forward totals in BI Publisher

We are developing a BI Publisher invoice print report using RTF layout. This report prints the customer details at the top of the page, followed by the invoice lines' details, and a summary table (of amounts and taxes) at the bottom of the page.…
user2275479
  • 73
  • 1
  • 4
  • 8
0
votes
1 answer

Show different header on first page of RTF template (BI publisher)

I came across a problem while creating RTF template for BI publisher. I am displaying a table in the header (not an MS word header but header identified as something above start:body tag) of an RTF template. That table has 3 rows, I need to display…
coolscitist
  • 3,317
  • 8
  • 42
  • 59
0
votes
1 answer

need help formatting a date parameter in Oracle BI Publisher RTF template

I'm not talking about using the parameter in the data template - I'm all set there. I need to know how to change the format of a parameter once it hits my RTF template. I have This gets my parameter from the…
end-user
  • 2,845
  • 6
  • 30
  • 56
0
votes
1 answer

PHP sending data to BIPublisher plugin

I am asked to study a Proof of Concept and I can't find anything telling me the following can be a solution. Indeed, I have to process some data to find which .docx or .rtf template I have to use and build a XML file that can be loaded by the Oracle…
GnsBeldaran
  • 150
  • 8
1 2 3
…
35 36