-
How to join Talent Acquisition Logical Star with Age Band Dimensions in FDI?
I am working with Fusion Data Intelligence (FDI) and I need to create a report in Talent Acquisition that includes Age Band distribution for candidates/applicants. I am looking for the best way to link the Logical Star for Talent Acquisition (specifically around Job Applications/Candidates) with the correct dimension for…
-
How to Dynamically filter Data in FDI/FAIDP 26R1?
I am not getting how to filter data using variable in semantic layer extension → Security. There is no step for adding data security available any more. Now I know Custom Security Context is an option but that is more of Hardcoded Solution So, Want to understand how is it possible now ?
-
FDI 26ai ADW: GRANT SELECT ON SCHEMA OAX$DW to a custom database user?
Is it possible to grant select any table on schema OAX$DW to a custom database user within a 26ai ADW? If so, please clarify any pre-requisite steps such as ADMIN or OAX_USER needing specific privileges before trying to run the grant statement. Thanks & Regards, Angel
-
PPM-Project Budget to derive Budget Burdened Cost
Hi Team, I am using this subject area to derive project, along with project start and end dates and budget burdened cost This works fine for current baseline budget cost. However, when I change the date parameters the cost and dates doesn't change. Attached screenshot for reference, For example : Project number : RE0608,…
-
Standalone security and user access administration in FDI untethered from Oracle Fusion
Is it possible to administer security and user access in FDI completely standalone and not inherited through Oracle Fusion even though all transactional data for reporting within FDI needs to come from Oracle Fusion?
-
PPM-Project Budget to derive Budget Burdened Cost
Hi Team, I am using this subject area to derive project, along with project start and end dates and budget burdened cost This works fine for current baseline budget cost. However, when I change the date parameters the cost and dates doesn't change. Attached screenshot for reference, For example : Project number : RE0608,…
-
Regarding - Receivables Aging by Accounting Date
With 26R1, a new Preview feature is provided related to AR aging. There is no details or no documentation reference under: Features Available for Preview Appreciate if the product team provide appropriate level of (Techno-functional) details on "Receivables Aging by Accounting Date". thanks,
-
How to change the display name of filters on a workbook?
I believe that this feature was available in the Classic version of FDI, but in the current Data Visualizer, I do not see a way to rename the filters at the top of a workbook. Is this functionality available? If not, this seems like something that would be a useful addition to the tool.
-
email trigger is not working in ai agent studio
We have Microsoft email id and tenancy id and client id and secret but the email is not trigger how i can configure the email trigger
-
Oracle Fusion AI Agent Studio - Email Workflow Trigger Not Working
Within Oracle Fusion AI Agent Studio the email triggering feature is not working. Following this guide: https://blogs.oracle.com/fusioncoe/email-trigger-in-workflow-agents, the credential is configured as a trigger on an agent. The agent team has been published. I have checked the scheduled jobs logs, there is nothing…
-
Read-Only Access for FDI Console - Workarounds or ER?
We require a way for our support team to monitor pipeline statuses and system health in the PROD FDI Console without the risk of making changes. Since a Read-Only Administrator role does not currently exist, is there an undocumented workaround, or can this be logged as an Enhancement Request for future roadmap…
-
FDI Measures
Good afternoon. We are testing for a go-live of FDI (Fusion AI Data Platform) for our Oracle HCM data reporting. Is there a reference document that describes how the FDI delivered measures are calculated? In testing we want to be able to cross check what FDI shows against similar reports in the same environment. For…
-
Getting error while logging into FDI instance
Hi, What might cause some users to receive an “Insufficient permissions” error when signing in to our SSO‑enabled FDI instance provisioned from Fusion? regards,
-
How can we Migrate FDI from Default Identity Domain to different Identity Domain?
FDI is initially provisioned with default identity domain and various development was done in FDI along with few custom schema(s) in the underlying ADW. Can someone point or suggest the recommended approach to point the FDI (Default Identity Domain) to FDI (Test Identity Domain) and subsequently promote to Prod?
-
Moved: Avoid fetching Active employee got Terminated when fetching Inactive Employee Data
This discussion has been moved.
-
Central Reports inventory and run time dashboard in FDI for OAC ,OTBI & Fusion Data
Team - Any Ideas appreciated to acheive the functionality of creating central inventory repository which covers the OAC,FDI & Fusion data in single dashboard. Thanks in advance.
-
Prerequisites for Migrate Essbase 21c to EPM Cloud PBCS
Hello, I would like to know if anyone migrated/Lift&Shift Essbase21c Application to EPM Cloud application and what are the prereqsuites have taken as part of this activity? Appreciate for right answer Thanks, Sreenu
-
Single view of reports created inside OAC & Fusion
Hi Team - I'm looking for is there any out of box subject area which provides the list of reports created in OAC with run time and no of runs. Appreciate any inputs to achive the same. Thanks in advance.
-
Gender Pay Gap
We are trying to setup some dashboard to show Gender Pay Gap. We think one of the best option we have is to upload a python script in order to pre calculate imported data. Here are some examplese: https://docs.oracle.com/en-us/iaas/Content/data-science/using/models-practices.htm We didn't understand yet what should be the…
-
Reporting Project Burdened Cost by Bill-To Customer Account in Fusion AI Data Platform
Hi All, I have a requirement to show project revenue minus project burdened costs per bill-to customer account in Fusion AI Data Platform. I see there is a built-in relationship between revenue and bill-to customer account via the Bill Plan ID. What I do not see is how to relate the cost to the bill-to customer account. We…
-
FTE Gain and Loss Validation using OTBI
Has anyone figured out the query/report using OTBI for the validation of these 2 key metrics from the Gains and Losses subject area in FAIDP/FDI? Any help would be highly appreciated.
-
What is best approach for pulling source systems files into AHCS using FDI ADW database
we are planning to dump different source files into ADW for processing the same files into AHCS,what is best possible approach of achieving this using Oracle FDI, OIC/ODI, which one would be cost efficientefficient considering FDI is in place.
-
Errors when using custom subject area
Hi, i am getting these errors when using a custom subject area
-
Integrated Oracle FDI with Fusion App - SSO
How is Oracle FDI which is created in the same identity domain as Fusion ERP utilize SSO from ERP ? I have read multiple Oracle documentations where it says FDI automatically inherits the existing SSO configuration from ERP, but want to understand how is this happening behind the scenes? We haven't received IAM Upgrade yet…
-
How to restrict ledgers, BUs of interest for daily refresh
Hi, We use FDI Finance analytics, and have multiple ledgers, legal entities, BUs. Not all businesses use analytics. Is there a way to select only some ledgers or BUs for daily refresh. As this will reduce data refresh time, also, improve performance.
-
When we use a column from "Organization Hierarchy", the intended number of records are NOT returned
Problem Summary: When we use a column from "Organization Hierarchy", the intended number of records are NOT returned Problem Description: We are developing a report in which we are using the subject area " "Workforce Management - Worker Assignment Real Time" in one of our OTBI reports. When we don't use the folder…
-
How do you Validate Data in Inventory Receipts Subject Area
We have a requirement to validate the Receipt Line Count metric on SCM - Inventory Receipts Subject Area of FDI against OTBI. As we do not have a pre-built data validation for this Subject Area, We wanted to understand a way to create a validation report on OTBI for this. As per the Metric Calculation logic provided by…
-
How to Validate OOTB metric Item Based Purchases %
We have a requirement to validate the OOTB metric Item Based Purchases % available on Procurement - Spend subject area. As per metric calculation sheet for Procurement, following is the formula : Filter(Count Distinct(Purchase Order Line ID) Using Is Purchase Order Matched Flag = 'Y' and Inventory Item ID > 0) / "Purchase…
-
How to use OTBI subject areas in Oracle FDI?
Hi, I am trying to pull/use OTBI subject areas in Oracle FDI. Is there a way to do so? Thanks, Ruvina
-
Oracle FDI Semantic Model Status Not available after data augmentation with bi publisher
Hi, is it correct that after performing data augmentation with a report from BI Publisher, the augmentation has the "Semantic Model Status" set to "Not Available"? And if it needs to be set to "Available", how can this be done?
