-
Top level CEO record drops out when Bottom Up Manager Details are selected in an analysis
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH Is there a…
-
Actual "Span of Control" calculation (using HCM data)?
Would like to know if anyone has created an FDI calculation in "HCM - Workforce Core" subject area that returns true Span of Control (based on actual current manager to direct reportee ratios)? It seems both Oracle delivered Span of Control measures aggregate average ratios over a span of time. We would like to show a true…
-
Data Augmentation option for Fusion source is missing in Data Configurations
HI, We are facing strange issue that the Data augmentation option is not visible in Data Configuration page for Fusion source connector. This seems impacted for most of customers we do support. Please advise if something got changed. Thanks, Dhilip
-
Data Augmentation card is not available under Data configuration.
We noticed today that the data augmentation card isn't available for us anymore. Anyone with the same issue? Regards
-
How to use self Hosted LLM model for FDI AI Assistant
Hi All, Is there a way to use Self Hosted LLM model for FDI AI assistant and other Generative AI features in the FDI platform? If they are not currently available, are they part of future roadmap? if not can someone share idea lab link to propose this? Regards, Siddharth Dang
-
Is there a way to bring advance collection data from fusion to FDI
Advance collection module is not available on FDI. Customer is trying to understand if advance collection data can be ingested into FDI. My understanding is as there is no PVOs available for collection hence hence it can't be done. Need more clarity on this.
-
How PaaS data can be brought into FDI?
I want to know how PaaS data can be brought into FDI. Ex : Some customer related information is on PaaS. I want to bring it in FDI to join it with customer data coming from oracle fusion and then build an overall report.
-
Are OTBI subject areas available in FDI?
Hi, Are the OTBI subject areas available in FDI? Any pointers will be helpful. Thanks.
-
FDI Demo environment
I am looking for an FDI demo environment. Does anyone know if there is any such environment available to customers?
-
Resource material on combining FDI subject area data with other Oracle data
Looking for resource material on best practices when combining FDI subject area data with Oracle data (not in any subject area) to create workbooks. Likely we'll use a query to pull the needed Oracle data points and save them in a table. Is there material we can review on how best to make this combining of data sources…
-
Learning Initiative/Assignment Profile Reporting
Hello, Is it possible or has anyone had success in pulling or creating a BI Publisher report that shows all Active initiatives (Required, Voluntary or Recommended) along with the 'Run As user' field as well. Or is this only available on the front end?
-
Data Actions in FDI data Visualization is getting reset when we try to add column
When we try to add column in data Actions for the existing columns the existing columns are disappearing and we need to add again all the columns and difficult to save the data actions
-
FDI : action & on click on calculated "Without Check-Ins" always redirects to "With Check-Ins" data
have a bar chart visual with: X-axis: Business Unit (from "HCM - Workforce Core" subject area) Y-axis values: Worker with Check-Ins (from "HCM - Check-Ins" subject area) Worker without Check-Ins (calculated: Workforce Core "Worker Count" − Check-Ins "Worker with Check-Ins") I created an Action (Analytics Link) attached to…
-
Anyone had any issues with the 26.R3 update & subject areas dissapearing
Hi, Just done 26.R3 in our test pod, It went in easily enough, added advanced collections etc. Can back after the update completed and we no longer have any subject areas in OAC. Seems the latest update is causing for us a 500 internal server error and we can only access our custom data sources. As we were using FTR which…
-
In subject area: Procurement-Purchasing Real Time is PO line amount column available out of the box
Hi Experts, We are trying to create a report using OTBI to extract the PO line amount - Do we have the column which extracts the PO line amount out of the box available under subject area: Procurement-Purchasing Real Time or do we need to calculate it using the formula - PO Line Amount = Ordered Quantity × Unit Price Any…
-
Prerequisites to Enable the AI Concierge for SME.
Team, I heard we can use the AI assistance for generating the Start model in the SME. So how to enable this feature as our instances are already in 26.R2 version. Using this blog for reference: Guided Star Schema Generation: Bringing AI-Assisted Design to Semantic Model Customization | analytics Regards, Guru
-
Why 'Total duration of Absence(days)' field didn't fetch Life leave & Annual leave half pay data.
Under the Workforce - Absence Management subject area, the Total Duration of Absence (Days) field does not return data for Life Leave and Annual Leave Half Pay. As an alternative, I used the Absence Duration field, which successfully captures all leave types. However, it does not correctly retrieve leave records that span…
-
Fusion Data Intelligence; Where to start?
Hi everyone, I'm a functional consultant. Looking to learn about Fusion Data Intelligence. Where can I start with? I want t learn everything about it. Would be grateful if someone could guide me. Thanks. Regards, Fasahat Ali
-
Issue in Retrieving Data
Hello Experts, I am having issue while working with HCM - Workforce Core in which I am using Person Number and Department Name. The value getting is not in line with the data in my fusion environment. Please guide what I am missing. 26C.
-
GL_Profitability - Dimensions
I have Natural Account Tree Filter and Natural Account Tree Hierarchy , When i filter for Account EE-Account EE Current using Natural Account Tree Filter as work book filter and put Natural Account Tree Hierarchy as Pivot it wont filter for EE-Account EE Current , It shows all the Hierarchy. As per the attached screen shot…
-
Data load monitoring
Hi team, We are unable to gather the data load details at various levels. We did reset and reload; all we observe is in progress status. Unable to predict or view the % completion or understand how many functional areas are complete. The same is for the incremental load
-
Incremental point in time load
We frequently perform P2T refreshes across all lower environments, approximately once every two months. Is it mandatory to run a full load after each refresh to ensure data synchronization, or are there other recommended options to achieve the same result?
-
Adding users to FDI and restricting them.
Hello, I need to add users to FDI. The users are already on Fusion, and all I need is what permissions/Roles/Groups on OCI they need to access only the Home Page of FDI. I also want to know what Roles or Groups limit their access to specific modules (such as ERP, HCM, SCM, CX), creating connections, data flows, etc. If…
-
Local Subject areas related to HCM are missing.
Hello, FDI has been set on TEST environment before full implementation. I try to use Local Subject Areas when creating dataset, but unfortunately, seems like all HCM areas are missing. This is my current view: I have all possible roles, including follwing, assigned to my user in OCI: FAW Functional Administrator FAW…
-
How to handle employees with multiple ethnicities reported in Oracle
I am building a Diversity & Headcount dashboard and discovered 48 employees have multiple ethnicity records (47 with 2 records, 1 with 4 records), causing a discrepancy between my headcount totals depending on which dimensions are included. Issue: Headcount is only inflated when Gender and Ethnicity are used together.…
-
What is the learning item type for Redwood Courses?
I am creating a BIP report that uses Learning Item Type LOV. In this LOV, i need help in the SQL query so it can list all the learning item types including the redwood courses.
-
How can get the group, and application roles assigned to each user
-
Assistance Required to Verify Data Load in FDI for connecting the BI Publisher report
The BI Publisher dataset DW_BIP_X_VACANT_POSITION_BIP has been successfully activated and deployed through a Data Config Bundle in FDI. Semantic Model publish completed successfully, however the augmentation still shows Semantic Model Status = Not Available. Could anyone please confirm how this dataset should be registered…
-
How to combine multiple pivot into one pivot in oracle fdi
How to combine multiple pivots into one pivot in oracle fdi workbook..
-
PVO for Trade Operations
Looking for PVO to create data augmentation for the following fusion tables. CML_TRADE_OPERATION_CHARGES CML_TROP_CHARGE_PO_SCHEDULES Thanks, Deepthi