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
-
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… -
Oracle BI PublisherI'm trying to create a DM and extract in Oracle BI publisher to pull some payment data from the cloud and build a report for our users to run to identify payments made. … -
In Blanket Agreement, how to get name of level one approver in partial approved stateIn oracle fusion we have implemented two level of approval for blanket agreements. When the level one approver has approved the agreement and it is pending for approval … -
sub total label in interactive layout BI PublisherHi Team, Facing issues in displaying Subtotal label dynamically based on some report column as there is no such option available in Interactive layout of BI Publisher an…
-
Document delivery failed while sending email using BIP report burstingHi Team, We are getting below error while sending email using BIP report bursting. Document delivery failed [INSTANCE_ID=bip.bi_server1] [DELIVERY_ID=-1]Exception happen…
-
BI report Webservice Data ModelWe are using web service Private Data source in Data Model, to call Oracle Integration cloud Web service. Please confirm will this feature be deprecated in future or wil…
-
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,…
-
How to create from and to date parameter without default and mandatory fileHow to create from and to date parameter without default and mandatory file in BI Publisher
-
Can we add hyperlink for ESS jobs in fusionHello Everyone, We have a requirement to call the seeded ESS job: Print Packing Slip Report from Manage Work Orders UI. What is the syntax to add through Page Composer a… -
Can Learning Initatives triggred through BIP reportshi Can Learning Initiatives triggered through BIP reports, if yes how the same can be configured
-
Current Date in OTBI for Enterprise Hire dateHi Need to know the exact query to add up in Enterprise hire date filter , date should be current date , we tried with the below options CURRENT DATE 'CURRENT DATE' CURR…
-
How to prevent report output going to outside organization via email outputSummary: User has option to run report as schedule reports for all BI reports. How do we ensure that outside email when user enter is not allowed? We also want to ensure…
-
Custom BIP Report Dynamic Column IssuesSummary: The requirement is to print the output in below format: For each period, there should be a row and corresponding value in dynamically generated column. Ex.- For…
-
where to find the database connection manager in FRS workspaceHi, I am trying to get the database connection definition and details for FRS report, however i can't find the database connection manager in 23D. I do see the Essbase a…
-
Need Oracle BI accountHi Team, We have registered as a Oracle Partner. We need Oracle BI reports account for creating and accessing data in it. Please provide us access to the account. Thanks…
-
Person Images Table stores Garbage ValueSummary: Hi Team, We have a BIP Report that fetches certain person details along with their profile information. This report feeds the output to a third party SFTP serve… -
Is there a way to index a DFF Attribute?Summary: Our solution calls for use of DFF attributes to capture data from boundary applications that should be used as parameters and filtering in BIP/OTBI reports and …
-
How to add column in a seeded BI report with existing package, ESS jobs, before/after event triggerHi, I am trying to add two columns in a "Payables Payment Register" seeded report but i am getting errors like and I would need to add column "PAYMENT_INSTRUCTION_ID"fro…
-
How to read AUDIT_CHANGE_BIT_MAP_Hello Guys I am in need to read data from tabel: FND_VS_VALUES_B_ Because i need to understand which field has been changed in the Value set I've activated the audit and… -
How to add List of values via SQL for a Oracle BIEE ReportsSummary: We have developed a OTBI report with 90 fields and added some parameters to it. Due to limitations the report is fetch 25K records only so user requested us to …
-
Has anyone successfully implemented secure list views? Do you recommend them?Summary: I’m eager to learn of other users' experience in implementing Secure List Views, particularly from anyone who has implemented them to any significant scale. The… -
How to solve java error in the excel template while working on BI reportHi, I am getting this error while trying to get the excel template for my BI report "javaw -Xmx256M -jar "C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Templ…
-
Global Level Function By Expression does not show anythingHello, I'm trying to use the below Global Level Function expression in a RTF but even though it shows in the XML outpout it doesn't in the Table view not RTF. Do you hav…
-
How to extract data from xmltype column using bip reportSummary: How to extract data from xmltype column using bip report Content (please ensure you mask any confidential information): I need to write a report using xml in co…
-
Need help with checkbox wingding.ttf font fileHi All, we have a requirement to insert check box in a report. based provided "DocID: How to Add a Checkbox in a BI Publisher Report ( Doc ID 2692589.1 )" For the checkb…
-
Getting the the error when executing the ess job ?####[2023-10-26T09:15:36.294+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…
-
RTF values not summing upI have been trying to calculate the sum of values group by specific element and person number in the RTF template, but unfortunately, I have been unable to achieve the d…
-
How do I keep a table with repeating elements from breaking across multiple pages?Summary: I am trying to develop a PO rtf template to upload in BI Publisher. When the file runs if the PO is too long, part of the items table that has a repeating eleme…
-
How to create dashboard with all BIP reports and BI/OTBI analysis reports with action links?Hi All, We are planning to create a dashboard with all custom reports (including BIP report and OTBI Analysis reports) created in Oracle Fusion cloud. Our requirement is…
-
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo…