-
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…
-
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?
-
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…
-
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…
-
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…
-
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…
-
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 →…
-
Ability to publish OTBI/BIP reports directly to SharePoint
I have seen a few ideas around publishing reports to Sharepoint, but documentation references sharepoint 2007 not the 365 Sharepoint that most companies are using. Can we do this with Sharepoint online/365? If so how? IF not enhancement logged.
-
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…
-
Enable Write Back Privilege in Cloud OTBI
Description There is an option of enabling "Write Back" in Column Attribute, which would potentially allow end-users write back to database. Use Case and Business Need Enabling “Write Back” Function in Cloud OTBI Dashboard. Which would potentially allow end-users write back to database. once they found out any input…
-
Add Attachments to 'Receivables- Standard Receipts Application Detail Real Time' subject area.
Attachments need to be added to the “Receivables - Standard Receipts Application Detail Real Time” subject area. Attachments are part of the receipt header information. Since not all receipts contain attachments, having this attribute available will help users identify which receipts have attachments and which do not,…
-
Customize standard Payables -> Invoices page to add additional content (OTBI Reports)
Organization Name Infosys Description Ability to customize standard Payables -> Invoices page Currently Oracle Fusion does not provide an option to edit the landing page for (Payables - Invoices). Use Case and Business Need Currently we have three Infolets on this page (Recents, Holds, Prepaid). Our Business is looking for…
-
SR 3-32543631091 : CCC - Unable View other project Managers detailed info in OTBI Subject Area
Problem Summary --------------------------------------------------- Unable View other project Managers detailed information in OTBI Subject Area Problem Description --------------------------------------------------- Unable View other project Managers detailed information in OTBI Subject Area "Project Costing - Actual Cost…
-
Improvement request to generate explain plan for XLA table
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):Accenture Description (Required):I want you to solve the problem that the explain plan cannot be obtained due to the following document restrictions. Could Not Generate Explain Plan for XLA…
-
Issue with Nationality Headcount in Dashboard
We are currently facing an issue while retrieving the nationality headcount for a dashboard that uses two subject areas: Worker Assignment Real Time and Person Real Time. When applying dashboard prompts such as Legal Employer, Business Unit, etc., the headcount results are not returned correctly. However, the overall…
-
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 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…
-
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…
-
Moving the report folder from one folder to another folder in BI Reports in Oracle ERP.
Moving the report folder from one folder to another folder in BI Reports in Oracle ERP. We would like system to pop up one message or dialogue box "Do you want to continue to move this folder" Yes or No.
-
Consolidated Error Log File for BIP Report with Bursting as FTP and Mail as delivery channels
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): KPMG India Description (Required): Please note, we have the BI Reports where the output of the reports will create the files in FTP Server and also sent email for each employee using FTP/EMAIL…
-
Ability to allow Non-BI Admin Users to view History of BI Reports submitted by Other Users
Organization Name TTX Company Description We have a requirement where a specific group of users should be granted access to a set of BI reports and the users should be able to view history of these reports including the runs submitted by other users. Using Custom Role/Permissions at BI Catalog we are able to control access…
-
Requirement for Custom BI Report to Extract Bursting Schedule Email Details
We have a requirement to develop a custom BI report to extract bursting schedule details. However, we are unable to retrieve email-related information such as From, To, CC, Subject, email content (body), and attachment details from the available tables. This issue is impacting our ability to complete the Report Job History…
-
Approver Comments Column Missing in Payables Invoices - Transactions Real Time SA
Description Hi We have a requirement to Build a Custom OTBI analysis using Payables Invoices - Transactions Real Time SA. We are required to show Invoice approval Info.For this we need to capture Approver Comments Column which is currently not present in Payables Invoices - Transactions Real Time Subject Area. Use Case and…
-
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$},…
-
Restrict Line Managers access to report on direct reports DOB and Address info
Currently our Line Managers having access to ran reports can pull their direct reports Date of Birth and Address information. We were able to restrict our Line Managers from viewing their direct reports Home Addresses and Date of Birth information. But we can't restrict them from pulling this data in reports. We opened an…
-
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.
-
Receipt "Notes" field in Costing - Receipt Accounting Real Time OTBI subject area
Customer wants to use the "Notes" field in Costing - Receipt Accounting Real Time OTBI subject area This would really benefit being able to match-up receipts to invoices (or just understand why someone has receipts for a certain amount in free-text). I have already Raised an Oracle SR and they suggest that " This note…
-
SmartView Export for OTBI & OAC
When using the SmartView Oracle BI EE extension, you can open any OTBI and OAC Classic dashboard. It would be good to have the option to be able to export a dashboard in Query Ready Mode, the same as you can in FRC so that users can start in the web view and seamlessly move to Excel. This would also enable authors to share…
