-
AR_RECEIPT Deeplink Parameters
Description The AR_RECEIPT deeplink, used to drill down to the Manage Receipts Task, can be used through Receipt Number parameter (objKey=receiptNumber). Using this, i will not have unique record, because i could have more receipts with the same receiptNumber. So i think that it would be a great idea to implement the…
-
BIP date function for First Day of Previous Month
We have a report that we run on the first day of each month, and enter the Start Date and End Date parameters for the dates of the previous month. We want to schedule the report to run on the first day of each month. We can use a date function as the default value for the parameters, but our choices are {$SYSDATE$},…
-
Ability to navigate to Fusion application's Home page from Analytics page
Ability to navigate to Fusion application's Home page from Analytics page. this is required as currently there is no any button available on reports and Analytics i.e. BI publisher page which can navigate user back to Fusion application's Home page.
-
Left Outer Join in OTBI
Hi, There are scenarios in OTBI where we want to all the details of Department which are not mapped to any of the person at Assignment level. so obviously it is not getting picked by the subject area. Logical SQL can be built but the problem is maintainability of this custom SQL. Better Left Outer join can be introduced at…
-
Oracle Reports Output into Google Sheets
The capability to add a feature to where report outputs (BIP, OTBI, etc.) can go directly into Google Sheets instead of Excel that then can be uploaded into Google Drive.
-
To remove the CR/LF line from the last record of data produced by eText template report in Oracle Fu
Organization Name South Asia Gateway Terminals (Pvt) Ltd. Description Remove the extra CR/LF line from the last record of the file produced by eText template report in Oracle Fusion R13. Use Case and Business Need This etext templete mainly is used to generate .txt files to be uploaded to third party sites such as banks.…
-
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…
-
OTBI Scheduled Report to FTP Folder
Description Currently we get the reports from OTBI via email. But it will be good to have the agent send the output directly to our FTP/SFTP server. Use Case and Business Need Hi, We would like to have the report data out directly to our FTP/SFTP so that it will be easy for us automate the data to load in our target…
-
Disable Drag and Drop for Report Folders
Organization Name American Express Description We have had issues with permissions when a report folder is accidently moved by dragging and dropping to another folder. When the folder is moved back it retains the permissions from the place it was moved to. This allows users to see information that they should not have…
-
Ability to extract all ESS job and job set name via Manage Enterprise Scheduler Job for HCM/Fin/CRM
Organization Name Department of Treasury and Finance Description Hi Team, Per Oracle Fusion product limitation, The Jobset and Job Definitions are not stored in any DB tables to query. They are xml documents stored in MDS DB which cannot be queried using SQL. Hence at least Oracle should allow end user to extract all the…
-
OTBI Export to Excel or CSV limitation
Organization Name Capgemini Description Hi Team, The OTBI Report export to excel or csv limited to 25k and 75k rows.This Limit is very small for business requirements.It's better to provide some configuration to increase this limitation in OTBI. You can look at this SR (SR 3-21271633161 : OTBI Report Export Limitation) for…
-
Enable multi selection parameters in ESS job
Currently, in fusion Data model has an option to choose multiple values for a parameter however the ESS job doesnt have this option. As this is a very basic requirement, Oracle has to bring this solution soon,
-
New Subject Area - Financials Chart of Accounts
Currently, the only subject area that has the full COA hierarchies is GL Balances. All other subject areas go direct from Top Parent to Child. This means the only way to be able to report other financial transactions, whether general or sub ledger, is to bring in the GL Balances subject area which there is a possibility…
-
Audit Trails for Reports/Data Model
Currently, user having BI Data modeler access having ability to create and run SQL queries without any data restriction. It will be helpful if we have an audit trail that who run which reports/queries.
-
Restricting the Data in reports and analytics while creating Data Model
Currently any user having access to BIP developer 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. User while creating a data model can see any HCM data like (Payroll details, DOB, SSN, etc.) as well as…
-
Ability to view output of others ESS jobs without BI Administrator role
Organization Name Rotary Description We have followed the detailed instructions in: How to View the Output of an ESS Jobs Submitted By Another User Based on Role? ( Doc ID 1980772.1 ) * We created a condition that allows supervisors to view subordinates requests. * Supervisors can view output/logs/cancel jobs... * This…
-
Enable Mailto link in Action Links with tokenised email address
I need to be able to create an action link with a mailto:url that has a tokenised email address. The use case is that on an invoice holds report, I want to click the requester name and it create an email, pre-populated with the details of the requisition and/or invoice. Whilst it is possible to tokenise some of this, when…
-
Create OTBI Analysis from BIP Data Model
In many cases in OTBI, Analysis cannot be achieved because multiple subject areas are required. This leads to building BIP reports which do not have as rich a user experience as OTBI Analysis. This is a particular challenge where pillars sit across multiple subject areas, for example receivables where data is needed from…
-
New Feature - "Recently used Filters/Objects" in OTBI Analysis
Adding a saved filter to an OTBI analysis currently requires the user to navigate to the Catalog section on the left bar of the analysis. While it is simple to add a filter saved in a folder directly under Shared Folders/Custom, it takes a lot of clicks to get to a filter saved under a child folder many levels below…
-
Ability to Report on All ORC Recruiting Campaigns in OTBI
Request for the ability to add a new data privilege that allows the ability to report on all Recruiting Campaigns in OTBI (Recruiting - Sourcing Real Time subject area). Confirmed through Oracle documentation and product engineer that this is currently restricted to only the owner of the campaign - not even users listed as…
-
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…
-
Improve Dashboards Listing in OTBI/OAC Classic
Currently, when custom dashboards are created, they need to be placed in Shared Folders/Custom/Dashboards to show in the dashboards listing. This can then only group the dashboards in the dropdown in a single collapsible heading. Where there are a limited number of custom dashboards that is fine but many organisations have…
-
Fetching Personal and work email in same OTBI report
Description Fetching Personal and work email in same OTBI report Use Case and Business Need Hi Experts, How to fetch both personal email and work email in a single OTBI/Analysis report. Is it feasible and how we have to do that? Original Idea Number: 644cf2ddb7
-
Instance level NLS date format settings
Is there any supported way at the instance level to ensure that the Oracle database always returns English month abbreviations (e.g., “JAN”) when using the format mask 'MON' in TO_CHAR(date, 'MON'), without using NLS_DATE_LANGUAGE in the function call?
-
ESS Job Incompatibility Self service features (similar to what we have at EBS Concurrent Processing)
"We need stronger customer-controlled workload management capabilities within ESS. When will Oracle deliver self-service features to manage job incompatibility rules, concurrency controls, and workload-throttling policies that allow us to proactively prevent excessive ESS job concurrent activity from impacting pod…
-
Auto scaling for ESS job concurrency increase
To mitigate pod concurrency-related performance issues, we have significantly reduced ESS job frequencies, are redesigning our ETL processes, and continue to tune SQL. However, cloud platforms are fundamentally expected to provide elastic scalability. What architectural limitations prevent Oracle from dynamically scaling…
-
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…
-
Environment Variable
When creating deep links to the fusion source, you have do hard-code the environment URL as part of the link. This means that when you migrate report content, you have to manually change every link. This can lead to errors and invalidate testing. This is not too much of an issue for individual report however when…
-
Ability to report on Roles &Permissions associated with BIP Catalog Folders
Description Hi All Currently we are not able to report on the roles & permission associated with each of the BIP catalog folders. We need to manually check the permission of the folder. Any discrepancy or issue during patch/update, it is really hard to identify the changes. Would be good if end customers have access to…
-
OTBI Action Link to BI Publisher Report – Migration Issue (Page Not Found)
Hi Team, In Oracle Transactional Business Intelligence dashboard, I am using Action Link to open a Oracle Analytics Publisher report (.xdo). Current full URL works: https://<host>/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=... Issue: I want to remove hardcoded host for migration (DEV → TEST →…
