-
Count vacant positions in FDI using Position Managment Subject Area
We need to get vacant positions through Position Management subject area. The business need is that : the position is considered as vacant if there is no incumbent or if it's occupied only by Pending Workers and or Contingent Workers. Could you please share any formula or expression that may help in FAW ? or if you faced…
-
FDI Position Management – Displaying Vacant Positions with Leader Security
FDI: How to Report Vacant Positions with Direct/Indirect Leader Security? We're looking for guidance on the best approach to report on Position Management data in Fusion Data Intelligence (FDI). Our primary requirement is to identify and report on vacant positions (positions with no incumbent assigned) and surface this…
-
Help Needed: Steps to Migrate Standalone OAC HCM Project to FDI
Hi Experts, Could you please help me understand the steps involved in migrating a standalone OAC HCM project to FDI? Any guidance or documentation would be greatly appreciated.
-
FDI Workbook funnel is not rendering for TA metrics and giving blank page
FDI Workbook funnel is not rendering for TA metrics and giving blank page : Please share any recommendation or suggestions.
-
FDI Licensing Clarification: External Users, Third-Party Data Sources, and Public-Facing Analytics
Hello experts I am looking for clarification on Oracle Fusion Data Intelligence (FDI) licensing for the following scenario. Scenario An existing FDI customer would like to: Build custom data pipelines to ingest data from external sources (e.g., Salesforce, custom applications, and other third-party systems). Extend…
-
Visual configurations - Pivot Table type not displaying and tabular chart not Org filtering
ISSUE 1: I've created a few configurations, but the only one that I cant seem to get to work is the pivot table. The configuration preview seems fine But on the Maintenance Management Page is just blank: The green highlighted configurations are all the same OTBI Analysis and refer to the same record. The pink highlight is…
-
FDI security: Read-only access on one subject area with authoring restricted to another for the same
Problem: In Oracle Fusion Data Intelligence (FDI), can a single user or role be granted differentiated access across subject areas such that the user has Read-only (consume) access to reports built on one subject area, while Authoring/Write access is restricted to a different subject area only? Concrete example: We have…
-
FDI: How to allow DV data export for Consumer users while disabling "Open Classic" access?
We have a newly provisioned FDI instance. Users with the FAW HCM Licensed Consumer role can access DV content and export data as required, but they also see the Open Classic menu option in the DV three-dot menu. Clicking it opens Classic Home. Our business requirement is that Consumer users should not have access to…
-
Workbook deployment/migration after 26.R2.P1
When we import a Workbook using the Export/Import method, the dependent objects like Datasets and Connections appear in the Catalog folder path - alongside the Workbook. This feature appears to help with traceability We also then see the Connections and Datasets linked to the catalog paths listed in the Connection and…
-
Oracle FDI to OTBI connections - is OAuth available?
We are currently using basic authentication when creating our Oracle FDI to Fusion OTBI Data Connection. We would like to move to OAuth based authentication as we have for our integrations to the Fusion web services. Is there a way to do this? Thanks.
-
FDI HCM - Workforce Core: Expose multiple EIT rows per assignment using Semantic Model Extension
I am working on Oracle Fusion Data Intelligence (FDI) HCM Analytics and need guidance on how to expose multiple cost allocation rows per employee assignment in the HCM - Workforce Core subject area. Background: We have a custom EIT (Extra Information Type) called 'IPSOS ASG Cost Allocation' stored in…
-
Access Tokens visible for Viewer users – purpose and can they be disabled?
Hi all, We are testing the new FAW/FDI HCM Viewer Role and noticed that Viewer users can still access Profile → Access Tokens. The page states that these tokens can be used for: API calls Testing embedded content Using an MCP server My questions are: Why are Access Tokens available and visible for users with only the FAW…
-
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,…
-
Has anyone been able to map EBS tables with Fusion PVOs?
What are some practical mapping strategies that can be used to map EBS tables with Fusion PVOs? Please advise if anyone has worked on this activity before.
-
is available the option to append or combine tables in FDI?
i would like to have in BIP or FDI the details for each transaction from sources(CST, CMR, AP, FA, AR, INV) with the SLA and GL Detail, but in FDI i cannot see the transaction number to join with the diferent subject areas and in BIP i cannot find something like that. is therer any query or data model or in FDI?
-
Session variables for SCM?
there seems to be info on SALES session variables but I can't get a list for SCM? I need the session variable to determine the data view in redwood Maintenance Landing page OrgCode is prompted seems to work for the data cards, but the report below does not respond the same.
-
FDI - Real Time Subject Areas
In our FDI instance version 26.R2.P1, in the DV interface we are seeing many new subject areas available with the suffix "Real Time". Are these intended to replace OTBI reporting? Is there any documentation about them? I don't see any references to them in the What's New documentation.
-
FDI Deployment Issue: Environment Bundle Running Indefinitely
The Environment Bundle deployment (41 MB) has been running for over 20+ hours with no visible progress, no percentage/status updates, and no option to cancel the operation. Additionally, the Offerings page is empty, and no Data Pipelines are visible, so it is unclear whether the deployment is actually progressing in the…
-
Migrating a dashboard with a new Local Subject Area puts the LSA in Catalog
We found that after the 26.R2.P1 upgrade patch, when we migrate a report or dashboard from our development environment to our UAT environment any new Local Subject areas that we attached to the report are being put in the Catalog section instead of under Data. Previously any LSA's moved to a new environment would be placed…
-
test
test
-
Does Oracle FDI allow access to the ADW database via SSO only for users with the Service Admin ??
Does Oracle FDI allow users with the BI Consumer role, BI Author role, or an ERP application role to access the ADW database using SSO authentication?
-
Prompt for column not working with Logical SQL
I created a Logical SQL query in OTBI, and one of the returned columns is Business Unit. I wanted to create a prompt based on this column, so I configured the Business Unit column in the analysis as equal to a Presentation Variable named p_business_unit. Next, I created a dashboard prompt for the Business Unit column and…
-
For Financials category, doesn't FDI manage SCD type2 behavior ?
Need a help on understanding financial category maintainence in FDI, in case of any update in any account will my previous financial category doesn't remain in ADW database.If no, Is there any way to enable this nature in FDI.
-
AR Dashboard from Oracle ERP to FDI connection
We want to build a Receivables dashboard by customer eg : AR TRX with amount AR receipt with amount application un applied Un paid
-
How to bring Supplier qualification data into FDI as a new subject area?
Currently FDI doesn't have an ootb Supplier qualification subject area (covering qualification area, internal responder etc). Is it possible to use data aug to ingest a source pvo with the required info. Has anyone successfully extended FDI to cover supplier qualification data? If so, what was the approach.
-
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…
-
Validating Payroll Balances Between OTBI and FDI
Payroll Balances data validation between OTBI and FDI can be performed reliably when both reports use the same comparison context. Sharing an approach we used to validate Payroll Balances across both platforms. The key is to build side-by-side reports with aligned parameters and compare the values at the same level of…
-
Invoice Payment Date in PPM - Project Costs
Has anyone tried to bring the invoice payment date to the delivered PPM - Project Costs subject area to report on cash vs non-cash based costs? I checked in the PPM - Project Invoices subject area as well and for some reason the payment date is nowhere to be found currently. I'm looking for the best way to bring that field…
-
AI Agents/AI Assistant is not working as expected for user who having combined roles.
We developed separate dashboards for HR and Line Managers with AI Assistant enabled. It works correctly for users with a single role, but not for users with combined roles (e.g., HR Specialist + Line Manager, Service admin +Line manager). In such cases, when using the AI Assistant in the People Leader dashboard, it returns…
-
Add the ability to see what the base table name and column name is behind a field on the screen.
Allowing users to view the underlying base table and column names for Oracle BICC fields would reduce the time and effort required to identify the appropriate PVOs for data extraction. This would eliminate much of the current guesswork, improve developer productivity, and streamline report and integration development.
