-
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…
-
Custom Job Role to View Output of Specific ESS Job Submitted By Another User Not Functioning
Hi All, I am facing this issue after creating a custom role to view the output of a specific ESS job submitted by another user. I followed oracle Doc ID 1980772.1. Also…
-
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…
-
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…
-
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
-
Run report using Rest API - /services/rest/v1/reports/{reportPath}/run
We are trying to run report using Rest API - /services/rest/v1/reports/{reportPath}/run. But we are facing an error - 404 Not found. URL used: https://host.com:port/xmlpserver/services/rest/v1/reports/Custom%252FServices%252FInterface%252FReports%252FFXX_TECHNICIAN_PROFILE_RPT/run Headers: Content-Type:multipart/form-data;…
-
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)
-
Why does the Publisher Word Add-in not appear ?
After successfully executing the newest Analytics Publisher Add-In Installation-File (OracleAnalyticsPublisherDesktop-8.2.0-win64.exe) the BI-Publisher-Word-Add-In isn't visible, even though it is listed as enabled under Options/Add-Ins. Setup is executed with administrator rights on an Windows 11-Computer. Word-Version:…
-
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?
-
How to avoid 'NO_DATA_TO_PROCESS' errors in BI Bursting schedule
Summary How to avoid 'NO_DATA_TO_PROCESS' errors in BI Bursting schedule Content Hi, we have a bursting report which has scheduled on daily basis and the schedule is completing with the 'Success' status when there is data to process. But when there is no data to process, the process is completing with the status 'Failed'…
-
Oracle BI EE OTBI Query multi Select query
I have a query that was written as a Data Analysis in Oracle OTBI, and I am using it inside of BIP Data Model and I am structuring parameters for the Oracle BI EE logical SQL. The parameter :P_Period I would like to use as an optional multi-select parameter in the WHERE clause, where the user can either select 1 or more…
-
Anyone else have trouble with RTF tables after a recent Microsoft Word update?
For the last several years, I've been maintaining a BI Publisher RTF template with multiple, carefully sized and placed tables—both nested and independent—without incident. But after the 2409 update to Microsoft Word, simply opening the template causes table widths and the columns they contain to change. I just confirmed…
-
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.
-
How To Format Numbers As Text So That The Report Output Displays Leading Zeros Without Leading Space
On : 5.6.3 version, Designing Layout Templates Have custom reports that need to be generated in either PDF or EXCEL format. In the XML rtf template, in order to preserve the leading ZEROs in the ACCOUNT_NUMBER when generating EXCEL format, define ACCOUNT_NUMBER as 'Regular text' and use Force LTR option. For example: The…
-
I trying to install BI Publisher I'm getting an error that states "Set Word2007 flg failed".
I trying to install BI Publisher 64 bit , I'm getting an error that states "Set Word2007 flg failed".
-
Sample REST API url and payload to call BIP Report
Hi Team, We have requirement to call BIP report through integration in which we need REST API to call. I have standard REST API that is Run Report : /services/rest/v1/reports/{reportPath}/run url but help us to prepare sample API and How to pass the parameter.
-
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…
-
How to get ATP DB table in a SAAS BI report
I need to prepare a report with ATP DB, So I checked the availability. I also need to know how to get data from ATP DB into a SAAS report.
