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
2 answers

Data Set in BI Publisher

While creating a dataset in BI Publisher, which one is more optimized? Select * from OR select column1, column2 from table_name? Is there any difference between mentioning specific columns and doing a select all statement? provided…
Imran Hemani
  • 599
  • 3
  • 12
  • 27
0
votes
0 answers

concatenate date column from DB with report output name for scheduled report?(No bursting)

How can we concatenate a column with report output name.this column value is different from "sysdate" or "systime".no bursting should be implemented.Is there any way we can achieve this?
mona16
  • 46
  • 8
0
votes
0 answers

Autosized page in XSL-FO?

is it possible to program a XSL-FO template using an autosized page-width and page-height expression?
placebo
  • 11
  • 6
0
votes
1 answer

How to: If values present, output: "Y" If null, output: "N"

Most of the question is in the title. If there is a value present in the database (doesn't matter what it is as long as it's not null), I want the output to say "Y" or "Yes" --it doesn't matter. I just need it to say what I want it to. I don't care…
Null2
  • 43
  • 1
  • 2
  • 5
0
votes
1 answer

Oracle BI Publisher, RTF Template Date format

I have used "Date, MM/DD/CCYY" under the column in the RTF, when used in SQL developer I get proper output where CC is replaced with century(e.g. 03/07/2016 as per the format "MM/DD/CCYY" will be 03/07/2116 [21st century]) but in RTF I get…
Kushal
  • 1
  • 4
0
votes
1 answer

Date in LOV Query

I have a report that has two parameters, PM_DATE and PM_STOCK_ID. It's LOV query is SELECT DISTINCT ID FROM STOCK_COUNT I want to filter the parameter PM_STOCK_ID based on the date which user specifies in date parameter. In the where clause of LOV…
Imran Hemani
  • 599
  • 3
  • 12
  • 27
0
votes
1 answer

Access is denied when creating file using BIPublisher

Well, I upgraded my development pc to windows 10 from windows 7. When I try to run my application that was previously working now it generates a weird error. I use BIPublisher.FOprocessor to generate pdfs for reporting. I use jdk7 with…
MaVRoSCy
  • 17,747
  • 15
  • 82
  • 125
0
votes
1 answer

2 or more sub-templates in BI Publisher

Can 2 or more sub-templates be added to a main template in BI Publisher? We have a requirement where we need to separate out Addresses and Personal details of a client for re-use in various templates. I tried calling 2 sub-templates (in different…
ml_learner
  • 31
  • 1
  • 7
0
votes
3 answers

BI Publisher - Fail to load and save data model

Started BI Publisher about a week ago. When working on a new data model, about one or two queries in, I get this error when I try to save: Failed to load…
Null2
  • 43
  • 1
  • 2
  • 5
0
votes
4 answers

Can't install BI Publisher for desktop

I'm having problems installing BI Publisher for Desktop 11.1.1.9.0 32bit(11g) on Win7 64 bit system (Office 2013). Previously I successfully installed it but there was no add-on visible in Office, so tried with 64 bit version but with no luck. After…
Maki
  • 471
  • 2
  • 8
  • 17
0
votes
1 answer

how to change time zone in reports

In my application the time zone is (UTC-05:00) New York Eastern Time(ET).while creating report the date field shows 5:30 hr variation. For example Application Report sdate 7:30 1:PM I am using BI publisher report. please any one help me How to…
bharathi
  • 3
  • 1
  • 6
0
votes
2 answers

BI Publisher - Parameters between the dates

In BI-PUBLISHER, I have two parameters of STARTDATE and ENDDATE. There is a field in the table ACTIVE_DATE which would be used in the above parameters. I am using the following condition in the query: trunc(active_date) between NVL(:P_Active_Date,…
Imran Hemani
  • 599
  • 3
  • 12
  • 27
0
votes
1 answer

Multiple tables in one layout in Bi Publisher

lets assume that i have a table with the below values Id Date 1 4/10/2015 2 4/10/2015 3 5/10/2015 I want to create a report Layout with multiple tables for every distinct Date. In this case ,the output will be…
Anastasis
  • 192
  • 1
  • 2
  • 12
0
votes
1 answer

HTML2FO always uses Arial font in BI Publisher

I'm trying to do a HTML conversion in my report(RTF) and it works but expected output change my font 'Times New Roman' to Arial. I believe, I changed my default font to Times New Roman even in xdo.config but still HTML2FO makes it Arial. Other…
Sebastian
  • 21
  • 5
0
votes
1 answer

How to call Stored Procedure from BI Publisher?

I am trying to call a stored procedure from BI Publisher, and need some help to achieve this. Here is what I have: In my Data Model I have the following code: DECLARE type refcursor is REF CURSOR; xdo_cursor refcursor; BEGIN OPEN :xdo_cursor…
AJR
  • 569
  • 3
  • 12
  • 30
1 2 3
…
35 36