-
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
-
Absence Adjustment value in the database doesn't match the front-end
I am using the Workforce Management - Accrual Real Time subject area, from which I am retrieving the "Front-Loaded Plan - Other Adjustments" field. The report is displaying adjustment values for some employees, even though no adjustment value is currently available for them in the front end. These values appear to be…
-
How do I get Project Cost Adjustments detail and history data in FDI?
Using the standard out of the box subject area(Project Costing), I am unable to get project adjustments data and history. For example, I would like to get all project cost transfers from project A to project B; including data such as transaction numbers to/from, project number to/from, creation date, transaction amount,…
-
How to prevent visualisation filter options from resetting when a data action refilters the canvas?
When a data action is used to pass values using an analytics link and then filter the linked canvas it also appears to reset the checkboxes on visualisations within that canvas which determine if the visualisation should be refined by those canvas filters. It seems the data action causes all visualisations on the linked…
-
How to trigger FDI data pipeline jobs externally?
Is there any way to invoke or trigger FDI data pipeline jobs externally — for example, via a REST API call, or any other integration method — instead of manually initiating the job from within the admin console UI?
-
We configured FDI Security (Users/groups) using Fusion IDCS. User group is not syncing properly in
We created licensed shell role in Fusion. When a user is removed from the shell group in Fusion, it is not reflected in IDCS. This is impacting security in FDI. Have anyone faces this issue while using Fusion IDCS combination ?
-
FDI - Custom schema recommended?
Using a custom schema for ETL and semantic model extensions instead of OAX_USER has been our practice for a while, based on guidance like this: FDI: Replicating access of OAX_USER for a Custom Schema The original blog we used to reference for custom ETL setup is now a 404, and we're finding a few other older articles have…
-
HOW DO WE GET ALERT INFORMATION IF ANY OF THE DATA PIPELINES GOT FAILED OR DISABLED.
Team, In FDI , how can we know if data pipelines got failed or disables or stopped to get the latest data from the source. Do we have any way other than manual monitoring and checks? Regards, Guru
-
AUTO DELETE OF TRANSACTIONAL RECORD IN FDI/FAIDP
Team, We have implemented a solution which needs a customization and created a materalized view on top of ADW. Now, Can we put this object for FDR or Priority refresh schedule? As we asked to manually refresh the object for the latest records updates. do we have a other solution?
-
HOW DO WE GET ALERT INFORMATION IF ANY OF THE DATA PIPELINES GOT FAILED OR DISABLED.
Team, In FDI , how can we know if data pipelines got failed or disables or stopped to get the latest data from the source. Do we have any way other than manual monitoring and checks? Regards, Guru
-
HCM Analytics
The prebuild dashboard in HCM Analytics is showing incorrect "headcount". We are off by 40%. It is showing some person headcount as 0. And it is not matching. However, the "computed headcount" matches. I am not able to figure it out how the head count is calculated. Based on the metrics calculation, - Headcount…
-
AUTO DELETE OF TRANSACTIONAL RECORD IN FDI/FAIDP
Team, We have implemented a solution which needs a customization and created a materalized view on top of ADW. Now, Can we put this object for FDR or Priority refresh schedule? As we asked to manually refresh the object for the latest records updates. do we have a other solution? Regards, Guru
-
AR Aging Dashboard Customization – Multi-Segment Grouping
Hello Team, Our client has requested an AR Aging dashboard. However, the required criteria combine multiple Chart of Accounts segments, including Cost Center, Business Line, Division, LOB, Product, and Receivables Account. Standard FDI Account Groups cannot support this requirement directly, as each account group is based…