-
BIP Report output downloaded name to change dynamically based on the parameter selected (PO Number)
The PO print BIP report is getting generated based on the PO selected in the parameters. When the output is generated and downloaded, the file is getting downloaded with the default name 'Output_Document'. Requirement is that the name of the downloaded file should pick the PO number selected in the parameters dynamically,…
-
Need attribute (DFF) columns included in supplied PVOs
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Jacobs Technology Inc Description (Required): Need attribute (DFF) columns added to the entity related BI Cloud Connector (BICC) PVOs for the following tables... HR_ALL_ORGANIZATION_UNITS,…
-
Inventory related Subject area need to include inter/intraclass conversion values
OTBI dashboard is being developed for CSRs to view the avaialbility of items in different UOMs. UOM conversions exist in the application and OTBI Subject area is bringing details of items with primary and secondary UOM, however inter/intraclass conversion details are not found in the OTBI subject areas.
-
Better methodology for entering SQL for Dataset within Data Model for BIP reports
Business Case: Our BIP reports require that large SQL scripts must be written to accomplish our reporting requirements since the "canned" reports are woefully insufficient. When you open the Dataset within the DataModel there is a TINY square box in which to insert SQL code. Our current methodology is to copy the SQL code…
-
Enhanced Transaction Approval Audit and Monitoring Report in HCM
We would like to request a pre-built, comprehensive report or a new standard data source within Oracle HCM Cloud that allows users to monitor and audit transaction approval history effectively. Currently, our organization faces significant challenges in generating a complete and reliable report on approval transaction…
-
Enable JWT token-based authentication for BIP web service calls
Currently, to retrieve the BIP output of a seeded ESS job via BIP web services, we use the endpoint xmlpserver/services/v2/ScheduleService?wsdl. However, this approach requires sending the username and password within the payload body, which is not a recommended or secure practice. Is it possible to enable JWT-based…
-
Access to favorite OTBI folder from OEC top
Description I created a shot cut icon on the OEC top screen to access my favorite OTBI folder. I refer to the following manual.…
-
Option to expose BI data model or report as a REST API
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Description (Required): BI reports should have an option to expose the data model or report as an API Use Case and Business Need (Required): we all are aware of the fact that a BI…
-
Ability to change Oracle Logo in ERP Cloud standard reports in bulk
Organization Name TAYLOR TECHNOLOGY SERVICES INC Description Client request to change the Oracle Logo in ERP Cloud standard out-of-the-box BIP and OTBI reports by applying a style change in a master template of all the standards reports. Use Case and Business Need How can the Oracle logo be changed for the client Logo in…
-
How to paste shortcut in OTBI?
When trying to paste a shortcut to a report in My Folder, the error Path not found populated. We have the option, and can, create a shortcut to a report in the folder the report is in, but when copying the short cut to My Folder, it errors. The reasoning for the shortcut is to have way to easily access the reports…
-
Support for Delegated Authority Logic in OTBI Line Manager Dashboards
Business Need / Use Case We are looking to enhance the Line Manager Dashboards in OTBI to support delegated authority scenarios, where a user (e.g., Chief of Staff) can view reports as if they were another manager. Example Scenario: John White is the line manager. Chief of Staff Matt Black needs to view the same dashboards…
-
How to add User Name (Report Run Name) in OTBI Title
I want to add User Name (Report Run Name ) in OTBI Report. I need this field at Report Title Level . I have used this command "Report Run By: @{NQ_SESSION.USER} | Run Date: @{system.currentTime}" but it is not giving results for Report Run By.
-
Fix the .xls output limitation of 65k rows for Oracle BI Reports
Please address the .xls output limitation to 65K rows. As an ERP Cloud Report user I need to have excel reports use the newer versions of excel if possible - XLSX so that I can get more than 65k rows of data and bypass the limitation for report output data.
-
Hide report boarders for BIP reports on dashboards
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Cetera Financial Group, Inc. Description (Required): The dashboard currently shows the entire screen (oracle top and side navigation areas) within the table and not just the graph that is…
-
Enabling Additional Address Attributes in Receivables OTBI Subject Areas
Organization Name MASSIMO ZANETTI BEVERAGE GROUP SPA Description We are currently using, in customers' site addresses, the Additional Address Attributes, those flexfield are stored in columns ADDR_ELEMENT_ATTR in HZ_LOCATIONS tables. Currently, from release 18A, these fields have been included under the OTBI Subject Areas…
-
Add ability to change color coding on custom Dashboard pie graph to something other than alphabetic
We have a custom ERP Dashboard that captures ESS jobs - Currently it captures the Status' of Error, Running and Succeeded for ESS Job Names. The issue occurs when one section of the dashboard report has 2 status' then the pie graph shows as green for Succeeded and orange for Running, and a separate section of the report…
-
Detailed log for OTBI Agent
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): University of Northumbria at Newcastle Description (Required): Currently, there is no way to view the detailed log and the output files generated by the OTBI Agent execution. It only shows the…
-
Account Analysis Report – Support for All Ledgers in one go
When we work on Account Analysis, we currently have to download the Account Analysis Report ledger by ledger / ledger set by ledger set. Oracle’s standard report does not allow us to select “All Ledgers” or “All Ledger Sets” and run it once. This process is very time-consuming and inefficient, especially for consolidated…
-
Option to rename the BICC Output file according to desired file naming conventions
Organization Name : Nokia Sol. & Networks Oy Description : Currently the output generated through BICC extracts consist of a Manifest, json and Output files zipped with names corresponding to their respective PVOs. We needed to rename them according to our naming conventions as the current names are very long and posing a…
-
BI Cloud Connector (BICC): Ability to join multiple data stores within BICC for a single file output
Hello, We have a requirement to collect the Fusion Payables payment data incrementally from various data stores (PVO) of payments, invoice payments, invoices, invoice lines and invoice distributions. Currently BICC (Business Intelligence Cloud Connector) allows incremental data from single data store only. We need ability…
-
OTBI - Accounting Period Number - General Ledger - Balances Real Time
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Guys and St Thomas NHS Foundation Trust Description (Required): Add Accounting Period Number to General Ledger - Balances Real Time. Currently Accounting Period Number is available in Journals…
-
25C Default Time Zone is lost on Schedule Reports when the calendar is selected
Since 25C when scheduling a report, the default time zone shows the schedule tab, for us its GMT. Once the calendar is selected the default is now (UTC-11:00) Midway - Samoa Time (ST) Can the time zone default be returned. Julie
-
Ability to Disable XML Download Option By Role
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): American Express Description (Required): In BI Publisher, at the Administrative Level, would like to provide these two options: 1) Provide option by role to prevent users from selecting the…
-
New Seeded HCM PVO - Non-date effective for Assignment Supervisors
The current seededHCM PVO for Assignment Supervisor,HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentSupervisorPVO, is dateeffective. There is no non-date effective PVO for assignment supervisors in thesame way there is for assignments (e.g. HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentNoDePVObeing non-date…
-
Need new attributes to be included in OTBI subject areas
Hi Team, We are looking out for the following additional attributes to be included in OTBI subject areas 1.- Enterprise Contracts Subject Area i. First signed version flag ii. Business Unit/Legal Entity Name 2.- Procurement – Implemented change orders Subject Area i. Include attributes such as PO original amount, proposed…
-
Need Multiperiod Accounting Reports
Description We are trying to implement usage of Multiperiod Accounting (Deferred Expense). After searching the Subject Areas, we found them lacking. Would like to see Columns available for Monthly Expense and Remaining balance of the Deferred Expense by month. A schedule showing the expense each month and the remaining…
-
Period Inventory Valuation report should have additional column with Work Order and Serial number
Period Inventory Valuation report should have additional column with Work Order and Serial number for WIP and FG this is helping on month-end stock reconciliations, cycle counts and annual inventory counts.
-
Ability to go back to prompt screen on BI Answers - OTBI
Description Once users run a BI answer (based on a subject area) in OTBI, users cannot go back to the prompt screen. When they go back, they have to reenter all the parameters from scratch. This means you cannot look at the data and filter very efficiently. You have to keep re-entering the parameters. This also means, if…
-
Update Timeout Error Message for users
Hello Everyone, We have recently implemented Fusion Data Intelligence, formerly known as Fusion Analytics Warehouse. To encourage user adoption, we are considering migrating large reports, such as Year-End (YE) and Month-End (ME), to FDI. As part of this transition, we aim to update the message displayed during report…
-
Change the Toggle Maintenance Mode Design
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): American Express Description (Required): The Toggle Maintenance Mode design needs to be changed. It is too easy to inadvertently put BI in Maintenance mode by clicking the Toggle Maintenance…
