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

Unable to use the REST API services in Oracle Business Intelligence Publisher 12.2.1.2.0 server

I have an Oracle Business Intelligence Publisher 12.2.1.2.0 server running and I am trying to call the REST API services in order to access a report (i.e, TestReport) present over the server by using Postman tool. I am using various methods (GET,…
Pralay Das
  • 29
  • 1
  • 8
1
vote
2 answers

How to Keep First Row and Second Row of Ms. Word Table in one page in BI Publisher Report?

My institution is using BI Publisher (Ms.Word add on) with Peoplesoft. Now, I'm doing a report that will print a name and it's description in table format repeatedly. In some cases, the first and second row of the table will be separated in…
Danry
  • 21
  • 6
1
vote
1 answer

XML Publisher Parameter Date Formatting

In XML Publisher template, how can I format the date parameter to DD-Mon-YYYY format? Start Date - With the…
Jacob
  • 14,463
  • 65
  • 207
  • 320
1
vote
1 answer

Bi Publisher date format not working in RTF template

I am using xdoxslt:sysdate('DD-Mon-YY') at the bottom of report in footer section. whenever report runs - it generates around 5-8 pages as per data and in every page at the footer i want see sysdate. At 1st page date comes fine like 15-Sep-17 but at…
user2737136
  • 19
  • 1
  • 1
  • 4
1
vote
1 answer

How to remove column header in csv output in BI publisher?

Hi I want to create a report in bi publisher which is csv format uses semicolon as the delimiter no column header Note that the report is scheduled. I always get the data like…
Liezel Francisco
  • 45
  • 2
  • 7
1
vote
2 answers

ORA-00907: missing right parenthesis - Following error is coming when i am putting Case statement in where clause

$ The following code only highlights the where clause of BI Publisher query, in which i have an input paramter :P_COUNTRY, through which i am recieving the values either as PH/MY/CN on the basis of that i have to put the where clause. WHERE …
Ratnesh Sharma
  • 145
  • 2
  • 2
  • 11
1
vote
1 answer

BI Publisher RTF Template - Column Headers

I have the following XML group... 01 12 15 45 46 70 80 …
mannyotr
  • 87
  • 2
  • 12
1
vote
3 answers

Any tools or methods to export SQL queries of oracle biee reports into plain text files?

Toad has built-in method (Database|Export|Export DDL) to export all objects (i.e. tables, triggers, functions, stored procedures, packages etc) to plain text files One of my project has all reports written in Oracle BIEE publisher. I would like to…
Frog
  • 31
  • 5
1
vote
2 answers

How do I get related data from another XML row?

I am trying to create an Oracle BI Publisher report (using the Microsoft Word plugin). The report is being created from an XML file which is created from PeopleSoft. The XML files contains many rows (I've included some sample data). One row contains…
user1166232
1
vote
0 answers

Bold certain words of the column output in Oracle BI publisher rtf template

I have a requirement to bold the word "and" in Oracle BI publisher report. I am pulling the data from the a table column in the database which has a long string and want to bold the word "and" in that string. I tried to put html tags in the database…
Rajiv A
  • 941
  • 5
  • 14
  • 30
1
vote
1 answer

Send report by email - Oracle BI Publisher

I have created a report with BI Publisher, and I try to schedule it in order to run daily and send an email. I configured the mail server attributes, such as the mail server, port , username and password. I tested it and it said "connection…
Ioanna Katsanou
  • 484
  • 2
  • 7
  • 24
1
vote
2 answers

Dynamically change headers in BI Publisher Template

I have an XML data set produced by BI Publisher that contains two groups Input XML: IMPORTANT TASK ACTIVATION …
JBOYD
  • 13
  • 1
  • 5
1
vote
2 answers

BI Publisher Excel Template Report

I need to filter Excel Template. which is XML BI Publisher report. Report Filter Condition is CATEGORY=('1002') please advice where to put filter or how to filter the Excel Template. Thanks in advance
Imranullah Syed
  • 21
  • 2
  • 6
1
vote
2 answers

How to flter XML BI Publisher report in RTF Template

How do I combine filter conditions in an RTF Template? Desired filter condition: APPLICATION=('AC','LD') AND CATEGORY=('1001','1002') I tried using , but it is filtering with only…
Imranullah Syed
  • 21
  • 2
  • 6
1
vote
2 answers

BI Publisher in Word SUM

Please note the following data: COMP - 416.00 DEVC - 16.00 DEVE - 32.00 ELEC - 64.00 YCL - 32.00 In Word I created a field with the following…
XantorAmnobius
  • 93
  • 1
  • 10
1 2 3
…
35 36