-
Improving SQL Developer Productivity in Oracle Fusion HCM
Problem Statement: Oracle Fusion HCM SQL Developer Experience Currently, developing and validating SQL queries for Oracle Fusion HCM is a highly fragmented and time‑consuming process for developers. SQL code is typically written in external editors such as Notepad++ or similar tools, without any direct connection to Fusion…
-
Analysis Reports should open on the prompt page when opening from Favorites
Organization Name ARCTIC SLOPE REGIONAL CORPORATION Description When selecting an Analysis from the Favorites drop down it opens in Edit mode on the Results tab. We would like it to open as if the user selected Open from the catalog entry. Use Case and Business Need When opening in results tab no parameters have been…
-
Supplier Audit Report - Extension Request
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Johnson Controls Inc Description (Required): We have an Audit Requirement specific to Supplier Master Data Changes wherein Compliance team would like to trace list of all changes done at the…
-
Report that provides a list of permissions for all folders in BI Catalog
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Description (Required): There should be a Report that provides a list of permissions for all folders in BI Catalog. This will ensure better controls and will reduce manual effort of…
-
Token base connection for the content server instead of Username and password
We require Token base connection for the content server instead of Username and password. We are using this connection to write BIP report output to specific folder.
-
UOM Conversion Values in OTBI
Capture the UOM conversions (interclass and intraclass) in an Oracle OTBI subject area. UOM conversion is already setup in the system and should be able to be referenced per the item for interclass and UOM conversions. We understand that reporting UOM can be used to display an item in a different UOM, but we are looking…
-
Automation of OTBI reports for version source control and deployment
Organization Name Pengurusan Air Selangor Sdn Bhd Description We are looking for the mechanism to automate the archive and unarchive steps of custom BIP catalogs from Reports and Analytics dashboard so that the reports and data models can be moved across different instances / pod without manual intervention. This mechanism…
-
Last Modified Date on OTBI Dashboards does not update when changes are made
The Last Modified Date on OTBI Dashboards does not update when changes are made. This is an audit issue and is not user friendly in the sense that significant changes can be made to a Dashboard but no way to prove when it happened. Other OTBI object types, such as Prompts or Analysis, update the Last Modified date…
-
Restriction of Data in reports and analytics while creating Data Model
Currently any user account having access to BI Author role along with BIPDataModelDeveloper role is providing the ability to see any sensitive information in the Oracle fusion irrespective of data restrictions placed in the front end through role assignments. That is, this user while creating a data model can see any HCM…
-
Recycle Bin Feature for Recovering Deleted Analysis Reports
Description (Required): Currently, there is no Recycle Bin or functionality to recover deleted analysis reports in the development environment of Oracle Analytics. If a report is accidentally deleted before being implemented in production, it cannot be restored—backups are only available in production and do not cover…
-
Automated Migration Solution for OTBI Objects Across Environments
Description : The current process for migrating Oracle Transactional Business Intelligence (OTBI) objects between development and production environments is entirely manual. Users must export and import files multiple times daily, which is time-consuming and prone to errors. This manual approach increases the risk of…
-
Scheduling a Analysis Subject Area Report to SFTP server
Organization Name Veritas Technologies LLC Description We need to send a Report generated through Analytics(OTBI) via New->Analysis straight to a SFTP server. But we can see that this functionality is only available if the report is generated through either New->Reports or New->Data Model. We would want the option to send…
-
Access Output files from ESS jobs submitted by a different user without BI Administrator Role
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte Description (Required): Users should be able to access and download output files of scheduled processes submitted by a different user without having the BI Administrator Role. Example…
-
How to avoid user account creation when new employee record is being created?
Hi Team, Could you please help with this query? we need a way to avoid user creation when we are creating a new employee record in oracle. Right now, it is creating user account automatically Oracle SR 3-36572552961 raised too
-
Allow to generate links to objects directly from the reports
Right now if the implementor or the responsible of the development need to assign a link to the object, it has to enter the URL and execute modifications in order to be able to open the object. The Idea is to allow to select if the developer wants to generate a link to: -The Main page of the object - The Summary page of…
-
Restricting data access in OTBI and BIP Reports using AoR's
Organization Name Tesco Description Hi Oracle Team, We have a requirement where we need to restrict the employees data related displayed in the OTBI Analysis by specific AoR's.. If the employee has 3 different AoR's then the OTBI Analysis currently displays data based on all the 3 AoR's and displays a huge set of…
-
Subject Area for Report Agent Details
In the current competitive business landscape, the ability to provide seamless reporting and visibility into key functionalities is crucial to maintaining operational excellence and elevating customer satisfaction. For a company that offers functionality to create and deploy agents for delivering analyses to end-users, the…
-
Enhance Session Timeout Management with Warning Pop-Up and Auto-Save Options in HCM (OTBI)
Currently, users experience unexpected session timeouts in the Oracle HCM application, which results in the loss of unsaved updates and, at times, inaccurate data. There is no advance warning before a timeout occurs, nor is there an auto-save feature to preserve work in progress. For example, when updating audience…
-
BICC extract PVO for FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVO
Organization Name Ricoh Europe PLC Description We are using data store "FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVO" in BICC for the extraction and we have found duplicate data in primary key column "LOOKUPCODE, LOOKUPTYPE, SETID and VIEWAPPLICATIONID" in the data extraction file and also it is a must needed VO. We…
-
Permissions Information in Oracle Reports and Analytics across Sub folders and Items
Need to have a report to get all the Permissions setups in Oracle Reports and Analytics /Shared/Custom/ folder across Sub folders and Items. This will greatly help if we change permissions at the top level and how it cascades to the Item level as there are individual seeded reports with specific privileges which gets lost…
-
To add custom extension to Email bursting output
We have a requirement to burst a BIP report output to an email with a custom extension. (.sif) Currently, when we tried to add file extension in the output_name as 'File_name'||.'sif' it is coming like File_name.sif.txt(Our template type is eText and output type is text). We want it to ideally come as File_name.sif and not…
-
Allow report with eText template to output a report to csv with the same structure
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Accenture Description (Required): Currently we can upload an eText template for a report and the report will follow the structure defined in the file. Although when exporting to csv it will…
-
OTBI: “Navigate to BI Resource” Should Map Is Prompted Column Filters (Incl. Between)
Summary When navigating between OTBI analyses using Action Link → Navigate to BI Resource, only a subset of prompt types are automatically mapped to destination analyses using Is Prompted. Column prompts using the Between operator are not reliably passed, resulting in incomplete filter context on the destination analysis.…
-
Ability to see output of an OTBI agent
Description Hi, There should be an option to view history of the Agents from OTBI UI. Regards, Rakesh Use Case and Business Need We can verify the output of an OTBI agent. Original Idea Number: 9f1a7ee3e6
-
OTBI Analysis Export to Excel or CSV limitation
Hi Team, The OTBI Report export to excel or csv limited to 250k rows.This Limit is very small for business requirements .It's better to provide some configuration to increase this limitation in OTBI atleast to the limit that excel provides. You can look at this SR (SR 3-33765290921 - Potential for extension of number of…
-
AP Subledger Balance by Supplier Invoice Details Report-Grand Total mismatch in exported report
Problem Description: Report name: AP Subledger Balance by Supplier Invoice Details. 159 rows for a total Liability Balance Amount of 71,060,492.97 on screen. after exporting the report, it exports 159 for a total of $72,343,504.74 which is 1,283,011.77 more than the total on the FDI page. Proposal: Only after changing the…
-
Publish Custom written queries as BICC Extracts
I believe if this idea is implemented - could substantially enhance BICC extracts and very effectively work when building datalake/Datawarehouse. By developing a framework that allows us to write custom queries and select specific columns for the extracts, we could achieve greater flexibility. This innovation would not…
-
SAF-T reporting for European Countries
Description SAF-T (Standard Audit File for Tax) is an international standard for the electronic exchange of reliable accounting data from organizations to a national tax authority or external auditors. The standard is defined by the Organisation for Economic Co-operation and Development (OECD). The file requirements are…
-
OTBI Analysis fetches starting 75001 rows only -- how to increase the limit
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): For one of our customer OTBI analysis is fetching only 75001 rows but for other customer it is fetching 250000 rows by default. Please let me know how to change/control…
-
Additional Information in Document History is not populated for all action codes for Req &PO in OTBI
Problem Description: In OTBI, Additional Information in Document History is not getting populated for all action codes for subject areas Procurement - Requisitions Real Time & Procurement - Purchasing Real Time. It is missing the note/comments for few actions, e.g. Approval & Change History that is fetched in Additional…
