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

How do I fix ORA-01843: not a valid month?

So at the query level, I have it: to_char( ( to_date( substr(TIMESTAMP, 1, 19), 'yyyy-mm-dd hh24:mi:ss' ) ), 'dd-mon-yyyy hh24:mi:ss' ) as DateTime, And I've tried looking at a few articles with one…
Thabiso Motswagole
  • 146
  • 1
  • 2
  • 17
1
vote
1 answer

BI Publisher - Display Data Horizontally MONTH

I have the following data model: ABC Monitor 20 APRIL .25 20 PRIMARY CNTR000000 - DICS Hourly 75 MARCH .25 8 PRIMARY CNTR001111 How to display the result horizontally, like this April, March
Priyank Bhasin
  • 7
  • 1
1
vote
1 answer

Using SQL Developer with BIPublisher Oracle Cloud HCM

it's been 2 months I'm working for a new client on BI Reporting on Oracle BI Publisher within an OracleCloud CRM and HCM. to make query to OracleCloud database I have to use notepad++ and then copy/past my query in the Query textArea on BIPublisher …
Slifer
  • 175
  • 1
  • 1
  • 10
1
vote
0 answers

String index out of range oracle bi publisher

I'm download .xml from Oracle apex > Shared Components > Report Queries and open with oracle BI addon in MS Word. XML is successful loaded I'm add header text and change column name and save as .RTF file. After import .RTF file in Oracle apex >…
Pointer
  • 2,123
  • 3
  • 32
  • 59
1
vote
2 answers

Referencing fields in BI Publisher RTF template conditional regions

I'm putting together a report in the BI Publisher Word .rtf plugin with very specific layout needs. One of those needs is the ability to switch company logos depending on parameters entered. I've been using conditional fields to selectively display…
tmnsquirtle
  • 11
  • 1
  • 3
1
vote
2 answers

Subtract time using Oracle PL/SQL

I'm creating a report using BI Publisher. Now, I want is to subtract 4 hours in the date. For example, the date I get in the oracle database is below, 2019-09-23T10:09:34.054+00:00 Now I want it to return in report using sql…
Lawrencxe
  • 81
  • 4
  • 18
1
vote
2 answers

Nested loop in Oracle BI Publisher .RTF template

I have two nested loops each one use a different node to get data: 1) 2) Looping with the first group for each target_test I generate a page of report and with the…
Sharknado
  • 27
  • 1
  • 6
1
vote
0 answers

APEX Report printing with BI Publisher Error. ORA-22973: HTTP request failed ORA-06512:at "SYS.UTL_HTTP", line 1324 ORA-12547: TNS:lost contact

I have Installed Oracle APEX 18.1 on oracle database 11g. Now I install oracle BI Publisher using complete OBIEE 11.1.1. I have given exact entries in instance setting at instance management in APEX for BI Publisher as mentioned in many forums. When…
zafar shakeel
  • 23
  • 3
1
vote
0 answers

Design of rtf template for multiple data sets

I have a seeded datamodel with two datasets. Dataset D1 has field F1, Dataset D2 has field F2, F3, F4 Example Datamodel: …
Avani
  • 205
  • 1
  • 6
1
vote
1 answer

How can use an ORACLS EBS xmlreport parameters from a package-body?

I have recently created a report using Oracle E-business suite, a XML publisher report. In that report I have added 4 parameters and I need to use those parameters from a package body which is a custom request these are the parameters in my xml…
ssik
  • 31
  • 2
1
vote
1 answer

How can I convert parameter input date to YYYYWW format and use it in SQLStatement section in XML publisher?

I have created an xml file as data definition template for my xml publisher. The data template has two parameters which are date( startdate,enddate). But this input dates should be converted to YYYYWW format so that in my SQLstatement I can use the…
ssik
  • 31
  • 2
1
vote
3 answers

Standalone ELSE in BI Publisher RTF Templates

I understand that there is an IF-ELSE Statement in XML Publisher RTF Templates, that goes something like below: However, i'm looking to use the IF statement in…
Migs Isip
  • 1,450
  • 3
  • 23
  • 50
1
vote
2 answers

BI Publisher > Avoiding Table to split into next page

I have a BIP rtf template that has a table with bunch of fields. The report consists of multiple records and not just a single record. Now requirement is that if the table of next records fits in the same page then place it on the same page else…
Umer
  • 127
  • 1
  • 3
  • 20
1
vote
1 answer

Set limit to text length of column

I am fairly new to using BI Publisher (MS Word plugin) with PeopleSoft. I have a payment statement that I am adding some data elements to and I have noticed that with the Invoice Number field in some cases the number/test string is longer and it…
Nick
  • 268
  • 8
  • 33
1
vote
1 answer

Oracle Forms 12c integration with BI Publisher

There is a tutorial that explains in detail, how is the integration of oracle bi publisher with oracle forms 12c. Oracle forms 12c comes with the possibility of integrating oracle reports as well as oracle bi publisher, it would be very helpful if…
Pablo Fontana
  • 21
  • 4
1 2
3
…
35 36