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

How to display parameter value separated by comma in table in rtf using bi publisher

I have tried to use extended function to separate these values but the problem is that I am able to separate only one value. https://isu.ifmo.ru/docs/XMLP/help/en_US/htmfiles/B25951_01/T421739T421827.htm
riya
  • 21
  • 4
1
vote
0 answers

Error loading xml data in my RTF template: "An invalid character was found in text content."

Upon loading my data on RTF template, I am getting an error saying "An invalid character was found in text content". I extracted the xml data from BI Publisher. Is there any fix on BI Publisher in order to fix this issue? I only get this error…
BI Publisher user
  • 19
  • 3
1
vote
1 answer

Group Filters in BI Publisher

Can we have multiple group filters created in BI Publisher? I want to have more than 1 group filter i.e for example SAL >5000 & DEPT_ID IN (10,20). Right now I'm able to add only 1 group filter. Will BI Publisher allow me to add multiple group…
Maddy
  • 11
  • 2
1
vote
2 answers

ORA-20001: The printing engine could not be reached. Oracle Apex 5 with BI Publisher 11.1.1.7

I am working on Apex 5, want to run bi publihser report with apex. I created instance in Manage Instance>Report Printing of apex Host Address : localhost Port:7001 Print Server: /xmlpserver/convert Now created report query but when i click "Test…
Azam Sajid
  • 41
  • 2
  • 11
1
vote
1 answer

IF-Conditions in XSLT

I do not understand why the following code is not working in an XSL-FO sheet. In that line: I get the error: (Fatal Error)…
placebo
  • 11
  • 6
1
vote
3 answers

BI Publisher in MS-Word

I have a field with several Null values and several text values. I am using BI Publisher in Word. How do I apply something like this: If the values are all null, the result = "N" If the values has even one not null, the result = "Y" And should this…
Null2
  • 43
  • 1
  • 2
  • 5
1
vote
0 answers

BI Publisher Ring Chart Thickness

I am relatively new to BI Publisher and I have to date only worked with line and bar charts. I am working on a report that uses Ring Charts, and the default thickness of the chart is too much. I want it to look like a hoola hoop and not a doughnut,…
Simon
  • 1,293
  • 5
  • 21
  • 39
1
vote
1 answer

Template nested grouping with Sort option

I would like to generate a report using RTF Template which looks like the below: Expected Output: US Cover Insured 123456 INS1, INSB, INSA 987654 INS2 or US Cover Insured 123456 INS1 INSB INSA 987654 INS2 Here "Insured"…
Anna Joel
  • 107
  • 3
  • 14
1
vote
0 answers

Bi publisher - querying custom user attributes

How to use custom user attributes on BI PUBLESHER reports? xdo_user_name and other systematic user attributes are being displayed after a report is being processed by data model Data model consists of: select :xdo_address as address from dual; After…
Nako
  • 125
  • 7
1
vote
1 answer

date range in oracle apps report

The following sql when run with these parameters, :P_COMP_DATE_FROM = '15-NOV-2015' :P_COMP_DATE_TO = '15-NOV-2015' compares as between '15-NOV-2015 00:00:00' and '15-NOV-2015 00:00:00' Select Ordered_date From xxcost_rep Where DATE_COMPLETED…
Muhammad Nadeem
  • 23
  • 1
  • 10
1
vote
2 answers

Name of BI Publisher Reports

I am developing reports using BI Publisher 11.1.7. The problem is that when end user downloads the report. The name of file is like this "report name_layout name" and space exist in name are replaced by %20 which looks quite wired. Is there any way…
user3729199
  • 85
  • 2
  • 8
1
vote
0 answers

BI Publisher 11.1.1.9.0 with JDK 8 on Weblogic 10.3.6

I have installed OBIEE (v. 11.1.1.9.0) on Weblogic 10.3.6., extending an existing domain. My requirement is to use JDK 8. When I start up the servers, the following error is encountered and BI fails to start. The error is while loading…
Nitish Borade
  • 367
  • 3
  • 18
1
vote
0 answers

SQL - Return Null values when a value is provided

I am developing a report in BI Publisher that accepts user input as search criteria and the results are rendered into a pdf template. The user input is used as parameters in the SQL query I have to do the search I am testing with the following…
Asher Brooks
  • 19
  • 7
1
vote
1 answer

Oracle - get actual query with variables replaced

I am aware I can SELECT sql_text FROM v$sql to get the query but this is not the actual query being run since it still contains variables. For instance it returns SELECT H.TYPE, H.STATUS, L.FLAG_2, L.QTY_ORDERED FROM ODH H, ODL L WHERE…
Steve Lloyd
  • 773
  • 2
  • 12
  • 33
1
vote
0 answers

How to pass parameters from APEX to BI Publisher?

I have a BI report (excel), depending on the parameter (customer_id). I need to run it thousands of times with different values of this parameter. How can I run this report from the APEX cyclically changing this parameter?
antropka
  • 21
  • 2
1 2 3
…
35 36