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
-
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… -
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… -
How to Attach Process ID(fusionapps_request_id) to File Name when Bursting ?Hi All, Now there is a process which content is a BIP report with bursting. I'd like to attach the process id as a part of bursting file name. But when I use ':fusionapp… -
How can I run Review Distributions Report?Hi, I can find Review Distributions Report in Shared Folders > Supply Chain Management > Cost Management > Cost Accounting but cannot run it. There is no such ESS job. B…
-
-
How can we add a chart or graph in RTF template of a BIP reportWe need to build a report that shows a table with all the data and then a graph/chart for the same data. We have an RTF template built for the same. Please advise if its… -
BIP Samples?Is there another place to see samples of reports? the links from this page are broken -
Reports and Analytics- Folder Security changes after 22a?We are noticing changes in security access to BI Publisher reports in our Custom Reports and Analytics Folders and Sub Folders. Example 1: Employees with only the Employ… -
Error when run BI Publisher Report from cURL(REST API)According to Oracle documentation (https://docs.oracle.com/middleware/12213/bip/BIPAP/op-v1-reports-%7BreportPath%7D-run-post.html), i installed cURL in my desktop. To t…
-
Is there any way to invoke a soap service from a BIP report passing parameters dynamically?Hi experts, The idea is to invoke a soap service let say pressing a button on the BIP report layout and pass report parameters as part of a payload. Is it possible someh… -
Please share tutorials on how to make SQL Queries for BIP ReportsSummary of Request Please share tutorials on how to make SQL Queries for BIP ReportsContent Hi, I am interested in learning SQL query building for BIP Reports. Please sh… -
How can I create an event trigger in a data model with subject area?I have created a report with a data model with subject area and this report works fine, but I want to create an event trigger so that the report is only generated if it …
-
Ability to download/view the output of BIP report run by other user in Scheduled ProcessHi Team, Is there a way for a user to view output report of an ESS Process that was scheduled by another user without BI Admin role? I have followed this process: Add th… -
Can we generate output from different layouts based on the conditions?We have created multiple layouts in the report, Can we get the output from different layout based on the conditions without changing the default layout in the report.
-
How to use IF conditions in BI Publisher Excel TemplateFor Example, we have 2 columns A and B, Our requirement is to show 'Yes' in column B if column A value is not null, else if column A value is null then show 'No' in colu…
-
In oracle BIP Bursting can we able to send 2 different attachments in one emailIn oracle BIP Bursting can we able to send 2 different attachments in one email
-
RTF template | How to change the columns using conditional branchingIs it possible to make the part in the red box part conditional in an RTF template? For SalesOrders, I would like to display the ship-to site number and ship-to site nam…
-
How to use SUBSTR on Clob in BI Publisher which is not an XMLI am trying to get the Report delivery information of the reports executed with Bursting from the AuditViewDB in Fusion SaaS. The delivery details are in a CLOB column w… -
IP Address consistency for HCM Cloud Outbound TrafficDear, We are setting up firewall whitelisting and need confirmation on the consistency of Oracle HCM Cloud Outbound IP Addresses. If the main URL (https://login-test-xxx…
-
How to Create Custom PVO on Oracle Interface TablesWe have a Requirement where we want to use BICC Console to extract data for oracle Interface Error Table. Can anyone please help with Guided Steps.
-
How to invoke rest api from Oracle BI ReportHow to invoke Rest api/webservice using BI report
-
XML-23029: (Error) FORG0001: invalid value for cast/constructor ERROR IN BIP REPORTHi All, We are getting below error while running BIP report, while it runs successfully for some orders and gives error for 2-3 orders Can you suggest nay possible solut…
-
Need Approval Group Details in GeneralLedgerHi all, I am working on a GL Manual workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments in GL. P…
-
Aa BIP has a data fetching limit of 2GB .What will be alternative solutions to get huge data.As we are aware, Business Intelligence Publisher (BIP) has a data fetching limit of 2GB, which can pose challenges when working with large datasets. This limitation may …
-
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?
-
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?
-
To print a table at the bottom of the page, irrespective of the space taken up by the previous tableUsing the Oracle BI Publisher add on for Microsoft word we need to print a table at the bottom of the page, irrespective of the space taken up by the rest of the data/te…
-
How to convert User Defined Table text to date in BI PublisherHello I'm trying to work with a User-Defined Table (UDT) and am running into reporting issues working with the data in BI Publisher and am looking for help. The business…
-
Is there a limit on number of parameters that can be added to a BIP report/Data Model?Hi Team, Is there any restriction to add number of parameters in a BIP Report? Thanks, SatyaChinnamsetti Satyanarayana Swamy 1 view 1 comment 0 points Most recent by Chinnamsetti Satyanarayana Swamy
-
How can we implement SQL-based data security in a BI Publisher Data Model to restrict PII columns?We have a custom BI report which contain 5 columns of data and out of these 3 columns are related to PII(Personal Identifiable Information). These 3 fields are secured o…