-
How to Inject external data into Oracle Autonomous lakehouse via SFTP connector?
How to Inject external data (Business central data) into Oracle Autonomous lakehouse via SFTP connector in FDI?
-
Local Subject Areas Showing 'Schema Listing Not Available' in both PROD and DEV
OOTB subject area fields are not available in DEV and PROD. Existing workbooks display "Error Loading Data" and report that standard fields are cannot be found. Local Subject Areas also display "Schema listing not available". The issue appears to affect the FDI semantic layer/metadata across environments. Can anyone facing…
-
FDI wrong data
I’m currently facing an issue with the Absence data in FDI. For example, in the screenshot, the Approved Absence measure is showing 1, while the correct value in Fusion 1,560. A few points: This is the standard/prebuilt dashboard; no customizations were made. There is no date filter applied. The FDI refresh runs daily, so…
-
Data | Visualize | Present Tabs Missing After Release Update – How to Hide Filters and canvas now?
After the recent Oracle FDI/OAC release updates, both our PROD and DEV environments no longer display the Data | Visualize | Present tabs at the top of the workbook.Previously, I used the Present tab to: Hide or show specific canvases/visualizations. Hide filters used in the workbook. With the new workbook interface, I…
-
HTML Format report in FRs showing extra space and how to merge two grids with single prompt
Report 1 :We do have FRS report with 7 to 8 columns.HTML veiw of the report showing extra space .how to fit the output to the report .There should not be space in the html report.Attaching the report output. Report 1 output : Report2 : We do have an FRS Report where one connection has all ledgers except CSG IND STAT…
-
AI Agent of Oracle Analytics Cloud of FDI
How to show amount columns with currency symbol and format in AI Agent response. Provided sample in supplement instruction but it is not displaying based on format
-
Headcount Turnover measure in FDI, seeking clarification
We are trying to clarify the 2 data sets that go into the oracle-delivered "Headcount Turnover" measure. This measure is found in FDI, in "HCM - Workforce Core"."Facts - Workforce Headcount" subject area We have our own internal calculation, which is a few percentage points different than this measure, which is why we are…
-
Month filter not working
My data: My Calculation - above in the last column you can see it works great: So why the heck my table goes blank for every value in Month End Date filter?
-
Data Security Step option is missing on Semantic Model Extensions Security Configurations tab.
Dear Experts, We are trying to add security steps to our new implementation but the option that is mentioned in oracle documentation and also seen on other existing implementations is not available in our instance. The Navigation is FDI Console> Semantic Model Extensions> Security Configurations> Data Security Step.…
-
Fusion Data Intelligence: Asset Master Data in SCM- Maintenance Subject areas
Hi Team We are developing SCM reports using SCM-Maintenance Module (incl WO Header, Operation, Resource, Assets, Asset Route areas etc) in Oracle FDI. In FDI , OOTB SCM-Maintenance doesn't have any Asset related information and as per below documentation , I believe its deprecated .…
-
How long should new Oracle EPM Planning Integrator take to initialize?
We are attempting to set up an EPM connection using the Preview Feature Oracle EPM Planning Integrator. In the Request History tab on the console, it shows two entries: Initialize Connection and Refresh Metadata. The initialize connection step has been sitting in "In Progress" status for more than 12 hours and the Refresh…
-
Issue Supply Chain Planning Analytics in FDI
Hi , I am following up the document Oracle Fusion Supply Chain Planning to enable Supply Chain Planning Analytics 1.Created Connection and Test Succussed 2.Checked with Functional consultant, the plan is public in Fusion 3.When I tried to create a data augmentation as the documentation --> It showing the error: No source…
-
Creating AI-generated summary of questionnaire response
I'm building a dashboard for HR to show the responses from our Employee Exit Questionnaire. For the open-ended questions, rather than just a table list of responses, I'd like to show some kind of AI-generated summary. I'm quite new to using FDI. From my research, it seems like it should be possible, but I've not been able…
-
OAC ADW connection missing "Access" option
We are an FDI customer, OAC instance does not show "Access" option for Autonomous Transaction Processing DB type connections. This seems to happen after the latest patches. Also, other admin users cannot see the new connection that I created. Has anyone else noticed this issue in their environment?
-
Manager/Organisational/Department/Matrix Hierarchy are not populating data.
In FDI, most of the Hierarchy folder wont populating any data. This is one of the most required data from HR. Can anyone assist me how can I get that data in FDI.
-
What is plan for bringing in OTBI Subject areas into FDI ?
Hello Oracle Team, Many organizations currently rely on both Oracle Transactional Business Intelligence (OTBI) and Oracle Fusion Data Intelligence (FDI) for reporting and analytics. While FDI continues to expand its subject area coverage, there are still several OTBI subject areas that are not yet available in FDI. Could…
-
FDI Dataflow Datasets and ADW Data Views Considered Custom Data?
We want a better grasp on what is considered custom data so we can plan ahead and scale properly before we get too big. Fortunately we are no where near the 50gb limit as found using the subject area for custom data but it doesn't tell us other than 'System' where the custom data is coming from. I found documentation here:…
-
FDI OAC - Production to Development Environment Refreshes
Is there a way to refresh our development environments in OAC with production data? There a lot of developments that didn't make the cut into production and/or was only used for testing and we would like to clean up dashboards, datasets, data flows, etc… Possibly similar to how receive environment refreshes in our Oracle…
-
Is Delegates should be able to view and run the same dashboards the manager has access to in FDI?
Managers want the ability to assign delegates in Fusion Data Intelligence (FDI) so that delegated users can access and use reports on their behalf. Is that available in FDI now? If yes, anyone share docs about steps to implement that in FDI Thanks
-
Report on missing default expense account
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
-
FDI Payroll Costing Transfer to GL Date
In FDI Payroll Costing subject area there is out of the box column for Transfer to GL Flag / Indicator, I've tried searching through tables in subject area to add physical column for transfer to GL Date but no luck. Does anyone know how I can populate a transfer to GL date in payroll costing? We are attempting to build a…
-
Fusion Data Intelligence : Asset DFFs in Maintenance Cloud subject areas
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
-
All local subject area has disappeared after functional area reload data
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
-
Why inactive people do not appear in FDI?
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
-
Additional Assignment Information (Extensible Flexfields) in Fusion Data Intelligence
Hello, I'm looking for some guidance on adding Extensible Flexfields (EFFs) into FDI. I'm particularly looking to add fields from the Additional Assignment Info area (PER_ASSIGNMENT_EXTRA_INFO_M). Has anyone done this and have any guidance to share? The documentation I have found to date has not been very insightful. Thank…
-
Access FDI Workbook Tile from Fusion Landing Page
Hello, Am new to FDI but learning. I know that we can access the FDI Workbook (which you normally see in Oracle Analytics - see below) from the Fusion landing page, as demo-ed by one of our consultants. However, how do we do this? I know that in Fusion Security Console, you need to add several application roles in order to…
-
Enterprise-Level FDI-MCP Configuration for Business Users - Codex/Claude
Has anyone implemented an Enterprise-level FDI-MCP configuration for all Business Users so that individual Users don’t have to perform the configuration themselves? If yes, could you please share the recommended approach or any documentation/steps to set this up?
-
Top level CEO record drops out when Bottom Up Manager Details are selected in an analysis
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
-
Actual "Span of Control" calculation (using HCM data)?
Would like to know if anyone has created an FDI calculation in "HCM - Workforce Core" subject area that returns true Span of Control (based on actual current manager to direct reportee ratios)? It seems both Oracle delivered Span of Control measures aggregate average ratios over a span of time. We would like to show a true…
-
Data Augmentation option for Fusion source is missing in Data Configurations
HI, We are facing strange issue that the Data augmentation option is not visible in Data Configuration page for Fusion source connector. This seems impacted for most of customers we do support. Please advise if something got changed. Thanks, Dhilip