-
Getting an FDI Subscription
Hi, Is the following OCI subscription correct to have an FDI instance that can be used to connect to a Fusion ERP / HCM / CX / SCM instance ? Thanks , Tamer
-
FTE by Gender/Nationality
I am trying to create a workbook using the subject area 'HCM - Workforce Core'. Attached the one I created. , but I have to filter it with some salary code(lonkode). ( We already have the same report available in Qlik and I am trying to recreate it in OAC), but I don't see any HCM related subject area is having this…
-
Salary gender pay gap
I have this example: 1st column: salary 2nd: gender 3rd and on: other variables I'm trying to plot a scatter chart, so far I have this: I'm trying to obtain something like this, with line showing all coefficients: What I'm doing wrong? I tried different configurations
-
Create an Integrated Oracle FDI with Fusion App - SSO requirement
In Administering Oracle Fusion Data Intelligence 24R4 document, it has below statement: When you create an Oracle Fusion Data Intelligence instance using the Integrations option in Oracle Fusion Cloud Applications, you automatically get: • The users, groups, and roles from Oracle Fusion Cloud Applications. Also, you don’t…
-
Is it possible to consider leading zeros from an XML file in Excel Model BI Publisher?
I'm designing a report with two sheets: One containing a regular table. Another with a pivot table. In my XML file, I have the <OP> field displayed as follows: <G_1> <ORD>1</ORD> <ORG>0001_OI_CED_MAT</ORG> <ITEM>VGA20143</ITEM> <DESCRI>VIGA I 6 A572 (W150 X 18.0) C/ 6000MM</DESCRI> <OP>0001.2461</OP> </G_1> For the first…
-
Key Metrics definition and updating problem
First, it is a problem with the level where Key Metrics are defined. Some documents say Key Metrics can be defined on Dataset and Subject Area levels. Additionally, there are instructions how to define Key Metrics on workbook level, meaning, actually, Key Metrics can be defined on Data Set, Subject Area and Workbook level.…
-
Import historic data from external source
We are developing a monthly import of employees info. With time data evolves and we want to keep track of historic values. Is it ok to import data with a time reference (eg: year and month) in order to add new data every time? I'm asking because I know FDI is not very user friendly with historic data
-
Activating AI Agents in FDI Embedded OAC (26R1 LA?)
Hi All, AI agents can be activated in standalone OAC, how can we do this on FDI OAC embedded instances? Is this available in 26R1 as limited availability feature (LA)? Thank you!
-
FDI table for Tax details
We are looking for FDI tables which contains Tax information such as Tax Code, Do we have any OOTB tables which contains information?
-
ESS Job Display Name Not Available
Hi Team, We are working on developing a report to identify all scheduled ESS jobs. Currently, we are able to retrieve only the short name of the ESS job from the available tables, but the full display name is not being returned. Is there any table or view where the display name of the ESS job is stored? We also reviewed…
-
How to forecast future FTE in Fusion AI Data Platform (FDI) when OOTB FTE stops at last actual?
Hi all, In Oracle Fusion AI Data Platform (FDI), the OOTB FTE measure stops at the last actual period and does not show future months, even when I extend the date filter forward. My question is: Should future FTE not be possible because Fusion HCM is effective-dated? In Fusion HCM, many worker components (including…
-
How to do a month-over-month comparison with this formula in Fusion / OAC?
Hello, I'm trying to calculate the turnover rate and hires with the formula below in Fusion (or Oracle Analytics Cloud), and I would like to know how I can make a month-over-month comparison. Here is the formula I’m using to calculate the hires/terminations: MSUM( FILTER( COUNT( DISTINCT "HCM - Workforce Core"."Employment…
-
How to make the mean by year?
I'm trying to build a metric that gives the mean for each year, for each person number. Let's say I want to do it on FTE (but it could be any number) and the situation is the following, how can I do?
-
Which key field to use for percentage breakdown of amounts allocated into main Ledger account?
I'm creating a report in FDI where all amounts from branches that are not Culiacán fall into that account. However, I want to break down the percentage of the total amount that belongs to the other branches. Which field should I use to make that breakdown? I'm using the Financials - GL Detail Transactions subject area.
-
How to create FDI report to linking the PO (Procurement module), GR (Receipt) and Invoice (AP)
Under Oracle Fusion, when create FDI report to extract the P2P process, from PO to GR to invoice. I use PO number as Join key, however, GR only link to PO, but not invoice, causing the report generated contain lots of non-matching line items.
-
Oracle FDI BI publisher data Augmentation
Hi, we need to add data from a BI Publisher report into Oracle FDI. We managed to add the BI Publisher connector, but we don’t understand how to join the standard Oracle FDI subject areas fields with the BI Publisher report. Thanks.
-
scheduling reports in FDI
Is it possible to schedule a DV report created in FDI? What are the options?
-
Gain and Loss From and To column is creating two rows for the same record
Hi, We found that in Gain and Loss Subject area, if we try to create a dashboard on BU Mobility 'From Business Unit Name' and 'To Business Unit Name' creating two different rows instead of single row. Person Number|From Business Unit Name|To Business Unit Name 101|ABC|~No Value~ 101|~No Value~|XYZ We tried different…
-
What happens to the imported csv file?
I want to setup a recurring reading of a csv file from SFTP server. What happens to the file once read? Does it remain there or will it be moved/deleted?
-
PROD Security Configuration not published
HI, We are facing security issue in PROD FDI instance. After our analysis, we found that Security Configurations published showing No in the Semantic Model extensions page. It showing state as 'New' and we checked no activities are in Progress. Now we are struck to publish the security configuration as its greyed out in…
-
Timestamp that shows when data is updated in OAC reports
It would be good service if all reports have a timestamp that shows when data is updated in OAC. 'Current_timestamp' simply tells the exact time it opened or refreshed the browser page. It reflects the "now" of the report, not the "age" of the data in the database or the file/dataset. How can I show when the data was…
-
Populating EFF information in Oracle Fusin AI data Platform
How can we pull extensible flex field information from oracle fusion to oracle analytics reports,if this is configured in oracle fusion, similar to DFF I do not see any option to enable EFF in oracle FDI which would extract data from Fusion EFF and loading it to Oracle FDI.
-
Securing imported data in FDI
I need to know what kind of security is available for importing csv file in FDI through sftp, in particular: Is it possible to authenticate via SSH key? It seems so by looking at this, I just want to be sure:…
-
Remove HTML tags the data loaded through HSDL.
Hello , We loaded the data for Performance Goal (for Description) in system through HSDL and noticed that the HTML tags like <b><br><p> which we used in HSDL file are visible from frontend as well. we need to load the data in bulk using HSDL but at the same time we don't want HTML tags to be visible from frontend. Is there…
-
Autosync ERP files are getting failed for data security assignments which is uploaded by system.
It says - This user doesn't have required data role for this security context. Please review the user-group assignments and the group-data role mapping. Security Object Code is invalid & Security Object Member Value is invalid How can we fix this issue.
-
EPM into FDI Rollups & Licensing
Looking into enabling EPM into FDI pipelines and bringing data into FDI to expand EPM reporting. Do these pipelines bring over the custom roll-ups created in EPM to FDI where they can be used in reporting and does this pipeline require the end-user to only have an EPM license (consumer or author) or would this pipeline…
-
Risk Management Cloud data in FDI?
Hi there - Is the data available in the Risk Management Cloud subject areas in OTBI somehow available in the ADW? For example:
-
Oracle Analytics AI Assistant: Indexing Custom Calculations
Hello everyone, we are trying to activate the Oracle AI Analytics Assistant for creating visualizations in our workbook. We followed all the steps mentioned in the documentation but we are facing the following issue: We are only able to index the "standard" subject areas to the tool and not our custom calculations. In…
-
Button access from fusion to FDI
Is it possible to create a direct link to fdi from fusion havent found a way in documentation maybe adding a button with the link but was wondering if there was a built in way
-
FDI – Production Instance Setup for Standard Dashboards (Best Practice)
Hello Experts, I have completed the full configuration on our TEST instance for Oracle Fusion Data Intelligence: Configured Pipeline Parameters Activated all required Functional Areas Ran Data Pipelines Completed Scheduled and Detailed Data Validation Now the standard dashboards are working correctly, and I am starting…
