-
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…
-
Oracle BI Publisher Excel Output Headers Misaligned
I’m using the Word Oracle BI Publisher plugin to generate Excel output with a table. I have: a header row detail rows grouped by device an empty row inserted whenever the device changes The problem I am facing is that the excel file it generated, the header is not showing correctly For example, the layer should be in E but…
-
Is it possible to add border based on groups to a table created by Word's BI Publisher Table Wizard?
I created a rtf file using the BI Publisher Table Wizard in Word. Is there any way to let it add border when a columns value changes? (For example, we want to add a thick border when Order Type changes), so it could look like this in the excel? (there is a thick border line after A, and another thick border line after B )
-
Dynamic Data field on Interactive Dashboard
I am building a dashboard (in online template builder in Fusion BIP) with various charts and detailed information, all based on one dataset in a BI Publisher Data Model. At the top I have 4 KPI cards that are structured as Data Fields that I dropped into a Layout Grid. The dashboard is interactive in that when you click on…
-
How to Schedule Job that FTPs Report via REST scheduleJob API
Hi, I've recently stumbled upon the "REST API for Oracle Analytics Publisher in Oracle Analytics Server" documentation for the "scheduleJob" API. I'm able to schedule a job via the API but have not been able to deliver the report via FTP. Note that we can FTP reports when we manually schedule the job. I've searched the web…
-
header etext template for empty data set
-
We need to build a BIP with json as input parameter and xml as the output
We have a requirement wherein: We need to create a BI publisher, data model with type, which accepts JSON as input. Then using this, we need to create the data template. has anyone come across such requirement? Please share your thoughts
-
PO Approval Notification – Custom Field Not Reflecting After Report Customization
We would like to customize the PO approval notification by adding a new field. We have already customize the Purchase Order Notification Report and added the required field; however, the field is not reflecting in the PO approval notification. Could you please advise if there are any additional setups, configurations, or…
-
Modifying the ESS scheduled process 'Run Grade Step Progression' generated Log Output files in HCM
Hi All, We would like to request a change in the wording used in the log output file that is generated after running the scheduled process “Run Grade Step Progression” in Oracle Fusion HCM. Currently, the log output displays the term “Errored Assignments.” We would like to update this wording to “Unprocessed” in the…
-
We have a custom report and when trying to run the report there are an error displayed
We customized the Purchase Order Notification report by modifying its data model. After running the report, everything worked correctly. However, when we tried to add a new field to the RTF template and ran the report again, we encountered the following error: Error displayed: “The report cannot be rendered because of an…
-
GenericSOAPService Equivalent Substitute ERPIntegrations REST API not giving same results
Dear All, As part of functionality we are using the GenericSOAPService WebService to Upload File and then we get the UCM COntent Id and send that as parameter to the next REST API call importActivities But recently as part of our movement to Public Cloud from Private, we have started using ERPIntergrations API to upload…
-
What is the substitude for ReportService SOAP WebService In REST Framework
Hi Team, Our project is planning to replace all the SOAP based web Services to the REST Based APIs. One such SOAP WebService we are using is xmlpserver/services/v2/ReportService?wsdl. But after searching through the oracle communities we could not find any relevant API for the same, Appreciate if you can suggest the REST…
-
BI Publisher report to generate one PDF per Learning certificate in Oracle Fusion
I’m creating a BI Publisher report to generate Learning certificates in Oracle Fusion. I need to generate one PDF certificate for each completed Learning record. Right now, I’m only getting one output instead of multiple certificates. Has anyone implemented this before, or can you suggest the correct setup for the data…
-
Chart Labels mashing with line values
I am building a dashboard using the BIP Online template builder in Fusion. I am using the below line graph and want to have the upper and lower values of the line display. When I enable this, you can see that the upper value of the line (28.62) interferes with the Y-axis value (30). I've tried playing with a variety of…
-
Catalo Service Download Object
hello I am using catalog service wdsl to get Data Model and Report Definition the issue is when i am using it, i am only getting xdo file without xdm definition do you know how to get xdo and xdm using wsdl file thanks
-
OAP - SSO solution evaluation ( Azure AD → WebLogic → OAP SAML )
Hello, We are checking a SSO solution for Oracle Analytics Publisher (OAP 8.2). Our current plan is: → Azure AD (Entra ID) as the SAML 2.0 Identity Provider (IdP) → WebLogic Server as the Service Provider (SP) validating SAML assertions. Could you please help us on below query: Is this Azure AD → WebLogic → OAP SAML…
-
Using non standard SQL queries with multiple conditions in a BI Publisher Data Model
Hi there, I've followed the documentation from Oracle on conditional queries using an if else expression wrapped around SQL data models in BI Publisher. Creating Data Sets Using SQL Queries I can successfully run a non SQL query with a parameter in my data model where one condition is present using the following syntax…
-
BI Publisher: 400 Bad Request when selecting multiple values in LOV parameter (URL length limit)
Hi everyone, I'm running into an issue in BI Publisher and could use some advice. When running a report , selecting a large number of values (e.g., 100+ customers) from a multi-select parameter LOV results in a "400 Bad Request" error upon clicking "Send". Best regards
-
Generating Watermark on Excel output with rtf-based template
Hi everyone, I have a question regarding BI Publisher report formatting. Is it possible to apply a watermark to the output when generating reports in Excel (including Excel MHTML format), while using an RTF-based template? In my case, the report template is designed in RTF, but the output format is Excel. I would like to…
-
Remove the unnecessary options in Work Area under Map Reports to Work Area.
We would like to know how to remove the unnecessary options in Work Area under Map Reports to Work Area. We don't see any deletion of work area, only for report. there are multiple options with same name but no content. You can also refer on the SR I created in Oracle (4-0001122199)
-
Publisher report is not sent due to timeout even though it took 6 minutes 1 month ago
Hello Team, I created a publisher report that took 6 minutes to send a month ago, but now it times out after 1800 seconds. I tried step-by-step to figure out which dataset is the bottleneck, but even with just a few datasets, the report struggles to send after several minutes. I checked the underlying tables in the…
-
Implementation of sheet-splitting functionality using an Excel template
I am trying to create a BIP report using an Excel template file. I have installed Oracle Analytics Publisher Desktop (Ver. 12.2.5.5.0) and am using Excel to map fields from XML data to specific positions within an Excel worksheet. The report I want to create is a form where a header (one row) is paired with detail rows…
-
do we have a way to gather all XDO reports which contains only pdf output [please check the below]
Hi Everyone, I am looking for query or table which include the below information: i believe this data stored somewhere in the DB. but i tried too much to get all reports which have PDF output. the main requirements is to make sure that watermark is applied to all PDF reports Best Regards,
-
How to convert xsl-fo to RTF template ?
Hi Team, I know from RTF template, we can create xsl-fo but is it possible to go vice-versa ? Create RTF from xsl-fo template?
-
Barcode printed but not scanning after updating RTF design in JDE
Hello, I recently updated the design (borders and layout) of an existing RTF template. While the barcode prints clearly, it is no longer scannable. No changes were made to the barcode logic or font. Could this be related to the quiet zone or BI Publisher rendering? Any advice would be appreciated.
-
Auto Numbering Adjustment in RTF Templates for Offer Letter
Customer have multiple paragraphs in a Offer Letter template which are numbered and some of them have conditions so if the condition is met the paragraph is displayed, if not it is hidden. The challenge we are facing is to re-number paragraphs if there are hidden paragraphs due to conditions not satisfied in-between. e.g…
-
Printing Checks from Oracle Cloud SaaS to Local Internal Printers
From a Network Architecture standpoint, I have the following questions regarding Oracle Fusion check printing: Essentially, we are trying to eliminate the need to expose printers to the Internet. 1. What network connectivity options do you typically recommend for customers who need Oracle Fusion to print to on-premises…
-
In email notification Image or logo is not display
Hello Experts, We are experiencing an issue in Oracle Fusion HCM where the Oracle Community logo (or other embedded images) is not displaying in CmpWorkbenchFYIReport workflow email notifications. The email notification is triggered correctly, but the logo/image does not render at all in the recipient’s mailbox. Even after…