-
Generate AI Agent - Fusion AI Data Platform – Derived Data Lineage Workbook for Fusion HCM Analytics
Hi Team, One of our colleague build an excellent workbook to give us OOTB Data Lineage on HcM Analytics. To Leverage AI and extend the new Oracle Fusion AI Data Platform as many of customers extend the OOTB and customise according to their business needs, if can we build AI agent which extract likewise data when we install…
-
FDI DW Refresh table level stats
In the recent FDI release Oracle introduced three new tables (FDI_REFRESH_SUMMARY, FDI_REFRESH_STAGES, FDI_REFRESH_FACTORS) which helps to find the details of data refresh in the warehouse, however we would like to request to see the full DW Table refresh stats with start and end time of each DW Table with refresh ID for…
-
Add Time dimension for Seniority Subject Area
We would like to see a Time dimension added to FDI HCM - Worker Seniority subject area so that we can analyze the average tenure over time. We are currently unable to add a time slicer for year, quarter and/or month in this subject area in FDI. This would be helpful to track the change of tenure over time.
-
Enable Independent Forecasting for Multiple Items in a Single Table
Currently, when used in a table the FORECAST function aggregates all items when more than one appears in the table. We need the ability to generate independent forecasts for each item simultaneously within the same table. The current functionality is preventing us from producing item-level forecasts in a scalable way and…
-
Add a toggle to display dummy data in a DV report
Currently, Oracle DV reports always display live data, which can make it challenging to demo reports without exposing confidential or sensitive information. It would be extremely helpful to have an option to toggle between real data and dummy/sample data within a DV report. When presenting dashboards to external…
-
Include Enterprise Onboarding and Enterprise Onboarding Step Categories in FDI – HCM Journeys Subjec
🚨 Product Fusion Data Intelligence (FDI) Module HCM – Journeys Problem Statement Currently, the Journey categories Enterprise Onboarding (ORA_ONB_ENT_ONBOARDING) and Enterprise Onboarding Step (ORA_ONB_ENT_ONBOARDING_STEP) are not available in the FDI HCM – Journeys subject area. Although these categories exist in Fusion…
-
[FDI] Purchase Order details are not visible when using the Enterprise Contract Subject Area
At the moment, our team has noticed inconsistencies on the contracts data. Some contracts are not able to pull through Purchase Order tagged to them even though upon looking into the UI/front end, the Purchase Order has a designated master contract number. Issue is happening even for newly raised POs (PR to PO) as well as…
-
Add & Convert Date columns to Timestamp in Procurement - Purchase Orders Subject area
Add timestamp to the "PO Creation Date", "PO Submitted Date" & "PO Approved Date" in the Procurement - Purchase Orders Subject area. This will help the business in document history? The time stamp helps in calculating how long orders are taking to process. The timestamp is available in Fusion, it needs to be enabled in FDI…
-
FDI: Draft Sales Orders availability in Sales Order Header and Fulfillment Facts
Currently Draft Sales Orders (Orders which are in Credit Review Pending status) are only available in Draft Sales Order fact in FDI and not available in Sales Order Header fact in FDI. Hence if a user needs to look at all Orders, it has to be created using a Union report / Union query using 2 OOTB subject areas. If the…
-
Read Only Access for the OAX Console in FDI
Hello Team, Our company would like to suggest the creation of read-only access for the OAX Console/Admin Console in FDI. We would like to have some monitoring capabilities as users who are not service administrators in Production. Users who are more familiar with FDI are currently not able to check pipeline settings,…
-
Include Invoice Line details in [Financials - AP Invoices] subject area in FAW
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): KPN B.V. Description (Required): When using the [Financials - AP Invoices] subject area to built a report, it is not possible to select Line Details for Analysis. Use Case and Business Need…
-
New flag field which uses the Federal Ethnicity Code to classify race and ethnicity categories
The new Federal Ethnicity Code flag would collapse racial and demographic information into one line rather than multiple lines per individual. Following the IPEDS reporting requirements, which is what higher education institutions must use, it categorizes individuals into the five categories for race and follows special…
-
Provide Attribute Level configuration to Configurable Account Analysis (CAA)
Problem Description: Currently we can configure Configurable Account Analysis (CAA) at subledger level only. But companies like Lowe's use Fusion Accounting Hub, where we use custom-subledgers. Because the journals are created external to ERP, we create Lowe's-journal-id, which is differen't than Fusion-journal-id. So, in…
-
Partitioning of Configurable Account Analysis
Problem Description: Currently Lowe's Configurable Account Analysis (CAA) table contain over 900 million rows just 8 months after go-live. Our Daily Incremental and Frequent Data Refreshes are running longer than the run-times when compared during go-live. As per CEAL team recommendation, we reduced the initial extract…
-
Add "Select All" Checkboxes In Security Console for Application Roles
When adding Application Roles to Groups in the Security Console, it would be very convenient to have a "Select All" option. This applies to the Application Roles already attributed to the Group as well as when Adding a Mapping.
-
Dynamic Triggering of FDI Datawarehouse Incremental Refresh
Description: Currently, the options for setting up the FDI Datawarehouse Incremental Refresh are limited to selecting the frequency and the specific time when the refresh pipelines are triggered. It would be beneficial to enhance the system by allowing the FDI pipelines to be triggered based on the completion of a job…
-
Monitor progress of FDI pipeline run directly in the FDI Console
Typically ETL tools allow you monitor the progress of a pipeline. Provide a UI that gives you direct insight into the job running, completed, on hold, in progress etc
-
Project Execution Management - Operational Milestones in FDI
My company is a projects-based company. We are currently implementing Oracle Fusion PPM along with other Oracle Fusion applications. Additionally, we are implementing FDI. Some of our projects based KPIs involves tracking completion of operational milestones also known as non-transactional milestones/tasks. Currently I…
-
Increase threshold of visible Application Roles applied to a Group
There appears to be a threshold of 52 visible Application Roles on a single Group. I know that there are additional Application Roles applied and they can be found by filtering by Duty Role or Data Role, but even those appear to have a limit on the amount of roles that are visible. This is troublesome because it makes it…
-
Enhancement Request: Restrict BI Publisher Access for Author Role in OAC FDI
Currently, the Author role in OAC FDI is granted default access to create and manage BI Publisher reports, with no existing configuration available to disable this specific capability. We request that Oracle updates the FDI product code or security framework to allow for the restriction of BI Publisher access for users…
-
FDI Data Pipeline start using a public API call
We need a way to be able to programmatically trigger an FDI data pipeline using a public API call. We have some backend pre-processing work to complete before the FDI data pipeline starts. Fixing the daily incremental load at a specific time of the day does not work for us. We are expecting an API interface or a job…
-
Add Purchase Order Number to AP - Invoices Subject Area
In Oracle Cloud, Purchase Orders are an item on the Line Details of an Invoice in Payables. Our business users would benefit from having the PO Number added to the AP - Invoices subject area as it would provide better clarity as to what is on the Invoice lines and which PO was created.
-
Mandatory Filters on Report
Looking for a way to have some parameters/filters to be mandatory (with single select/multi select option) on the FDI/FAW reports to avoid the possibility of running open ended query causing performance issues. I am not sure if there is such feature available on FDI/FAW. If you, please advise. Regards, Abhishek
-
Add "EEO-1 Category" and other job legislative fields to Job Folder of Subject Areas
In reviewing subject areas (ex: HCM - Workforce Core) in the common > job folder the job legislative fields are not available to report on. We specifically would like to include the US legislative EEO-1 category field that is available in Oracle Fusion but is NOT available in Fusion Analytics subject areas. In Fusion,…
-
Add Management Level Field to FDI HCM Subject Areas
In HCM Subject areas under Common > Job, the management level field is not included. We would like to see this field included as it is a common attribute that we group by (similar to job function, level, job family that are already included in the subject areas).
-
REST API for FDI Fusion Data Intelligence
We currently do not have the option to export a list of groups and the users associated with them. We also tried using the Audit history report, but it does not provide the entire list of users and their associated groups. Could you please enable the ability to export a list of users along with their group associations?…
-
Adding HCM fields to FDI
Our customer has requested us to add the following HCM fields to the FDI semantic model: Contract Level Contract Type Qualification Part Time information Worker number We have found a workaround by importing the fields through a combination of data augmentations / OAC data flows and linking the new information through the…
-
Need ability to view and restore analysis from snapshot without the Administrator help
Unable to find a specific analysis in the catalog. Attempted searching by full and partial name as well as by folder location. The search is not case-sensitive and verified that User has permission to view the object. Despite this, the item still does not appear in the search results. It might be deleted by mistake. Need…
-
FDI: Increase the number of IP Addresses allowed to be added to ACL directly in FDIs ADW
To make the product more self-service, please update the ACL in FDIs ADW to allow more than 19 IP Addresses to be added. When new secure browsers are being implemented, if these IPs do not exist in the allow list then many users will lose access to this environment.
-
Data Security on OAC Data Sets
It is currently not possible to apply data security on data sets. Users can either access everything or nothing. We operate in a multi-organisation/entity environment with Areas of Responsibility applied in Fusion and FDI to segregate data. We have a number of connections via OAC to 3rd party databases which we create…
