-
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
-
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…
-
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.
https://us.v-cdn.net/6037859/uploads/9GBQ8EEQAYTE/steps-and-screenshots.docx 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…
-
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.
-
How to burst the BI Report result file to particular UCM account through BI Report bursting ?
Hi All, We are trying to place the BI Report result file to below mentioned UCM account using BI Report bursting but its not getting placed to the mentioned account. Bursting details are mentioned below for reference. UCM Account : fin/receivables/import Bursting Query : SELECT 'X' AS "KEY", 'XXXX_AR_INV_PRT_CSV' TEMPLATE,…
-
While triggering multi-valued parameter BIP report from my integration code, ^^ is btw values.
When i triggering a multi valued parameter - BIP report from my integration code, I am finding ^^ is appearing between multiple parameter values for that paramatere in the fusion reporting screen, (in report job history), although my data have no traces of ^^. The value looks some what like this - VALUE1^^VALUE2^^VALUE3…
-
Unexpected single default value selected within the list of values for a parameter
Oracle Business Intelligence 12.2.1.4.0 Hi, I’m coding a BI Publisher report using a Data Model. There is a parameter within the data model for employee number. Linked to this parameter is a list of values using a SQL script to find all eligible employee numbers. This is the setup for the Employee Number parameter (no…
-
BI Publisher Word Add-in
Hello, I have built a custom report in ARCS where we have displayed all unmatched transactions in ARCS with their aging bucket, number of transactions and the amount. We have columns for the Periods which holds the Period we run the report for (Period being one of the parameters) but in the SQL query, we have also included…
-
Check before changing values in a lookup table used in HCM
Good afternoon. In Oracle HCM we are planning to modify some values in the lookup table, ORA_HRT_CERT_STATUS. We know it holds status for Certifications/Licenses, with values like Active, Expired, etc. Before we start changing any values in this table we'd like to know if this table is leveraged anywhere else in HCM, other…
-
Rowmark visible on export output of BI Publisher Report with excel template
Hi, I created an excel template based bi publisher report using sql query. Expected Output Country Region State County Item Sales Germany North W1 C1 Laptop 20 Mouse 22 Coffee 100 C2 Laptop 33 Mouse 31 Coffee 311 W2 C3 Laptop 87 Mouse 88 South W3 C5 Laptop 11 Mouse 12 Coffee 12 W4 C6 Laptop 11 Mouse 12 Coffee 12 Spain…
-
Failed to install OracleAnalyticsPublisherDesktop-8.2.0-win32.exe
Hi, I'm trying to install OracleAnalyticsPublisherDesktop-8.2.0-win32.exe but getting an error code -3 Execute-Process -Path "$dirFiles\OracleAnalyticsPublisherDesktop-8.2.0-win32.exe" -Parameters '/S /V/qn' -WindowStyle 'Hidden' Can you please advise how to solve this? Regards,
-
Conditional Region within repeating group?
So, I'm trying to create a conditional region inside of a repeating group. There are xsl attributes as part of the if code. However, I get an error saying "element xsl is not supported yet". Is it possible to have a conditional region within a repeating group in BI Publisher for Desktop for Word?
-
็How to custom Trial Balance Report
Summary: How to custom Trial Balance Report by adding Filter Conditions accounting segment in Trial Balance Report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications24B (11.13.24.04.0) Code Snippet (add any code…
