-
Visibility to AWR and ASH SQL execution plan data from our Pod
"To accelerate root-cause analysis and reduce time-to-resolution, we need greater visibility into system performance metrics. Why are critical diagnostics such as AWR and ASH data not available to us? While the BIP Audit Report provides some useful insights, it is not a comprehensive performance-monitoring solution and…
-
Support XLSX template in BI Publisher to go further than 65k row limitation
Use Case and Business Need Hello, XLS template only support 65000 row of data, we need you to implement xlsx template to go further than the 65k row limitation thanks Original Idea Number: 153c64487e
-
Update Excel BI Publisher Template to XLSX (Current Excel Versions)
Description I would really like Oracle to do whatever they can to update the Excel BI publisher Template to be compatible with the current excel (XLSX). I think the BI Publisher Excel template is a really powerful tool for accounting users. 90% of the time reports are created, run, and then exported to Excel to be used in…
-
Allow current version Excel (xlsx) templates in BI Publisher
Description BI Publisher currently allows Excel templates only in Excel version 97-2003 (*.xls). Please update the BI Publisher software to accommodate the current version of Excel (*.xlsx). This will avoid issues with 65K records per sheet as well as provide other benefits of current Excel files. Thanks. Use Case and…
-
Use .xlsx Excel templates in BI Publisher
Description Currently only .xls Excel templates are available. The idea is to support .xlsx Excel templates as well in BI Publisher. Use Case and Business Need If .xlsx templates are supported, all new features in Microsoft Excel can be used. For example the Auto Save function in combination with OneDrive. It would also…
-
Subtotal BY in online BIP report builder
Our internal teams are able to create their own reports once a data model is built by using the "Create Report" button on the dm. As they are working through adding data, often times they add grouping and subtotals. Per SR 4-0002822354, the ability to have anything other than BLANK TEXT or a static value in a subtotal…
-
How to deliver reports from Oracle Fusion to Microsoft SharePoint?
Hi Team, We need to deliver the BI Publisher report output from oracle fusion application to Microsoft SharePoint. We created a service request also and they have confirmed that we could not achieve this with WebDAV configuration and suggested using content server. Please confirm if it is possible to deliver report output…
-
Expose Table for Bursting Output Results
Currently, Oracle gives us access to some BIP Auditing data for Fusion SaaS pods but it does not include the status of bursting output details. As is shown in the example below, It is possible to have one report job that ended with a "Problem", but have some of the bursted documents delivered successfully while others…
-
BIP PL/SQL data model does not enforce user-scoped row-level security (MOAC/VPD not initialized)
Users authenticate via three-legged OAuth2 against IDCS : – BIP already receives and validates their Bearer token - FND_GLOBAL.USER_NAME correctly resolves the calling user inside the data model, confirming identity propagation works at the session metadata level - However, VPD/MOAC predicates resolve against…
-
BI Publisher SFTP delivery connection support with Azure SFTP server
Hi, we are trying to configure in BI Publisher administration a delivery connection with a SFTP server and we are retrieving the following error: "Could not establish connection. Connection to Microsoft Azure SFTP server is not supported at this time" We have found this note in which it is said that is not supported but it…
-
Provide API for JDBC datasource Allowed Roles / role mapping .
Currently, JDBC datasource Allowed Roles / role mapping cannot be set through API. The DataSourceConfigService exposes operations like create/get/delete for JDBC datasources, but there is no API available for managing the Security role mapping shown in the UI. For another service integrating with OAS Publisher , if users…
-
Changing the URL link from BI / ESS to use GUID or other strong random ID.
We are reporting a issue where emailed links from Oracle Fusion (from BIP/ESS) are of the format: /xmlpserver/servlet/outputDocument?outputid=17084&content_type=xlsx We are concerned that these links are simply an auto incremented number, which bad actors can simply increment to browse for available files, particularly if…
-
OAC - how to get the BIP Reports Job history when we migrate from OAS to OAC
Hi, We have many customers using OAS2024 and OAS2025 and are using BIP jobs heavily, few are Daily, Weekly, Monthly etc. Our product Argus Safety Suite is pharmacovigilance software designed for life sciences companies, here data compliance and security is very important. Customers may ask for the history of the reports or…
-
OTBI Subject Area Analysis column contain HTML Content of clob datatype
Required a solution to use that column and able to download the report without error
-
Resolve Conditional Row Suppression
Problem Statement In our BI report, several job-related attributes are placed together on shared conditional rows in the RTF template. Due to the current conditional suppression logic, if either attribute in a paired row has no data, the entire row is suppressed, causing both fields to disappear - even when one field…
-
GSI - Data Source Access across Oracle Pillars (HCM and FIN) - BI Admin
Organization Name Southern Description The Oracle Idea Lab is logged to highlight a gap in the BI Publisher security design. As of today, a user with the ability to create a data model has the ability to query any data source: Navigation > OBIEE > New > Published Reporting > Data Model > > New Data Set > SQL Query > Data…
-
Provide ability to create OTBI reports but not BI Publisher reports
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte Description (Required): Reporting super users should be able to utilize OTBI Reporting capabilities through the distribution of the BI Author role. However BI Author also grants…
-
How to enable Watermark in excel outputs based on rtf?
Hi everyone, I have developed several BI Publisher reports using RTF templates with Excel (XLS/XLSX) output. There is a requirement to include a watermark in the Excel output; however, the watermark configured in the RTF template is not reflected in the generated Excel file. Has anyone encountered this limitation or found…
-
Enable Reporting Access to “Clicked” Metric in Oracle Recruiting Cloud (ORC) Campaigns
Product / Area Oracle Fusion Cloud HCM → Recruiting (Oracle Recruiting Cloud - Campaigns) Idea Summary The “Clicked” metric is currently available and visible at the campaign level within the Oracle Recruiting Cloud UI. However, this metric is not exposed through any reporting mechanisms such as OTBI subject areas, BI…
-
Migrating BICC -Extract's - PVOs -Configurations and changes from SIT>>UAT -to- Production
Hi Team, This regarding the migration of BICC extracts and PVO configurations. Following our recent updates from support concerning this enhancement request, we need to establish a reliable process for migrating these configurations from SIT to UAT and, ultimately, to PROD. Specifically, we need to ensure that all…
-
Customer Statement Report – Need Persistent Sequential Statement Number
Product: Oracle Fusion Receivables (AR) Category: Receivables / Collections Description: Currently, the standard Customer Statement Report in Oracle Fusion Receivables does not generate or maintain a persistent sequential Statement Number for each report execution. Each time the report is run, it executes independently…
-
Ability to store output BI Publisher to object storage on OCI
Organization Name : Gemeente Rotterdam / City of Rotterdam Description (Required): We have an external datawarehouse and need to export the data from SaaS to that datawarehouse. Not all data is available in the BI CC views, so we also need to use BI Publisher to query and download data. However, we cannot choose Object…
-
Request for utility to identify BI Publisher reports referencing impacted tables after patching
Description: After major quarterly updates (for example, the 26A update), certain seeded and custom BI Publisher reports may fail if underlying Oracle Fusion application tables are modified—such as when new columns are introduced or existing columns are changed. Currently, there is no delivered feature that allows…
-
BI Publisher add-in for Word using an iOS mac machine
Description We really need BI Publisher add-in for Microsoft office products to be compatible using iOS systems. Currently, it runs on Windows only. This is a huge issue for us. I have been trying to set up using a virtual machine on my mac, but I'm running into issues and Oracle is not sure if this will work either. Use…
-
RTF Template for requirements with 100+ columns
Currently we are facing limitation with RTF template as it doesn't allow more than 63 columns. We would want .xlsx extension output with 140 columns. Any ideas on how to achieve this?
-
BI Report Bursting to object Storage
As of today Oracle Fusion BI Publisher / Analytics Publisher has multiple bursting destinations like SFTP, Email, WebDav but OCI Object Storage is not available. With increasing use of OCI Object Storage, Oracle Business Intelligence team should add Object Storage as destination.…
-
Should be able Append prefix for file download names
Hello, When we try to export report or anything in OAS, It saves the export/download with default report name, However i would like to be able to append prefix or something else to differentiate the downloaded file name, so that its saved with distinct name instead of all generic downloaded file name, This customization…
-
RDG software page publish the current latest version number
We wish to automatically download any new version of the RDG software Currently you have to login with MFA to find if there is a new version Please display on this page the latest version number in a block we can read programmatically so we can check without manual intervention when a new version is available Oracle…
-
Publish Additional Logging for failed connection creation when using PAC connectivity
We extensively use PAC to connect to Oracle Databases from Oracle Analytics Cloud If a DV connection creation fails there is no logging reported to the Observability & Management Please extend the amount of logging that can be seen rather than customers having to raise SRs to retrieve the actual error message We have had 2…
-
Fetch Fields via BICC
We have a need for a couple columns of data to be extracted that aren't natively exposed via BICC: PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER1 PER_SENIORITY_DATES_F.SENIORITY_DATE We previously raised an SR requesting assistance with this requirement. Based on the update received, these fields are not available in the list…
