To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
BI Publisher Learning Center
Discussion List
-
Need to hide a sheet when no Data Exists in Excel Mutilsheet Excel Template ReportHello I created a Data Model with multiple data sheets in Oracle Cloud BI. I have also created a multisheet Excel Template. The template is working fine but i want to hi… -
How to burst BI Publisher reports that use PL/SQL Procedure call?I've used the following PL/SQL code: DECLARE TYPE REFCURSOR IS REF CURSOR; XDO_CURSOR REFCURSOR; L_DATA_CLOB CLOB; BEGIN L_DATA_CLOB := L_DATA_CLOB ||'' ||'SUCCESS' ||''…
-
The report output isn't available. You must schedule the report to run.Summary: Hello, I am trying to create a BI Publisher report for users under the custom folder so that they can run it from FRC. I am able to run it but when uesrs are ru…
-
disable send button in bi report output and deliveryHi Team, is there a way we can disable/hide "send " button in bi publisher report output and delivery section in report history page
-
How to send report name with timestampHi Team We have created the BIP report and business requirement is to send the report through email. we can able to send the file but how to put date and time in the out…
-
Sending new hires notifications to managers before the actual hire dateHi All, Is there a way that we can create a BI report and using bursting we can send new hires notifications to managers before the actual hire date. Notification email …
-
In BIP report, how to call an image stored in Catalog pathHi Team, Company Logo is uploaded in Catalog path (/shared/Custom/Logo/image.gif). I need to call this image in rtf template. I used below syntax but it did not work. Ca…
-
How to call fast formula using procedure call sql typeHow to call fast formula using procedure call sql type such that i can use for the remaining calculation to build BI report.
-
How to keep rich text format bip report in Excel output.We are using rich text format for Questionnaire answer format. can we possible to fetch below like links & Bold format in excel output.
-
requisition approval tree not generted how to write BIP queryCreate notification like when requisition approval tree not generated trigger notification.
-
Jan2025 CPU CVE-2016-1000027 shows vulnerability in BI Publisher 7.6.0In the January 2025 Critical Patch Update (https://www.oracle.com/security-alerts/cpujan2025.html#AppendixANLY) CVE-2016-1000027 shows a vulnerability in BI Publisher 7.… -
Setup fusion bi publisher bursting output to Microsoft teams channelSetup fusion bi publisher bursting output to Microsoft teams channel
-
Dynamic BIP Query executionWe have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as parameter d… -
How to call one particular data model query into another report's Data Model without repeat query.We had a requirement that I have to use the query written in report-1 in report -2 without writing the whole query. I just want to refer that report-1 query and will bui…
-
Scheduled HTML output report does not deliver the message put in the Output tab of scheduled pageHello All, Hope you are doing fine. There is a business need to keep the output type as HTML of a Oracle fusion BIP report. Also when this report is run through scheduli…
-
Open button missing on Dashboard report, how to get it?Unable to see the Payables Withholding Tax Report Open button missing for this Dashboard report, I added BI Admin roles but can't see it
-
What does the asterisks in table comments mean?Hi all When reading the table definitions, for example here: https://docs.oracle.com/en/cloud/saas/project-management/25a/oedpp/pjcexpitemsall-24862.html#Details there i…
-
How to call a web service in BIP SQL queryI have implemented a web service call in Oracle Fusion. Is there any way we can invoke the web service within an SQL data model in BIP
-
schedule or live execution discriminatingHi I want to ask you if there's a way in BI to discriminate if the execution of the report is live or scheduled? i would like to variate the template layout based on the…
-
how to disable value details from bar Graphs and Pie chart in BI Publisher Layout(xpt template)Hi All, We have created a report which shows output as Pie chart and Bar graph. when report runs in Interactive mode, and when placing the cursor over pie chart or Bar g…
-
How to send data from one dataset to another dataset?Hello guys, I have created one data model in which two datasets are there. is there any way to get data from one dataset to another dataset in bi publisher? for eg. I ha…
-
SFTP private key using SSH-KEYGEN command and import the same to SaaSHi, We are trying to set up SSH key authentication when we connect to the SFTP folder to transfer files from Oracle Saas through BI publisher. We followed this documenta…
-
How can we find out if there has been a recent change to Oracle ISP geolocation reporting?Summary: We're having new difficulties since about 1/25/2025 with the reported geolocation of an Oracle IP address used to deliver reports. Can we find out if there has … -
How to make US1099 report to be emailed to Vendor?Is there a way to email US 1099 to the email addresses on file? User has run this in excel and .pdf - just need to know how to distribute by email to the vendor to the a…
-
How to implement a link in BIP report to dynamically download logged in user's detailsWe have added a download link in BIP report and inserted following URL: https://"Environment link"/filepath".xdo?param1=@{PERSON_ID}&_xpt=1&_xf=pdf But the downloaded re…
-
BI Publisher - Interactive PDF report output with Checkboxes, drop downs and text boxHi, I am working on a BI Publisher report where the report output should be in PDF format. After the report is downloaded, the user should be able to select check boxes,…
-
Managing PGP Encryption for Reports on sFTP ServerHi, We previously set up a daily scheduled transfer of reports to the sFTP server, using PGP encryption. Our customer now requests additional reports to be sent to the s…
-
Need to schedule BICC jobs every 5-10 minsWe need to schedule BICC jobs to run every 5-10 minutes. Is it feasible to schedule these jobs through a web service or user interface?
-
Time Stamp Date and Time in BIP report NameHi, I am Scheduling BIP report for everyday. I wanted to Timestamp the Date and time in the output file name. For Example : The Schedule process is run on 15th June 2022… -
Approaches to Encrypt Sensitive Columns in BIP Data Model ResultsSummary: We need to include an Apex URL in the email generated by BIP. The URL should be constructed using the host component and encrypted values from specific columns,…