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
-
In Bursting How to get email bounce back if email address is incorrectDeveloped email bursting functionality for users. However, when an email address is invalid, we need to capture the bounce-back. In the current design, emails are trigge… -
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…
-
Need to know DB table for BIP report history 'Output and Delivery' sectionHi team, We need table name to build report to extract 'Output and Delivery' (highlighted in orange box)from BIP report history, any help is highly appreciated. Regards,…
-
Initial cap/upper case in BIP report RTFSeeded report column value is like 'ANNUAL' .I want to display the value as 'Annual' which is in Init cap format without having to modify the seeded XML. How to do that …
-
How to Burst Email and FTP Output Delivery from the Same Schedule in BIP Report?I have a data model and a report in BIP, and there is a requirement to distribute the report output both by email to HR representatives and also to store the output on a…
-
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…
-
How to attach PDF of BIP report as document of records in oracle fusion hcmHi, This document details the steps to create document records for one or more workers using BIP Report. we have a business use case to add service credits for General P…
-
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… -
Columns removed while editing the dataset in Data Model for BIP reportHi All, We are editing the 'Statement Generation Data Model' ,. We have few existing columns which are available in the Structure diagram, but same is not available in D…
-
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.
-
BI report scheduled jobs are skipping though the trigger is returning recordsBI report scheduled jobs are skipping though the trigger is returning records. -
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
-
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…
-
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… -
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 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.
-
Page break in BIP E-Signature RTF OutputWe've created a task which captures employee's digital signature which is being referenced to a BIP RTF template. The file has been made in reference to all the availabl… -
Bi Publisher data model parameter not displaying into Bi publisher report parameterHi Team, I observed one issue in FDI Bi Publisher environment data model created with List of Values and parameter. Data model working perfectly. But when same data mode… -
How to invoke rest api from Oracle BI ReportHow to invoke Rest api/webservice using BI report
-
Oracle Fusion Cloud Database Schema Export for AI contextI am looking to get a database schema file in JSON or YAML that shows tables, columns, ideally column descriptions, primary keys, and foreign keys. This is so I can prov…
-
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…
-
How to retrieve user information who is running BI reportI need to display user name of who is running a BI report. I am using select :xdo_user_name from dual. But this is returning email id. But from security console I can se… -
ESS Job Status Shows "Error" Despite Successful Report Output in Oracle FusionHi Team, We are facing an issue in Oracle Fusion Applications where a report or ESS job scheduled via "Schedule New Process" generates the expected output file, but the …
-
Deprecation of download logs in help menu for Oracle BICC (BI Cloud Connector) in release 25CSummary: Download logs in BI Cloud Connector (BICC) is not longer available in release 25C. Content (please ensure you mask any confidential information): In release 25C…
-
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…