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

BI Publisher header and detail section like invoice. There is a space on first page and none on the rest of pages

Trying to do an invoice template using word. Everything looks good but the first page has a blank line after the header section and the other pages do not. Basically i am doing
ThomasDKim
  • 305
  • 3
  • 14
0
votes
0 answers

Oracle Apex XML Output

I want to create an SQL Query in oracle apex for showing in bipublisher, in this case I have to create report in shared component, report query section. after that download XML file and load it to MS WORD for create report's layout. but my table has…
ali yousef
  • 87
  • 2
  • 6
  • 15
0
votes
0 answers

Need to reduce the time for generation of PDF using BIPublisher

Hi I have an RTF file which took around 3 hrs 15 mins time to generate the PDF report. I want to reduce the time using BI publisher in MS-word. I expecting it should take much more less time than 3 hrs 15 mins In this RTF I have created a repeating…
Aritra Thakurta
  • 1
  • 1
0
votes
2 answers

How to include space in column header in Oracle BI Publisher?

I'm not able to include spaces in column header names I've tried specifying column name in SQL query and changing the display name in the Structure tab and both don't work. When I try to change the XML tag name it errors out (space is an invalid…
pmpm
  • 1
0
votes
1 answer

How to conditionally hide a column in rtf template when 0 value

I need to hide the whole column in the rtf template when the value is equal to '0' then it needs to be shown when the value is greater than '0' I have tried the ff. But none of them worked. Sol#1 Column Header …
Eyei
  • 1
  • 4
0
votes
1 answer

Data value pushed to next line when using split-column-data

I have tried to use split-column-data to display table dynamically based on XML files in Word built in Oracle BI Publisher. But the each column width are separated evenly and not display by the size of content. I have stuck on this for a long time…
distinguisedman
  • 1
0
votes
2 answers

Date comparison between same data type in sql query

I have a column in the format - MAX_DATE PROCESS_DATE 2022-10-14T16:09:09.272+00:00 2022-11-08T15:43:29.027+00:00 WHEN I AM WRITING THE CONDITION SELECT * FROM ANC WHERE MAX_DATE > PROCESS_DATE Even then a…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

Microsoft Word BI Publisher: how to hide table header row at first occurrence

Currently I am working on Oracle report using BI publisher desktop extension for MS Word. In RTF layout I have a requirement to build receipts table and dynamically loop through receipts XML data. In oversimplified way it looks like…
Artūrs Grigorjevs
  • 1
0
votes
1 answer

Oracle GL tree hierarchy

This is the code: SELECT 'FXE_I_823' AS KEY, listagg(ftn.pk1_start_value || '|' || ffvv.description, '|') within GROUP (ORDER BY DEPTH) "TREE_CODE" FROM fnd_tree_node ftn, fnd_flex_values_vl ffvv WHERE 1=1 AND ftn.pk1_start_value =…
Rajat Sulibhavi
  • 1
  • 1
0
votes
1 answer

Can we use :xdo_user_name for filter logic with WebLogic?

Can we use :xdo_user_name for filter logic with WebLogic? I created a datamodel in oracle BI Publisher，with where clause like below: WHERE (EMPLOYEE_NO = :xdo_user_name) which works normally if I login with an employee account. But I would like to…
Carson Hung
  • 1
0
votes
1 answer

How to use login ID session variable in Oracle BI publisher report

I am thinking of setting user filter on report. So user can only see data related to him. It is supposed to login to Oracle bi publisher， then open report， and the related data will show up. Is there a way to extract login id as parameter in a data…
Carson Hung
  • 1
0
votes
1 answer

Everything is disabled under BI Publisher Menu

Everything is disabled under BI publisher menu. 12.214.00.000 is my BI version and it's 32bit Word 16.0.14326.21092 32bit
karthk sanu
  • 21
  • 1
  • 1
  • 5
0
votes
1 answer

Recurring Schedule in Oracle Fusion BI Publisher Reports via SOAP

I am attempting to use xmlpserver/services/v2/ScheduleService of the Oracle BI Publisher to schedule a recurring job. Unfortunately, with no examples and no luck with try and error method, I can't schedule a report in a recurring manner, I manage,…
Bernardo Bellotto
  • 11
  • 4
0
votes
1 answer

SQL Query to enclose column with quotes when it has |

A table has the following details Course_Number Description 10 Lean Six Sigma - White Belt 2022 | Mar. 12-Abr 12 Gold Six Sigma || Got it 13 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
0 answers

Is there a way to fetch data of BI Publisher report that is created in OBIEE 12C?

I am trying to fetch BI Publisher report's data created in our OBIEE 12c environment. We are using REST API's as mentioned in this document. Also, we are exploring options of SOAP API methods using WSDL -…
Mohanasudharsan K
  • 35
  • 5
1 2 3
…
35 36