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 OM can we change data model report layout completely for standard Sales Order Report to view PDFIn OM, we veiw PDF as follows: ACTIONS—>CREATE DOCUMENT—>VIEW Behind this there is a standard Sales Order Report Layout and DM with XML /Supply Chain Management/Order Ma… -
unable to convert the xml fields into spanish in the rtf templatewe have a requirement to display both English and spanish languages in a single offer letter, but in the rtf template we are unable to convert them.is there a way to pop…
-
how to send the zip files and PDF files as attachments in the email through the bursting bip reporti have requirement to send the zip files and pdf files as attachments in the mail through Bursting report, is there a way to do this? please let me know
-
How do I limit a primary dataset based on results in a lookup dataset in a data model?I have a data model with a "primary" dataset that joins to 3 other datasets as "lookups" for additional data. I want to apply a condition to one of the lookup datasets v…
-
BI Publisher report based on RTF template not displaying from all joined datasetsI have a data model with a "primary" dataset that joins to 3 other datasets as "lookups" for additional data. I have created an eText RTF template and am getting the dat…
-
Fixing Concatenated Terms and Conditions in BI Publisher ReportsI am customizing the PO PDF report in Oracle Fusion. In the application setup, our Terms and Conditions are entered across three lines. However, in the report output, th…
-
Is there any guidance to generate a report of Change Order redline details for integration purposesOur requirement is to integrate item changes by organization into the ERP system. Therefore, we need to generate a report based on the exact change details, categorize t…
-
Feasibility of config: in case of On-prem to Cloud transformation of BI reportsContext: Migration of BI reports from on-prem OTM solution to OTM Cloud SR already raised: 4-0002467829 In on-prem BI reports, we used PL-SQL packages in oracle database… -
Why are we not able to see CAD in the drop-down of currency code OOTB field in custom object?We are unable to see any other currency other than USD in the drop-down list of Currency Code field in Custom Objects. We have CAD enable and also start date is given. T…
-
BICC Extract: No way to correlate MANIFEST.MF file to specific requestSummary: When submitting multiple BICC extract offerings in parallel via the ESSWebService (submitRequest), each completed job produces a MANIFEST.MF file in UCM under t…
-
Unable to install Oracle BI Publisher facing an issue.Summary: Oracle BI Publisher Installation Error: "Uninstall the current version using Add or Remove Programs from the Control Panel" Content (please ensure you mask any …
-
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…
-
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 6 views 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…