-
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…
-
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,…
-
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…
-
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…
-
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…
-
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 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…
-
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…
-
Need accrual balance/projected accrual balance without running accrual process in BIP Report
Organization Name National Oilwell Varco LP (Oracle Cloud) Description Business Need - We need employee's accrual projection balance without running accrual calculation schedule process. To make sure there is no stored procedure/ function available to achieve this we have raised SR 3-24322499035 : ER-Need accrual…
-
Oracle Fusion OTBI (Transactional BI) and BI Publisher - Integrated Git Version Control
Currently, Oracle Fusion OTBI (Transactional BI) and BI Publisher lack a native version control system or DevOps pipeline integration. To promote analytics content (reports, dashboards, data models) across environments (Dev → Test → Prod), customers must rely on manual export/import of .catalog files. This leads to:…
-
Upload BIP .catalog object via Web Services
Organization Name The Hackett Group Description We need to enhance the CatalogService to allow the upload of .catalog objects. Currently, the Web Service supports the creation of objects (.xdm, .xdo, xsb, .xss), which need to be encoded in base64 before uploading to the BI catalog. However, enabling the upload of the…
-
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…
-
SmartView - Enable simultaneous connections to multiple domains
Currently it is only possible to connect SmartView to a single domain. This enables EPM users to connect to all their applications via one connection however if you wish to view data or reports across domains then this is not currently possible. As SmartView can connect to ERP, EPM and OAC, all of which sit in separate…
-
Add BICC extract job id in MANIFEST.MF filename
When submitting multiple BICC extract offerings in parallel via the ESSWebService (submitRequest), each completed job produces a MANIFEST.MF file in UCM under the OBIAImport security group. However, there is no reliable way to associate a specific MANIFEST.MF file with its corresponding request. Business Impact: When…
-
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…
-
Source Asset number to be added in Sales -CRM subject area
We created OTBI report From Sales -CRM Asset subject area but the asset number field seen is only backend field only not matching with the Fusion UI. It is misleading .So found that source_asset_number column from zca_assets is the actual column matching with Fusion UI and not available in the subject area .Could you…
-
Flag to indicate whether a receipt has an attachment in OTBI
Hello, We have developed a report using the subject area "Costing - Receipt Accounting Real Time". The report is almost complete, but a requirement has arisen to add a flag indicating whether or not the receipt has an attachment. I haven't found a column or formula in OTBI that helps me do this. Does anyone have a possible…
