-
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…
-
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.
-
Financials - AR Aging Question
Hello. I am trying to build an AR Trend analysis graph using the Financials - AR Aging subject area. While validating data, I'm noticing the majority of the unpaid AR Invoices aren't showing up in this subject area. I'm only seeing 2 when I know we have at least hundreds. Is there something special that has to occur 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…
-
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
-
Expression Filters (Dynamic Date Ranges)
Hi, does anyone know if it is possible to create expression filter with dynamic date ranges in FAW? i am trying to create a filter that only shows the "last 12 months", "last 6 months" .. etc from the current date. any guidance would be much appreciated, thanks
-
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…
-
Legal Employer in From and To Folders in Gains and Losses
Our organization relies heavily on Legal Employer, and the absence of this in the From and To folders within the Gains and Losses subject area is limiting our ability to report accurately on internal movement. Is inclusion of Legal Employer in these folders planned for a future release, or is there an alternative approach…
-
Hot to import csv from external source?
I need a guide to setup an SFTP import of a PGP encrypted file in FDI, so I need to know how to decrypt csv, how to import csv, how to map existing/new fields
-
How can we get "From" and "To" Department Hierarchy in FAW workforce Gain and Losses Subject area
Hi All , We are using workforce gain and losses subject area to build the promotion and demotion information including various Job and employee related attribute . This subject area has "From" and "To" dimension related job, Department , Position etc. Our requirement is to add department hierarchy which shows 'From ' and…
-
Days Sales Outstanding (DSO) and Rolling 12 months Revenue in FDI
I would like to develop FDI table visualization that has DSO using 12 months and Rolling 12 months Revenue using Fiscal Period. Relative time function is not available for Fiscal period. How to calculate DSO and 12 months revenue.
-
Is it possible to upload a BIP report .catalog object using the SOAP web services?
I've done some POCs using the SOAP web services provided (CatalogService (oracle.com)); however, I haven't found any of these web services that can upload a .catalog file. It would be helpful to have a web service that can upload the .catalog files created in UI when archiving BIP reports in order to migrate a version of…
-
How to connect Apex/VBCS to OCI AIDP
Hi All, Is there any documentation/training links if you came across on how to pass prompt from Apex/VBCS page to OCI AI DP to leverage information from ALH and send response back to Apex/VBCS page to render the page based on response. As of now, i do not see any topics covering those except for OAC/Tableau/Power BI…
-
Exam 1Z0-1128-24: Oracle Fusion Data Intelligence 2024 Implementation Professional not able to add.
Hi, I am trying to add the FDI Implementation Professional exam to the cart, after adding to the cart, I do not see FDI exam, rather it is showing Oracle Cloud Applications Exam Subscription for USD 245. Is this right selection I am doing? If so, where do I get option to pick the FDI? Could someone help me how do I…
-
How to default a Prompt's selection as user's login name
Hi Experts, Would like to reach out to you on how to set the default value of a Prompt with user's login name. Please refer to below screenshot that I have an Analysis created with subject area of "Receiving - Purchase Receipts Real Time", and a Prompt is using the column of "- Purchase Receipt Header Details > Created…
-
AR Total Outstanding is not matching with Oracle Fusion
I can see that FDI shows there is outstanding from a customer under Total Outstanding column but when reviewed the customer account in AR(Oracle Fusion) there is no outstanding. I tried looking in data validation tab for validating this matric but its not available. I also tried at transaction level, but FDI treats…
-
Semantic model vs custom dataset joins for manager headcount
Hi everyone, I’m building an Oracle Analytics dashboard and hitting limitations with dataset joins. Setup: * Dataset A: Recognition data (Office, Team, Compensation Manager) — includes some terminated employees * Dataset B: Unique award recipients (same grain) * Dataset C: Active headcount (Office, Team, Compensation…
-
FDI Activation
Does exist a clear step list with screenshot or (even better) video to activate a FDI instance?
-
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…
-
Fusion Analytics -Locode :Introduction
https://videohub.oracle.com/embed/secure/iframe/entryId/1_xpcvo0zk/uiConfId/35965902 Locode for FAW - Can be used as a powerful technique for data extraction from varied sourced into FAW .Attached video provides an introduction to the feature.The Feature is not yet GA (General Availability) and can be only enabled via SR…
-
AP invoices have an outgoing AR invoice
Working on a use case to validate that all AP invoices have an outgoing AR invoice, the number's are equal but they don't share any other attributes. Here is the error I encountered, what am I doing wrong? Was able to perform the join on local subject area's but aggregation totals are not summing correctly. Below is on FDI…
-
How to apply segment value security in FDI?
Hi, Where segment value security is enabled in the chart of accounts, what is the best approach to mirror this within FDI? We have users who are restricted on cost centre segments within all business functions and we want to replicate this access to reports ran in FDI. Thanks, Adam
-
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.
-
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…
-
How to enable procurement dashboards
The Oracle demo instance currently includes a comprehensive Procurement Dashboard that provides valuable insights across procurement operations — such as requisitions, purchase orders, agreements, and supplier performance. This dashboard is a powerful and ready-to-use analytical tool, helping businesses monitor KPIs,…
-
FDI GL Balances Data Not Matching with Fusion After P2T
Hi Experts, After the recent P2T refresh, GL balances in FDI are not matching the balances in Fusion. We compared ledger, period, and account combinations, and Fusion shows correct balances. However, FDI is showing different totals for the same data. The data pipeline completed successfully with no errors. Could you please…
-
Oracle Analytics Instance - Access Issue
I have registered for Oracle AI challenge and got the confirmation mail about the registration, but when I am trying for the access, I am getting the below error.
-
FDI:FAW: Fusion Apps P2T/T2P process impact on Fusion Data Intelligence - Data Mismatch & DFF change
Please note If P2T/T2P is done on FA source which is used by Fusion Data Intelligence this can have a significant Data Mismatch and DFF/Customization impact due to change in source data and metadata-config - FDI Data Reload is required after Fusion Apps P2T/T2P Fusion Apps P2T/T2P environment refresh copies data from a…
-
FAW HCM - Custom Data Security Use Cases Using AOR data available in FAW
Post 22.R4 FAW release, FAW brings AOR data as well from cloud hcm with daily incremental changes. Many organizations use AOR data to set up custom security and it has been a highly sought-after feature in FAW. With this blog post - we starting a series where we will keep adding new use cases to use AOR data in setting up…
-
Fusion Analytics Autonomous security Series: Custom Data security
About Data Access through Security Assignments You grant the data security assignments at the user-level. Data security assignments apply data filters to display only the data corresponding to the security assignment values assigned to the users. For example, John Smith and Marie Pierce are both Accounts Payable Manager in…
