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

Bi Publisher - Report with 2 different Datasources

I have a Report that base on two different Datasoeurces. The Once is a sql-query with a parameter (in the WHERE clause) and the second is a XML-Data... Both (Parameter and XML-Data) I send over a httpRequest to the BI-Publisher. (I use the BI…
xjack86x
  • 37
  • 1
  • 8
0
votes
1 answer

BI Publisher - Customize Data Source over RTF-Template

I use a SQL query to select my required data, but there are not all required data in the database that I need. I customized the data source with an XSL script to use them in my template. The XSL-Script get the Datasource and Tranform it to a new…
xjack86x
  • 37
  • 1
  • 8
0
votes
0 answers

Multiple group name with for each @section using rtf template

I have an rtf template and the user's requirement is to print a batch of documents based on the transaction number. Now to do this, I search something in Google and I found the function. I tried the above function and it works in my header and…
Lawrencxe
  • 81
  • 4
  • 18
0
votes
0 answers

Facing issue when calling Oracle BIP report rest apis

When trying to trigger the oracle bip report api i'm facing 404 issue. Can anyone guide me if doing something wrong url ->…
Srk_Babre_1994
  • 11
  • 1
  • 3
0
votes
0 answers

How to remain the style of "outline text" to generate catalog in a RTF template when use BI Publisher to change it to a DOCX?

The problem is when I edit a RTF template by BI publisher in MS Word and want to use it to generate a DOCX, the "outline text" in RTF like "Title" will be "main text" style in the DOCX.So that I cannot gengerate catalog in the DOCX, cause there is…
pretend
  • 1
0
votes
0 answers

RTF Template to get rows to columns

31 531 322623279 305634180 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
2 answers

SQL QUERY to get preceding digits as 0 if the number is not 6 digit

If the POSITION_ID is not 6 digit I want the preceding spaces to be 0 For example- 1102 should be 001102, 304 should be 000302 For this i used the below query - select LPAD(REGEXP_REPLACE(position_id,'\D+'),6,'0') test from dual But this query…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

Is there a way to generate a QR code with multiple lines of text in Oracle BI Publisher report?

oracle RTF template: multi-line content in QR code I have a requirement to implement QR code with multiple lines in oracle BI publisher report. According to oracle documentation the syntax is following: But when…
Artūrs Grigorjevs
  • 1
0
votes
1 answer

Query returning result in multiple rows for same employee

I have a table with multiple values of elements for an element with corresponding input values: EE ELEMENT_NAME RESULT_VALUE EFFECTIVE DATE INPUT VALUE ----------------------------------------------------------------- 12 Overtime …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
0 answers

Bind Parameters with Tableset values in Datamodel in Oracle Fusion

For PO Queries , I want to get the segment1 column from po_headers_all table values based on selection of the Business Unit Name column from hr_operating_units tables I have tried but not getting the segment1 values based on Businesss unit…
Klinux
  • 1
  • 2
0
votes
1 answer

How to Apply if else conditioning with HTML2FO tag in RTF Template BI Publisher

My Requirement is to display any particular text eg: 'XYZ' based on the RTF Field UE_GEN_DETAILEDDESCRTF, when UE_GEN_DETAILEDDESCRTF is not null its should display 'XYZ'. here UE_GEN_DETAILEDDESCRTF return some HTML values, to get the actual value…
Kritika Gupta
  • 13
  • 3
0
votes
1 answer

Change Catalog Type in Oracle BI Publisher 12.2.1.0.0

In Oracle BI Publisher 12.2.1.0.0, I have to change the Catalog Type to "Oracle BI Publisher - File System" to enable the Guest Account. However, it's hardcoded and unchangeable. What should I do? I tried to set up a new version (12.2.1.4.0), but…
Hieu Nguyen
  • 1
  • 1
0
votes
0 answers

How to do sum of multiple columns and print in one column in rtf template of BIP report

I want to merge three columns in one column and print their sum into that column These columns are printing amounts Currently I am tryin this formula but it is giving 0 in all places.
Shraddhha Namde
  • 1
  • 1
0
votes
2 answers

Sql query to find the latest start date when the code was tagged to the employee

I have an assignment table with the union code details as follows - ASG NUMBER START_DATE END_DATE POSITION UNION CODE MANAGER 10 01-JAN-2006 17-AUG-2017 MANAGER …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

Oracle sql Extract number before "HRS" in a table

I have a table with a column details like - 1 IPFGH Cycle 2 Work Schedule 7.78 hrs - 30 min lunch - 07:15:00 AM to 03:32:00 PM Work Time 2 IPFGH Cycle 1 Work Schedule 7.78 hrs - 60 min lunch - 08:00:00 AM to…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
1 2 3
…
35 36