-
Enable Trusting Add-ins by Digitally Signing
The BI Publisher Add-ins for Office applications cannot be set to trusted in a policy because they are not digitally signed by the publisher. As part of ongoing security hardening and compliance with CISA guidance, Add-ins not digitally signed by a trusted publisher are now blocked. This seriously impacts BIP reporting…
-
Embed Images in mail body through bursting
Description: Allow Oracle BI Publisher users to include a customized email body with headers, footers, and images when using bursting, while also providing an option to add a separate document as an attachment within the same email. Use Case and Business Requirement: Many businesses use Oracle BI Publisher's bursting…
-
The ability to create a view and inquiry role/access to see the BI Publisher Administration Page(s)
In production we limit the folks that have administrator access; however, we have support staff that helps troubleshoot issues before they get to an application administrator. To make those folks more effective, we need to grant them a view, inquire and reporting equivalent of system administrator. While working on…
-
BI Publisher Desktop for Word 365 64 Bit
Description Bug 29666089 : BI PUBLISHER DESKTOP FOR WORD 365 - WORD FREEZES The current version of BI Publisher Desktop for 64-Bit is not very stable. It crashes and freezes so frequently and randomly that it is hard for us to give estimates for report development. We are requesting Oracle fixes the 64-bit version of BI…
-
Connecting to Microsoft Azure Storage SFTP from Oracle BI Publisher
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Price Waterhouse Coopers. Description (Required): I am getting below error while trying to create new SFTP connection to connect to MS Azure Storage SFTP from Oracle fusion BI publisher…
-
BI Publisher Prompt Search Default
To have the option to change the search function in BI Publisher prompts to something else i.e. "contains" instead of the current default "starts with".
-
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…
-
Ability to display repeating section across the page (from left to right) in OTBI report.
Description Currently in OTBI report (BI Publisher Report) we can only display the repeating section from top to bottom, need an option to display the repeating section from left to right. Use Case and Business Need Business needs a report to display the product build quantity at product group, yearly/quarterly level. For…
-
Renaming custom folder in BI Publisher
Organization Name Birlasoft Limited Description BI Publisher currently allows to rename the custom folders created in BI directory but post renaming all report under the custom folder falls into error as data model and report link is broken. Only workaround is to edit each individual report and run it which wouldn't be…
-
Addition of Auditing Capabilities to the delivered BI Audit Reports
In addition to what is already provided on the BI Audit reports, it would be more useful if we could have the following added: the Data Model name added to the Report Data set & Query Execution report, currently only has data set names, which isn't very helpful since they live within the Data Model. This would help…
-
How to Schedule a BI Publisher Report with Dynamic time range in parameter Values
Issue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle's standard reports, the "BIP Report Audit Trail," located in the Audit Reports section. The Client specific requirement is to filter the report data based…
-
How to Schedule a BI Publisher Report with Dynamic time range in parameter Values
Issue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle's standard reports, the "BIP Report Audit Trail," located in the Audit Reports section. The Client specific requirement is to filter the report data based…
-
Configurable BI Publisher Access to Export
Oracle BI Publisher reports provide users with the capability to both view and export reports. Due to the sensitive information contained within these reports, permitting users to download them locally could potentially result in data leakage or unauthorized access. We need the functionality to restrict or remove the…
-
Option to move all fields from a BI Publisher Data Model/Date Set into a report table
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Sandia Description (Required): After creating a BI Publisher data model, we move onto report creation. There is often a need to move all of the data fields from the data model into a table.…
-
Create JSON output format in BI Publisher
We have a request to raise a BIP report using JSON output. We needed to build a complex report query to get JSON layout, but when business user runs this report, everytime they have challenges to convert it to JSON output. The output option JSON should be available in BIP similar to eText and XML.
-
Is there any function available to get day of the week in RTF BI publisher
Is there any function available to get day of the week in RTF BI publisher let say i have some date comming in XML format as below : I have a <PAYMENT_DATE>2024-02-26</PAYMENT_DATE> column in XML file and I am using this value I need to bring back previous sunday and Saturday dates in RTF templates Not getting any date…
-
Adding conditional formatting to Pivot table on BI Publisher
Hello Oracle Team, I have created a BI Publisher report on Excel that contains a pivot table, When I tried to add conditional formatting to the pivot table I have noticed that it is only possible to apply one condition at a time on the same variable field (in regular tables we can add up to 3 conditions but in pivot table…
-
BI Publisher Audit Reports - show responsibility used to run BIP reports
Include responsibility/role details that were active/selected at the time of running BIP reports in BIP Audit reports or in iau_common table. This information would be helpful when validating if users are running reports with expected access level based on responsibility/role.
-
BIP Report Output when there are no rows should return the expected headers, not DATA_DS
We currently schedule reports to output as a CSV to the UCM for import into our local data warehouse platform. This works very well except on the occasion that the report has no data to display. When data exists, we get the expected header row, followed by data. when there is no data (for any of a dozen reasons), we get…
-
Scheduling BIP reports within FAW or OAC without passing user name and password in request payload
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):Ameren Services Description (Required): For ScheduleService SOAP call, username and password needs to be passed in request. While using ScheduleReportWSSService which does not required username…
-
BI Publisher Schedule to allow reports to be scheduled on Monthly basis for the last weekday of the
Organization Name Baylor University Description Curently, there is an option for last weekday; however, this defaults to the last Friday (-1FR) of the month instead of the actual last weekday of the month. There is an enhancement request for this idea: Enh 29199776 - NEED TO BE ABLE TO SCHEDULE A REPORT TO RUN THE LAST DAY…
-
Enabling REST APIs for BI Publisher for SaaS based customers.
REST APIs are very handy when it comes to middleware tools. They are lightweight and faster to implement. There are REST APIs for BI Publisher (refer: https://docs.oracle.com/middleware/bi12214/bip/BIPAP/op-v1-reports-reportpath-get.html). Unfortunately these REST APIs are not available for ERP and HCM SaaS based customer…
-
Ability to hide 'Schedule, Notification and Diagnostic' tabs of a BI Publisher report job
Organization Name Tecnicas Reunidas Sociedad Anonima Description Ability to hide 'Schedule, Notification and Diagnostic' tabs of a BI Publisher report job Use Case and Business Need In OAC, the default 'Timeout for online reports' for BI Publisher reports is set to 535 seconds and this cannot be changed. This limits end…
-
Oracle Analytics Publisher report changed due to timeout change error message
XMLPGEN-03111: User requested cancel operation..." need to update this message as Time out Report is canceled due to timeout mentioned in Memory Guard, but message is coming as " XMLPGEN-03111: User requested cancel operation" which we need to change as "XMLPGEN-03111: Time out for this report cancel operation..." so that…
-
Publisher report Parameter values
How to capture the Publisher report parameter values when users are running Online Publisher reports from Analytics url. Now at present product OAS 7 bi_publisher.log query is showing pramameter vlaues as ? (question marks), but how we can see the actual parameter values which user selected while running Online report from…
-
Oracle Analytics Publisher report changed due to timeout change error message
XMLPGEN-03111: User requested cancel operation..." need to update this message as Time out Report is canceled due to timeout mentioned in Memory Guard, but message is coming as " XMLPGEN-03111: User requested cancel operation" which we need to change as "XMLPGEN-03111: Time out for this report cancel operation..." so that…
-
Show Alert message on apply button in BIP Reports
We have 2 Parameter in BI Publisher Reports Name - From Date and To date ,where user can select both the date value . The requirement is if user select from date and to date and if try to view the reports and if the difference between from date and To date is more than 31 days then Reports should not run that means when…
-
Unable to copy and paste the values in OAS publisher Prompts/Parameters
Hi Team, We are unable to copy and paste the values in Oracle Analytics Publisher Report prompt/parameter where the parameter type is Menu. We have the the only options like Multi select and Select All options only. Ex : Business users wants to run the report for 50 + GFR Values (Numeric and Description values) Version :…
-
Add ed25519 as one of the supported algorithms for BI Publisher.
Oracle to add ed25519 as one of the supported algorithms for BI Publisher. Below the SR# details SR 3-33673424031 : BI Publisher SFTP Connection Timeout
-
Restrict data model creation to only access views
Organization Name Office Depot Description Currently if user has access to "BI Publisher Data Model Developer" then he can query any table and views from database. We need ability to restrict user to query only "views" from database which only gives access to data based on users data access. This will restrict data modeler…
