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

Need to generate QR Code in Oracle

I am in need of generating QR Code in oracle database and print them in PDF document generated through BI Publisher. I have tried many places and found below post which makes use of Zxing Library to generate QR Code in Oracle DB through Zxing…
Farish
  • 51
  • 2
  • 6
5
votes
0 answers

BI publisher - chart error in Oracle APEX output excel by using rtf template layout

BI Publisher Enterprice edition APEX 5, APEX 5.1 - integrated in BI Publisher through instances Microsoft excel 2013 I create bi publisher rtf template with chart for my reporting. Then I use it in APEX layout. But when I want to print this layout…
Ramin Darvishov
  • 1,043
  • 1
  • 15
  • 30
4
votes
1 answer

Increment Counter in For-Each Loop for RTF Template

I am trying to increment COUNTER variable by 1 inside a for-each loop of BIP report using below code. However, COUNTER variable are not incremented not matter how many loop there is. Can someone please guide me how to do this. Also I am aware of…
noobie
  • 452
  • 4
  • 6
  • 22
3
votes
2 answers

How to query for Inactive Employees using BI Publisher in Oracle Fusion?

I'm new to BI Publisher and I'm using it through Oracle Fusion Applications. I am trying to make a report relating to the Inactive Employees in an organization. However I am unable to figure out how to query for an inactive or terminated employee. I…
George Santhosh
  • 119
  • 2
  • 13
3
votes
0 answers

How to show only the pages that have some data in BIP?

I've created a .rtf file that has one table. My conditions, for showing the data are: create section for each table and don't show the pages if there aren't any data in the table. So far I've done this:
Stefan Dramlic
  • 69
  • 1
  • 1
  • 6
3
votes
3 answers

How to change the date format in Oracle BI Publisher?

How do I change the format of the date while creating a report using data model which I created using a simple SQL query which fetches aggregated data from a data warehouse? I need the date in a simple dd-mon-yy format. I am not able to locate where…
MontyPython
  • 2,906
  • 11
  • 37
  • 58
2
votes
2 answers

SQL query to check the last day of the month is not a sunday

I want to calculate the last day of the month, but if this date is a sunday then the below query should not give any output. SELECT * FROM DUAL WHERE LAST_DAY(SYSDATE) = SYSDATE I am using it in a trigger hence I only want the above query it give…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
2
votes
0 answers

SQL query to get the columns into one and comma delimited

I am getting an output from a query like below - REQUISITION_NUMBER CANDIDATE_FNAME CANDIDATE_LNAME TITLE EMAIL_ADDRESS Interviewer Name 12 John Derigour Hi …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
2
votes
1 answer

BI Publisher conditional field masking

I have the following code on a field in a Peoplesoft BI Publisher RTF template where it is masking the last 4 digits of the Bank Account number. …
Nick
  • 268
  • 8
  • 33
2
votes
2 answers

Limiting lines per page in BI Publisher

I'm using RTF template to create a BI report. I need to limit the number of rows into 3 records on the 1st page only. The remaining records/rows will continue to fill the next pages. I'm also required to print the page total. I used the code below…
Liezel Francisco
  • 45
  • 2
  • 7
2
votes
1 answer

BI Publisher Version Control?

I'm trying to find out how to save my data in BI publisher in version control through SVN checkout if possible. Is "Export XLIFF" what I'm looking for? How do I import it? Any thoughts would be greatly appreciated.
Null2
  • 43
  • 1
  • 2
  • 5
2
votes
2 answers

Oracle BI Publisher - Different behaviour between 10G and 11G

I have found a syntax for writing a conditional SQL statement in Datasets of Oracle BI Publisher 10G. For example, I want the data to be either in full details or distinguished depending on a parameter I've defined. To illustrate what I…
sameh.q
  • 1,691
  • 2
  • 23
  • 48
2
votes
1 answer

oracle bi publisher excel template report error- output failed

I am using Oracle BI publisher. I created a Excel template report. once generating the output for that report, I am not able to view the output in excel format. It throws error when I am opening the excel output file "The file you are trying to…
Ava
  • 31
  • 1
  • 1
  • 5
2
votes
3 answers

How do I use an xdoxslt variable inside xsl code, in BI Publisher?

I am trying to create a loop that increments a variable, then use that variable inside of some xsl code. Here is the code I am using to increment the counter:
Angel
  • 57
  • 1
  • 1
  • 8
2
votes
1 answer

Login details to use Oracle BI publisher desktop

I have installed Oracle 10g database and Oracle 10g developer suite. I am beginner to use Oracle BI publisher for making reports. Today i have installed Oracle BI publisher desktop for making reports in ms-word 2007. when i try to log on in BI…
kumar
  • 317
  • 1
  • 6
  • 15
1
2 3
…
35 36