-
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…
-
Add support to enable BI Broker Mode in create/update BICC job Rest API
All the jobs created via BICC Rest API always have BI Broker Mode option set as disabled and there is no option to set the extract mode in the API right now. Add support to enable Bi Broker Mode via API. Ref -…
-
OTBI Subject Area for Agents and it's config
There is no subject area or out‑of‑the‑box report to view OTBI agents, making it extremely difficult to locate and manage them—especially when hundreds of agents are created across multiple subfolders under Custom. Additionally, if an agent is configured to “Run As” a user who has left the organization, it fails silently…
-
BI Report ESS Job Does not support parameter with Dependent LOV
Organization Name Hutchison International Limited Description On BI Report parameter list of values available to user can be setup base on another report parameter user selected. However, when we define a ESS Job to run the BI Report, parameter on ESS Job does not support List of value from custom SQL that depend on value…
-
Enable Bursting and Scheduled Personalized Report Delivery within Oracle OTBI
Currently, Oracle OTBI (Oracle Transactional Business Intelligence) does not provide bursting or personalized report distribution capabilities. Reports and dashboards created in OTBI can be viewed interactively or scheduled for static delivery to a list of users, but the same report output is sent to all recipients. This…
-
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…
-
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…
-
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…
-
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…
