-
How can I get the original column header in the CSV output of a BI report without underscore
By default, the CSV output from BI Publisher modifies the column headers by replacing spaces with underscores and converting them to uppercase. I would like the CSV output to retain the original column header formatting exactly as defined in the Data Model (e.g., "Employee Name" instead of "EMPLOYEE_NAME").
-
Font formatting lost on PDF output via new rtf template
Hi A while ago we had issues with reports loosing it`s bold-font formatting after we changed something in RTF template. Oracle support advised us to do the font mapping in Bi publisher. We did map, for example for Arial font, and that seemed to do the trick. Didnt have problems since then. Now the problem is back although…
-
How can I remove the DRAFT watermark from the PO PDF when viewing PO draft in Oracle Fusion?
We have a requirement to remove the DRAFT watermark from the Purchase Order PDF in Oracle Fusion Procurement. Currently, when viewing or printing a PO in draft status, the system automatically displays a DRAFT watermark. Our business requirement is to remove this watermark regardless of the PO status (draft, open,…
-
Setting Filename when creating email bursting in Publisher
While setting up email bursting in oac publisher, is there a way to control the name of the attachment file? I would like to have a fixed filename concatenated with date. For example: name of the file that user receives as email attachment: YOURFILE_YYYYMMDD.xls
-
'No output available' with Report Status 'Success'
I have a notification (BIP report) that I am testing in Prod, which is a copy of one we are using in Prod. It is scheduled to run every 30 minutes. When it completes with a status of Success, there is no output generated for my test notification. If I click 'Republish' the report output appears on the report output page. I…
-
Unable to Install Oracle Analytics Publisher
I’m trying to install the Oracle Analytics Publisher add-in from the official download page: https://www.oracle.com/middleware/technologies/analytics-publisher/downloads.html However, the installation fails due to compatibility issues with the latest Microsoft Office version (Microsoft 365). Our IT department confirmed…
-
RFQ Supplier notification attachment
Hello Everyone, I am working on Oracle Fusion Sourcing (Procurement). When an RFQ is submitted and published, the system sends an invitation email to the supplier with a PDF attachment (commonly referred to as the Supplier PDF). This PDF is generated from the report named “Supplier Negotiation PDF Report”. However, when I…
-
Helm Chart for a Kubernetes Install
I install and maintain a Oracle Analytics Publisher that runs on Weblogic for the purposes of printing PDFs from APEX. The current effort is to move as much infrastructure to a RKE2 Kubernetes cluster. Are there Helm charts available for this type of install? Does anyone have recommendations for Weblogic and APEX Tomcat…
-
BIP Report Dynamically
Hi We have a BIP report with daily frequency, and we need to pass the schedule start time to the data model SQL input parameter#p_from_date to fetch the incremental value.
-
Fusion to BI Publisher connection
Hi everyone, I’m getting this error while using the BI Publisher connector in Fusion: The report definitely exists in that folder, and I can run it manually in BI Publisher. I’ve already verified: The report path and extension (.xdo) Correct credentials Correct environment (FDI Test) Full path entered as…
-
Analysis / Dashboard Download with API
Hello, Is it possible to download an Analysis or Dashboard from Oracle BI using the SOAP API or REST API? I am specifically asking about downloading the actual catalog file, not the output of the analysis. Any guidance or examples would be greatly appreciated. Thanks, Attila
-
BI Report Calling service isssue
Hi Team We are calling BI report using SOAP service but getting below error. <reason>CASDK-0033: Received a SOAP fault while invoking endpoint target: This indicates a processing exception on the service endpoint side. Please check service side logs to further diagnose the problem <![CDATA[ Fault Code : env:Receiver…
-
Does SOAP Api Supports JWT for getting BIP Reports O/P - xmlpserver/services/v2/ScheduleService?wsdl
Hello Everyone, I was able to use the SOAP WSDL — "xmlpserver/services/v2/ScheduleService?wsdl" to get the BIP Output of a seeded ESS job, but this requires a Username and password to be sent in the body of the payload. Could anyone guide me if there is a way to use JWT token to run this payload? WSDL Services Testing - I…
-
Create Customer Statements Seeded Bursting Logic Fails for International Customers
Hi, is anyone experiencing this error? ####[2025-09-09T17:48:48.847+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/rfd/2171543/out/2171543.xml Request ID: 2171543 ClassLoader is…
-
BI Publisher Integration with Apex Iframe
Hi Team, We would like to Integrate and show BI Publisher Report(PDF Format) to Apex and we need to show BIP Report with parameter selection of BIP only to Apex Iframe. We are facing challenge in showing BIP Report page in Apex with Iframe with error as 'Connection Refused'. Please let me know in case any one has worked on…
-
standard Income Operating Statement by Division
Hi, we are trying to write a query which returns a standard Income Operating Statement by Division, combining financial data (actuals, budgets, encumbrances) with hierarchical metadata (funds, departments, accounts) to produce a comprehensive fiscal report. The query is causing the performance issue. attached the query,…
-
Error Installing BI Publisher - Set Word2007 flg failed
I am currently trying to install BI Publisher on my laptop. When trying to install I'm getting an error that states "Set Word2007 flg failed". Has anyone experienced this before? Appreciate any guidance you may have!
-
Embedding Oracle Publisher Report Content into Applications
Hi, Is there any way I can embed publisher report in Web Application. I also wanted to have options to export the embeeded report into pdf, excel, powerpoint similar to what we have in oracle xml publisher report.
-
BI Publisher - add 12 months to a date element in rtf template
<?format-date:xdoxslt:ora_format_date_offset(DATE_SEGMENT2, 365, '+');'MONTH DD, YYYY'?> Date_segment2 (a placeholder) - by itself is able to output January 1, 2025 This is the code I am currently using in my rtf template, and I am able to output January 1, 2026 with it. However I am aware this will not account for leap…
-
A report that lists all BI Catalog folders along with their permissions and history of the folder
-
FDI within Word
Team, Can I use Oracle Fusion Data Intelligence (FDI) within Microsoft Word in the same way you might use BI Publisher or OTBI reports that integrate with Word templates ? Appreciate any pointers. Thanks
-
Account Analysis Report - How to add new columns in Report
There is one requirement to make custom report by using Account Analysis report which is a standard report in which we have to add new columns in the report like PO Number, Asset Number, Chart of Accounts, Reason Code, and Credit Memo. They are using standard package XLA_ACCT_ANALYSIS_RPT_PKG in the report. Is it possible…
-
How does the last update date of seeded reports and dashboard of change
Hello, During our audit review of BI reports, we came across seeded reports which show a different last modified date than our system upgrade date i.e., from 23A to 23B, etc. I checked on Oracle support, but not able to find anything that says the reports were last modified as part of certain patch. Is there any way I can…
-
BI Publisher Table Grouping Help
So, in BI Publisher, in my data model I have a subgrouping for one part of my data set but in the template, I have a for each on the subgrouping but they're not appearing correctly. Basically, for The parent group, I would have a header, but there would be a table which would have each element in the child group based for…
-
Last login of service account
Summary: I would like to find when a particular service account last logged in either through UI or through Webservice or both in Oracle ERP Fusion. Is there any SQL query to run BIP report. Version (include the version you are using, if applicable): 25C
-
Issue while installing BI Publisher plugin for word
It looks like this after installation.
-
Oracle Analytics Publisher Desktop installation fail
Hi Team, I am trying to install I'm trying to install Oracle Analytics Publisher desktop om windows 64. Initially it failed during first installation. I checked in programs and features through control panel but nothing was visible. I cleared it from program files , start menu but still getting same error . I followed all…
-
Excel Template Not generating Out properly for Nested Table Joins
Table is joined in Data model as given below : Parent Table HRC_TXN_HEADER is joined to other tables. The full row is repeated under Parent group: Txnh and the highlighted 2 columns : Base Name and Amount, repeated for group : Xmlcache Detals But receiving output as shown below. But we need the columns from A to M also…
-
Burst to multiple destinations (FTP server and Email)
Hello - We use Fusion BIP application for ERP. I wanted to know if it is possible to have a Bursting Definition in the Data Model that will burst both a file to an FTP server location, as well as an email? If so, is there any example someone can share of this bursting query. Thanks in advance!
-
Oracle Analytics Server Migration to Another Server (Publisher content)
Product: Oracle Analytics Server 7.6 OS: Oracle Linux 7.9 Scenario: I am trying to duplicate a set of server data from Server A to Server B. Based on my research, the scheduler jobs used by BI Publisher are stored in the schema. To achieve this, I exported the entire RCU schema from the database on Server A and imported it…
