-
FDI supported Datasources- EPM cloud FCCS
There is a connector available to connect Oracle EPM Cloud (FCCS) in FDI and create data augmentation. As per documentation, an integration file needs to be created in EPM which will be loaded by connecting FDI to EPM. Since this file will be containing descriptive and measure columns , what type of augmentation should be…
-
Use Expression as Default for "Normal" String Filter
I would like to have the default value in a filter be based on an expression while still being able to use the selectable values from a normal string filter. To explain in more detail… The Expression We want to get the current accounting period as of one day ago as the default value for Fiscal Period (e.g., 2/1/2025 would…
-
Sticky filters too sticky? Or not sticking properly?
Sticky filtering is a great new feature, however, sometimes the sticky filters will remember too much. If I filter a department then remove the filter than filter a separate entity and leave it, then when i re-enter the report it will remember all the filters i filtered to, even the ones I removed the filter from after.…
-
Multi-Select Values in Parameter to show in table
Hi, Is it possible to show multiple rows in the table based on selected values from the Row Selector? Currently though I selected 2 rows, only the first value appears on the table.
-
Is there a solution in FDI to see Ranking of Applicants within Requisition using best fit candidate
we do see the Candidate Recommendation but once candidates are either added or they have applied to a requisition, we are not able to see any ranking of Applicants within Requisition to perform initial screening. If not in HCM, is there a solution in FDI for the same or if anyone has implemented any such solution. Looking…
-
Create a column that show/filter only the MAX Date of Date field on each month
Hi, I just want to request your help on how can I create a column that show/filter only the MAX Date of Date field on each month "SCV - Material Sourcing Impact - Current"."Time"."Date" So basically, if possible I can filter only those MAX Date per Month, for example 2/24/2025 3/31/2025 4/21/2025 and so on.. will appear…
-
How to aggregate this table?
I have this table: Column C counts 1 when A = B and all these 3 are custom metrics. Is there a way to make an aggregate view with only columns D, E and C? If we make a pivot or modify col C metric with "SUM" all the values are the same for each D or E value
-
Combining 3 columns and get unique values out of it
Hi, I am trying to combine 3 attributes named S1,S2,S3 which has the person number and then need to find unique values out of it. Can help please help me understand how can we do this in Oracle FDI/FAW?
-
Scheduling permissions
I have an admin role in FDI but still I'm unable to schedule any report. Why so? I think that it might be related to the block I have on Advanced System Settings I really don't understand
-
Stardard FDI controls
Can someone help me understanding what kind of data control can be done in Oracle FDI by standard?
-
Primary and Secondary Ledger links in Oracle Fusion
Hi Experts - Looking for your suggestions and inputs to get the link between Primary and Secondary Ledger subledger links in FDI. Thanks in advance.
-
What is the PVO we can use that contains the table XLE_ETB_PROFILES please ?
Hi, What is the PVO we can use that contains the table XLE_ETB_PROFILES please ? Thanks
-
XLE_ETB_PROFILES PVO needed
Hi, We are trying to create a view with the legal entities, establishments, etc and registration number. We managed to join the client-provided table augmented #1 (FscmTopModelAM.FinExtractAM.XIBiccExtractAM.RegistrationExtractPVO) where we have the reigistration number, with another augmented table #2…
-
Why BU is a mandatory parameter in ESS job of Uninvoiced Receipts Accrual Report
We have a business requirement to run Uninvoiced Receipts Accrual Report for all the BUs. But using the ESS job we can select only one BU at a time. Tried to execute or schedule the report from catalog, but both Open and Schedule options are disabled for this report. We also created copy of the report, but the same…
-
Join registration number with organization hierarchy folder
Hi, I've been struggling to add the registration number in FDI. How can I join this table with either the hierarchy org folder or the common folder please ? What are the primary keys that can be used ? Is is straight forward ? Regards, Lauriane
-
Is there a way to copy production to test?
Is there such thing as a P2T for FDI/FA that copies the workbooks and datasets in production to the test environment? We want to refresh our test environment.
-
Problems in "Reload Data" on a data set
I created a dataset with a report built from Fusion BI Publisher, however, the report is not updating in real time. When I try to click on "Reload Data" in the dataset the following message appears: "No Datasets found with Data Access set to Automatic Caching" How can I solve this? I need the information in FDI to be…
-
How to create a test user in Test environment
I have inherited FDI from a predecessor and need to set up a test user to use for configuring SSO. I am not sure where or how to stop and we are using FDI for our HCM data so there are data security concerns. Could someone please point me in the right direction?
-
Learning Report to show the most recent record
I have a request to provide a report that lists the employees and only the most current record of course completion status. Example: employee 1 has four records for course X the most recent record at the course / offering level is in progress. When a run a report today I will get four rows for employee 1
-
Run Payroll Costing Results - load column into FDI?
Hello, Is there a way to take a column from the seeded Run Payroll Costing Results report and move that into FDI for reporting use? The need for it is stemming from payroll transactions where the transactions share a process date of 10/31/24 but they differ by their accounting date where one has an accounting date of…
-
In Oracle fusion can we generate SAF-T data extract in CSV instead of standard XML output?
Currently in oracle fusion when we run "Generate SAF-T Data Extract" in schedule process, the standard and default output is in XML format. Can we change the output to CSV or excel format?
-
Fusion Data Intelligence and Oracle Netsuite
What are the components to be suscribed if I need to retrieve data form Fusion ERP Cloud and Oracle Netsuite at FDIP?
-
Set Up a Mail Server to Deliver Reports- OAC/FDI
Hi Team, Just wanted to check what is the best practice for configuring a SMTP server. should we use existing SMTP server which is available for scheduling OTBI reports or it is recommended to create a new one for FDI/OAC report scheduling requirements.
-
How to exclude cancelled work relationships from employee headcount?
When creating a dashboard using the "HCM-Workforce Core" subject area within FDI, the counts are bringing in cancelled work relationships as if they are active employees. Is there a way to exclude them or correct the data so that it no longer recognizes the employees as active?
-
Fusion Analytics Warehouse Training
Fusion Analytics Warehouse Training
-
Create the average assignment count on OAC/FAW
Hi, I have a report to produce using the assignment count KPI for different years. I've been struggling in FAW to create the calculation that would allow me to display the "average headcount" for a specific year. For example, for a specific Legal entity, I know that at the end of 2023, there were 71 employees But I'd like…
-
This Calculation is broken
I imported this Excel with 2 checks names: It gives me 2 lines: For line 1 (i.e. check 1) I want to check how many persons have birth date less than 1940. For line 2 (i.e. check 2) I want to check how many persons have blank flexfield. So my calculation is the following: So why the result is spreaded across all rows? I…
-
Project Line Manager
We've configured line manager for HCM analytics using this argument: "Core"."Dim - Assignment Manager List"."Manager Identifier"= VALUEOF(NQ_SESSION."HCM_PERSON_ID") applied it to 3 Logical Tables: Dim - Worker, Fact - Assignment, and Fact - Assignment Event. We did this through the semantic extensions for security after…
-
Dynamic variable Printing in footer of RTF Template
We want to print a dynamic variable in the footer of the BI RTF Template. Please provide your valuable input if anyone has worked on a similar requirement.
-
Dataset Storage vs. Database Connection
From the perspective of an FDI end-user concerned with saving their datasets, data flows, and workbooks in an optimal manner for scaling and long-term usage (access/sharing, reusability, space/costs, etc.), can you please explain the difference in Dataset Storage vs. Database Connection? Any key insights to keep in mind or…
