-
Parameters Failing to Load on BIP
Summary When trying to run a report in BIP, the parameters are blank Content Hi All, When I'm trying to run a report in BIP, I am getting entirely blank space where the parameters should be. Does anyone know how to combat this, or whether there is a limit on how many parameters can be applied to a BIP report? Thanks.
-
Enable BI Publisher in MS-Word 2007
Hi Folks, I want to show the BI Publisher Menu in MS- Word 2007 but after install the BI publisher Tool, doesn't show the BI Publisher Menu in MS Word. For fix this issue I have tried following ways but not worked. 1. Uninstall the BI Publisher and reinstall it again 2. After install the BI Publisher: Go to the Word Option…
-
BI Publisher Desktop Installation Error - Reference Not Matching Identity Defined In Application Man
Summary BI Publisher Desktop Installation Error - Reference Not Matching Identity Defined In Application Manifest Content Hello, As the title says, I am running into issues installing BI Publisher Desktop 12.2.1.3.0 (32-bit and 64-bit)to Microsoft Office Word 2010 Version 14.0.6112.5000 (32-bit). When attempting to get the…
-
BI Publisher Error - message39 - how do I fix?
Summary BI Publisher Error - message39 - how do I fix? Content I have the most up to date version of OPA installed on my machine. I have also got BI Publisher installed, however the header of the word document looks broken: When I go to load the XML data, I get a particularly unhelpful error message: Has anyone come across…
-
Convert UTC to Local Time in Oracle BI Publisher
Summary Convert UTC to Local Time in Oracle BI Publisher Content We need to convert UTC time to local time (Sydney) in Oracle BI Publisher XML output in Oracle Cloud ERP. Since we cannot use BI template to handle the timezone conversion, we need to put this into the SQL. however, the FROM_TZ doesn't seem to do the…
-
Multiple Default Values in Multiple selection Menu
Summary Multiple Default Values in Multiple selection Menu Content I need to set multiple default values for multiple selection menu control in BI publisher report parameter. Is it possible somehow? Values in dropdown menu are populated from Sql. Thank you.
-
Maximum characters allowed in parameter text of a BIP report
Summary Maximum characters allowed in parameter text of a BIP report Content Hi Team, I want to understand what is the maximum limit of characters to pass as a text parameter of a BIP report? Scenario: Based on output from another report we have to run another BIP report having input parameter from one of the column of the…
-
List all scheduled reports
Summary List all scheduled reports Content We have a lot of reports scheduled from BI publisher mostly to email destinations. I want to extract a list of all the reports scheduled with BI publisher along with the recipient list. How can i do this? Thanks, Vaibhav
-
How to get JDE Fields in to a BIP Template
Summary How to get JDE Fields in to a BIP Template Content Hello, How can I get JDE fields into a JDE template to be able to do conditionals formulas off of? We are in the process of moving our non-stock purchase orders into BIP but I need to have line type show up so I can set the item number and vendor xref number to…
-
How to extract xdmz / xdoz
Summary How to extract xdmz / xdoz Content Hi, We can download xdmz & xdoz files from catalog to upload them into another environment.Can we extract them to make them as xdm & xdo files respectively ? Actually Data Models in BI Publisher when downloaded, have an .xdmz extension by default. However, when trying to upload…
-
Bursting BI publisher report with Excel file or creating each record as one report from in excel dat
Summary Bursting BI publisher report with Excel file or creating each record as one report from in excel data file with PDF output format? Content Hi Gurus, i have created report by using excel file as data set and used rtf template for field mapping. But i have to burst the report. Is it possible? or is there any other…
-
BI Publisher error in tb_param.xml "File not found"
Summary BI Publisher error in tb_param.xml "File not found" Content Hi, I have been trying to generate a PDF output from an RTF file in BI publisher. The XML is loaded successfully, but when I try to generate the PDF out of it, it throws the following error: javaw -Xmx256M -jar "C:\Program Files\Oracle\BI Publisher\BI…
-
Design of rtf template for multiple data sets
Summary Design of rtf template for multiple data sets Content Hi Guru's I am having trouble to display column data for CUST_NO_INV as it appears in the xml. The values are coming through as null values. Now for the sake of simplicity I will only show you a portion of the xml of which I am interested in. I want to have the…
-
BI Bursting with PDF attachment and HTML in the body
Summary BI Bursting with PDF attachment and HTML in the body Content Hi All Kindly, I have business requirement as following: * to send email to our customers email with attached PDF file and html body, this is how I did this: * I developed new report in BI with Bursting option as a PDF, * RTF template * I am passing the…
-
Passing multiple values in BI Publisher text type parameter
Summary Passing multiple values in BI Publisher text type parameter Content I am using a presentation variable to pass values to a BIP report. The BIP parameters have been changed to TEXT to allow for this to happen. Single selections are working just fine. The problem comes when I try passing multiple values. I get an…
-
How to avoid 'NO_DATA_TO_PROCESS' errors in BI Bursting schedule
Summary How to avoid 'NO_DATA_TO_PROCESS' errors in BI Bursting schedule Content Hi, we have a bursting report which has scheduled on daily basis and the schedule is completing with the 'Success' status when there is data to process. But when there is no data to process, the process is completing with the status 'Failed'…
-
How can I export Oracle BI publisher report in real Excel format(not .xls, but content is html)?
Summary How can I export Oracle BI publisher report in real Excel format(not .xls, but content is html)? Content I use this java code to export BI publisher report in Excel format, I would like to get real Excel file, but I got .xls that content is html. ReportRequest reportRequest = new ReportRequest();…
-
Customization of PO Output for Communication
Summary Customization of PO Output for Communication Content Hi, Not able to attach a Customized Template in standard oracle Po Steps. 1. created New template code 2. Created New Data Template 3. Attached as setup in purchasing in Standard PO template 4. Change document style sheet to our new customized template 5. Create…
-
Accidentally deleted a report and data model - can it be recovered?
Summary Accidentally deleted a report and data model - can it be recovered? Content A user accidentally deleted a report and its data model, can this be restored? Once a catalog object is deleted, does it go to a deleted folder before it is purged? I am checking in other environments to see if there is a copy there.
-
Dynamically inserting logos/images in BIP Report
Hi, Our requirement is to dynamically call the logo in the Purchase Order Document report based on the Legal Entity of the PO. I have done several ways to achieve this output but it's not working. I used UCM as image repository I did the following: 1. I followed the steps indicated in Doc ID 2232740.1 300000001423024 =…
-
Cannot use NEXT_DAY function in Fusion BI Publisher Data model
Summary Cannot use NEXT_DAY function in Fusion BI Publisher Data model Content Hi All, I am trying to run the below query to get the next Saturday in a BI Publisher Data model. SELECT TRUNC (NEXT_DAY (TRUNC (SYSDATE, 'IW'), 'SATURDAY')) FROM DUAL However it keeps giving me the below error.…
-
Pie Chart in Interactive mode is round numbers that are greater than 10,000
Summary Pie Chart in Interactive mode is round numbers that are greater than 10,000 Content Hi, I am making a report in interactive mode and having an issue where when making a Pie Chart with five values that range from 10 to 15,280 is rounding down the 15,280 to 15k instead of displaying the actual number that I want it…
-
Empty column missing from csv output
Summary Empty column missing from csv output Content I have a BI Publisher report that extracts several columns that may or may not be populated. When they are not populated (only null values), the output does not include them when exporting the csv. Is there any way to force every column that is specified in the data…
-
BI Publisher
Summary BI Publisher Content Obiee Version - 12.2.1.1.0 Linux x88-64(Linux 5) We are fairly new to BI ,I would like to know what are the prerequisites for installing BI publisher .Is there additional licensing cost ? Thanks, Mandy
-
oracle bi publisher
Summary oracle bi publisher Content Prophet BI Publisher is a vital endeavor detailing item from Oracle that gives the capacity to make and oversee exceptionally organized reports from an extensive variety of information sources. Prophet BI Publisher is accessible as a major aspect of the Oracle BI Enterprise Edition Suite…
-
Conditional Printing of Text at Page Footer in RTF Template - BI Publisher
Summary Conditional Printing of Text at Page Footer in RTF Template - BI Publisher Content Hi, We have a requirement to print the Page Footer conditionally, To be clear after the detail records we need to print a line(Static Text) at the bottom of page(only once ). After this we need to print Terms and conditions.(Static…
-
How do we split the report into another sheet if the first sheet reaches maximum limit of 65000
Summary How do we split the report into another sheet if the first sheet reaches maximum limit of 65000 Content Hi Team, Currently, I am creating template in excel format. When I am viewing the report I found that the excel is taking 65,000 records only but we have more than 1 lakh records. How can we split the output into…
-
Export BI Publisher Report in CSV Automatically
Summary Export BI Publisher Report in CSV Automatically Content Hi Gurus, I noticed in my BI Publisher (12.2.1.2), if I tried to open the report in PDF it will download automatically. But when I opened the report in CSV, it will display the output in the browser instead of downloading the report. So I need to do Export >…
-
Repeating header & footer on BI Publisher template within a for loop
Summary Repeating header & footer on BI Publisher template within a for loop Content Hello All, In the AP Invoice print report, i need to print multiple invoices at once and hence has the entire template with in a for loop. Basically some thing line this. for-every-voucher some header info for-every-voucher-line voucher…
-
Removing parameter values from CSV output
Summary Removing parameter values from CSV output Content Hi guys, I'm using BI Publisher 12.2.1.1 and I created a report directly from the data model in BIP. There are two parameters, p_start_date and p_end_date, used for the report. When generating the report in BIP as CSV with some supplied param values, it adds the…