-
Manually enter multiple segment values in BIP parameter LOV
Organization Name Macquarie Global Services Description In BIP report, parameter LOV do not allow to enter multiple values separated by a delimiter. Example: We have parameter LOVs for Account, Reporting entity & Business Unit in a GL Balance Sheet. In each of these LOVs, the BI Publisher Report allows to select multiple…
-
Editor for Logical Queries
Description Create a new editor to enter and execute Logical Quries Use Case and Business Need At present report developers uses Physical SQLs to create BI Publisher report instead of using Analysis due to many reasons such as: * Many developers are from EBS background, and have worked with XML Publisher in past. They are…
-
Clearer link between per_all_assignments_m and payroll _run_results
Description Many times worker assignment data needs to be linked to payroll run results information. The assignment for the payroll run results can be identified in a variety of ways (via max logic and person_id) but a cleaner link between per_all_assignments_m and pay_run_results would be incredibly helpful for custom bi…
-
Ability to use REST API as data set
Description In BI Publisher it's possible to use SOAP web services as data sets. As REST API has more functionality it would be useful to have it available as data sets also. Use Case and Business Need For example only REST API allows apply prepayments to invoice. The idea is to create BI report which will select invoices…
-
Ability to use REST API as data set
Description In BI Publisher it's possible to use SOAP web services as data sets. As REST API has more functionality it would be useful to have it available as data sets also. Use Case and Business Need For example only REST API allows apply prepayments to invoice. The idea is to create BI report which will select invoices…
-
No Open Option for BIP Report shortcut
Description Shortcut works only for OTBI report but not for BIP. Please enable OPEN option for BIP report shortbut. Problem Description --------------------------------------------------- I have created shortcut of a BI Publisher report, but it does not allow me to open/run them using the shortcut. Permission for the…
-
Automatically populate Job Name for BI Publisher scheduler
Organization Name Abcam PLC Description Need to populate Job Name for BI Publisher scheduler automatically. The user will manually schedule the BI Publisher report and on submitting the request, the Job name should be automatically populated. Use Case and Business Need Currently user will manually schedule the BI Publisher…
-
Automatically populate Job Name for BI Publisher scheduler
Organization Name Abcam PLC Description Need to populate Job Name for BI Publisher scheduler automatically. The user will manually schedule the BI Publisher report and on submitting the request, the Job name should be automatically populated. Use Case and Business Need Currently user will manually schedule the BI Publisher…
-
PASSWORD PROTECTION FOR EXCEL (.XLS) OUTPUT SENT THROUGH ORACLE BI PUBLISHER
Organization Name Hilton Resorts Corporation Description The customer needs this functionality to password protect the Excel (.XLS) output because when they schedule BI Publisher reports that have output in Excel (.XLS) format and send the reports to clients bycontain critical business data. Use Case and Business Need The…
-
Connect PowerBI and other data analytic tools to Oracle Cloud BI Publisher/OTBI
Organization Name Euronet Payment Services Description Oracle Business Intelligence does not allow for users to connect their databases with external analytics tools such as PowerBI and Tableau, instead locking the data from their systems behind their own internal tools. Our organization obviously does not use Oracle…
-
Auditing Reports to capture changes to the Permissions of the BI Catalog objects
Organization Name Falconi Description There is already audit reports to BI Publisher catalog objects, as doc bellow: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2059102.1 Those reports don't capture changes made on objects permission (I have confirmed this on a MOS Service Request), so I would like to have a…
-
Allow "Export entire workbook to excel " to work on dashboards with BI Publisher reports
Description We have created a Dashboard using multiple BI Publisher reports. All reports share the same prompts. Some reports contain charts and some are just tables of data. When using the "Export entire workbook to excel" function the exported excel sheet creates all the correct worksheet pages and headings however, the…
-
Allowing selection of muliple and/or all columns to be moved from Data Models into BI Publisher Repo
Description Both the amount of man hour and risk of developing carpal tunnel syndrome would be tremendously reduced if multiple and/or all columns can be selected while building BI Publisher Reports (BIP) from Data Model in OBIEE BIP interactive view. The ideal outcome would be enabled to select multiple columns by holding…
-
Allowing selection of muliple and/or all columns to be moved from Data Models into BI Publisher Repo
Description Both the amount of man hour and risk of developing carpal tunnel syndrome would be tremendously reduced if multiple and/or all columns can be selected while building BI Publisher Reports (BIP) from Data Model in OBIEE BIP interactive view. The ideal outcome would be enabled to select multiple columns by holding…
-
Fusion Applications BI Publisher - Support for External WS Datasource
Description As per ER 27912664, there is no support for WebService Datasource in Fusion Applications BI Publisher. The feature will be deprecated in future releases. However we would need this functionality to be able to invoke and integrate with OIC webservices which are being used to process data based on inputs from BI…
-
Enable CSV output in BIP
Description Enable CSV output as default option for BI reports Use Case and Business Need CSV output is quite common when creating interfaces to deliver reports to 3rd party vendors. The CSV option built in to BI Publisher is actually a data dump and does not follow the construction of the report. It would be quite…
-
Support consistent BI Publisher image behavior in PDF and PPT output within an RTF template
Organization Name Williams Description Customer reasonably expects output consistency between PDF and PPT output when images are embedded within a BI Publisher RTF layout template. Use Case and Business Need Support workaround was provided for current use case, but image size and/or complexity would easily make this…
-
Support consistent BI Publisher image behavior in PDF and PPT output within an RTF template
Organization Name Williams Description Customer reasonably expects output consistency between PDF and PPT output when images are embedded within a BI Publisher RTF layout template. Use Case and Business Need Support workaround was provided for current use case, but image size and/or complexity would easily make this…
-
BI Publisher: RTF template - export to excel formatting issues
Organization Name Deloitte Description The report created using RTF Template with the default output format in PDF, results in merging of cells when the output is exported as an excel format. Can we have the cells appear in single column instead of merged cells when the reported is exported in excel format? As well, we…
-
BI Publisher: RTF template - export to excel formatting issues
Organization Name Deloitte Description The report created using RTF Template with the default output format in PDF, results in merging of cells when the output is exported as an excel format. Can we have the cells appear in single column instead of merged cells when the reported is exported in excel format? As well, we…
-
PASSWORD PROTECTION FOR EXCEL (.XLS) OUTPUT SENT THROUGH ORACLE BI PUBLISHER
Organization Name Hilton Resorts Corporation Description The customer needs this functionality to password protect the Excel (.XLS) output because when they schedule BI Publisher reports that have output in Excel (.XLS) format and send the reports to clients bycontain critical business data. Use Case and Business Need The…
-
Upgrade needed to Data Set Definition Window
Description New Data Set window provides really basic functionality and must be enhanced with advanced features in absence of direct database access in cloud applications Use Case and Business Need Pop-up window that allows us to store query as a data set provides very basic functionality such as: * Validates the query *…
-
Search Multiple GL accounts from BI Reports using concatenated segments
Description We need to be able to fetch multiple GL accounts from a BI report using the entire account number (i.e. concatenated segments). We need to be able to search for GL accounts using the LIKE lexical operator in BI reports. Currently, this is not supported for WHERE statements and no results are returned. Using a…
-
BI Publisher Report - Suffixes Template Name and Output File Name - Repeats
Organization Name Infosys Description BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at the end. Business users while downloading these report outputs, they get a file with unwanted template name suffixed with it and it creates confusion. Test Report 1_Layout1.PDF Here we have…
-
BI Publisher Scheduler does not provide Multi Language Support for data translation
Organization Name Chartwell Master Care LP Description When a multi-language BI Publisher (BIP) report is being RUN ONLINE, both, static template content and dynamic data, are translated using User profile's currently selected language, and it works fine. Problem appears when the report is SCHEDULED using BIP Scheduler.…
-
BI Publisher For Cloud Apps - Start query "WITH"
Organization Name AWE plc Description Allow BI Publisher in Cloud Apps to have queries which start with the WITH statement e.g : WITH a AS (SELECT 1, 2 FROM DUAL) SELECT * FROM a Should work (in the same way as SELECT 1,2 FROM DUAL) Use Case and Business Need If we have big legacy prewritten queries, which begin WITH, then…
-
Include Overwrite existing file option to BI publisher web services
Description We are trying to Overwrite existing file to the BI publisher instance using web services. The WSDL used is as follows: https://ejlv-test.fa.em2.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?WSDL To upload a report to BIP we use the below request: <uploadReportObject>…
-
BI Publisher Digital Signature only uses one Digital ID
Description Oracle provides a mechanism to have just 1 digital signature, but we have requirements to choose digital ID dynamically between a few signatures possibles. Use Case and Business Need The customer requirement is not to use multiple signatures in the same PDF File. The requirement is to choose one digital…
-
BI Publisher Digital Signature only uses one Digital ID
Description Oracle provides a mechanism to have just 1 digital signature, but we have requirements to choose digital ID dynamically between a few signatures possibles. Use Case and Business Need The customer requirement is not to use multiple signatures in the same PDF File. The requirement is to choose one digital…
-
ERP Cloud: Custom BI Publisher Report SQL Error
Description . Use Case and Business Need . Original Idea Number: 3d36bbb3ad
