-
Best Practice for ESS Runbook
I have been tasked with creating a run book for ESS jobs. Whilst the queries are centred on the ESS_REQUEST_HISTORY table I would appreciate any suggestions/best practice for implementing a set of reports
-
Technical Issue: eText Report Displays "???" Instead of Expected Values
Hi,😊 I have a technical issue that I am struggling to resolve. I created an RTF layout, and the preview works correctly when using the BI Publisher Add-in tool. However, when I upload the layout in eText format, the generated report displays only question marks (???) instead of the expected data. I have not been able to…
-
Conditional header/footer and content in Oracle BI Publisher RTF template
hi Oracle team, Have a scenario: Country = A, then page 1 should have a notification for that country with no header/footer however page 2 onwards, the existing content with header/footer. but if Country != A then no notification and has to display existing one with the header/footer. Tried option A: Native word option…
-
Display Only the Current direct reports's Data through a BI Publisher Dashboard Embedded in a PD
Hi Oracle Community, I have a requirement in Oracle Fusion HCM Performance Management and would like to understand the recommended approach for BI Publisher. The business flow is as follows: A Manager logs into Oracle Fusion using their manager account. The manager can see the performance documents of their direct reports.…
-
I have Windows 64-Bit in my system and I have downloaded Oracle BI Publisher Desktop 64-bit. when tr
I have Windows 64-Bit in my system and I have downloaded Oracle BI Publisher Desktop 64-bit. when trying to install Oracle BI Publisher in my system, I get error like "Set Word2007 flg failed" or "Please uninstall the current version using Add or Remove Program from the control Panel" But there is no program for Oracle BI…
-
BI Publisher not supporting xlsx template type
I created a XLSX template in Oracle Analytics Publisher Desktop 26.01.01 and uploaded the template to a BI Publisher report in OTBI. Things worked initially, but this morning when running the report I received an error: The report cannot be rendered because of an error, please contact the administrator. Error Detail:…
-
Question regarding BI Publisher Outputs
Hi All, I have a question regarding the BI Publisher Outputs. I have configured the rtf template output as Excel but when the XML Report Publisher program completes and I click on View Output, the output opens in a browser and renders as an HTML. Can some one please assist why this is so. The BI Publisher version is…
-
images in bi publisher report
-
RTF Layout Upload Freezes with “Uploading, Please Wait” Message When NordPass Browser Extension
The issue is related to the NordPass browser extension installed via our corporate policy. Issue observed: Users were unable to upload custom BI Publisher templates in Oracle Fusion (BI Publisher / Oracle Analytics) using Microsoft Edge and Google Chrome. The upload dialog remained indefinitely at "Uploading, please…
-
Keeping track of the last scheduled run for a BIP Scheduled Report
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…
-
Scheduled report in BI Publisher 12c returns garbled excel output
Hi everyone, I'm using Oracle BI Publisher version 12c and recently I notice a strange error: when I schedule some reports that use excel templates (.xls), their output can not be opened without the error message "The file format and extension of <report_name> don't match. The file could be corrupted or unsafe. Unless you…
-
OIC SOAP Connection — OAuth Authentication Fails Intermittently
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
-
OTM/GTM - what is the size limitation for oracle BI Publisher rtf template?
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
-
Need support on nested loops in Excel template
Hi All, We used excel template for our HCM Extract, we are publishing personal details which includes visa, address, contacts and others. For all the columns, we did looping based on main data group(Assignment dg) and one emp can have multiple contacts. When we do one more looping only for the contacts, employee details…
-
Adding Currency Column to BI Publisher Pivot Table in ARCS Custom Report
Hello Experts, I am developing a custom report in Oracle ARCS using BI Publisher. The report layout is created as an RTF template in Microsoft Word based on an XML data source generated from a SQL query. Currently, I have a pivot table that displays aging buckets (0-30 Days, 31-60 Days, 61-90 Days, 91+ Days, Total) with…
-
BIP Report for Assignment Transactional History Detail Report
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…
-
How to generate a CSV file with headers only ?
Hello Team, I am generating a BI Publisher report scheduled through an ESS Job with the output format as CSV. When the report returns no data, I need the output file to contain only the column headers. However, the generated CSV contains the headers followed by an additional first data line with delimiters only, which is…
-
Authentication Failure for ExternalReportWSSService with Username Token
Anyone facing issue with calling the https://xxxanalytics-[tenant]-ia.analytics.ocp.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?wsdl with runReport operation with WSS-Username Token after recent upgrade with OAC ? The Basic Authenticaiton works from SOAPUI , however the WSS-Username Token does not work and…
-
How to configure the BI-Publisher in Apache Tomcat version 5.5
Currently we have deployed the Oracle BI Publisher 10.1.3.4.2 manually unpacking the xmlpserver.war file to a separate folder in the server and deployed the BI Publisher as an application in existing EBS residing Oracle Weblogic 10.3.6 and working as expected. Currently we are working on implementing BI Publisher…
-
How to Generate a BI Publisher report?
Hello Team, How to generate a BI Publisher report (scheduled through ESS Job) with headings only (without 1st line with delimiters) when there is no data in CSV format? Note: Not by using bursting method. Thank you
-
how to send multiple payment files in one email in oracle BIP bursting
Hello Community, I have an Oracle BI Publisher report that fetches payment file outputs from iby_trxn_documents and bursts the output to an email address provided at runtime via a parameter (P_EMAIL). The report works correctly; however, we are receiving a separate email for each payment file selected. We would like to…
-
Restrict end users to view/run reports only, with no write, edit, delete, copy, move or rename acces
Requirement is to restrict business end users to view/run reports only, with no write, edit, delete, copy, move or rename access in BI Catalog (Shared Folders > Custom > ANL > Business Reports > Report). Approach 1 - Custom Role (Did Not Work): Created custom role CUSTOM_BI_REPORT_VIEWER inheriting BI Consumer Role. Failed…
-
We are invoking a BI Publisher report using PublicReportService.submitReport. The report output is
We are invoking a BI Publisher report using PublicReportService.submitReport. The report output is generated successfully. The WCC/UCM delivery is also successful and a UCM Content ID is created. However, the BI Publisher job status becomes Warning with: Failed to call back ESS server [INSTANCE_ID=bip.bi_server1] Manual…
-
In Custom BI Report, we are using Standard FA_UCM_PROVISIONED to read document from this Content ser
In Custom BI Report, we are using Standard FA_UCM_PROVISIONED to read document from this Content server but normal business are not able to run this report they are getting error Fusion BI Publisher: Custom BIP Report Fails with "Could not get data source connection for: FA_UCM_PROVISIONED" error Please do let us know how…
-
Hyperlink (image or text box) issue
I have a main page that access many different tabs in my dashboard. In this main tab there was a text box with hyperlink in each text to access these tabs. In the last 3 weeks i started to face a issue that a click on this to access a certain tab then the loading bar goes like 90% and stops. I already replaced this text…
-
100% stacked bar chart in BI Publisher
Hello everyone, I need to create a report in BI Publisher instead of OTBI because OTBI is too slow. The report should include a 100% stacked bar chart. Is this possible in BI Publisher, and if so, how can it be done? Thanks in advance.
-
In Oracle Fusion BI Publisher, where can we see the package body referenced by standard reports?
In BI Publisher, some seeded reports use packages in triggers (like before report). Where can we see or get the PL/SQL package body for it? For example, from the report DM: As of Date Inventory Valuation Report Data Model, located in /shared/Supply Chain Management/Cost Management/Cost Accounting/Data Models It references…
-
Microsoft Publisher retirement coming soon. What's the impact to Oracle BI Publisher?
Summary: Microsoft Publisher retirement coming soon Content (please ensure you mask any confidential information): Microsoft has announced that Publisher will be retired in the coming months. In July 2026 the Microsoft Publisher application will be removed from all Windows computers and you will not be able to open or edit…
-
I need a BIP/OTBI report If the rating in any of the question is 3 & below-BHR intervene & solve.
Proposing to integrate three feedback forms into our HRMS, triggered automatically at the 30-, 60-, and 90-day milestones, to capture each new joiner’s onboarding experience in real time. 5-scale rating with 9 questions along with 1 open-ended question If the rating in any of the question is 3 & below – we can then ask…
-
<Line 3, Column 98>: XML-22002: (Fatal Error) Error while processing include XSL file..
When running the report, getting below error, The report cannot be rendered because of an error, please contact the administrator. Error Details: <Line 3, Column 98>: XML-22002: (Fatal Error) Error while processing includes XSL file (xdoxsl:///Custom/PhoenixCommonLetterHeadTemplate/CommonHeadersFooter.xsb). The same report…