-
Which data sets can I use to create a landed cost report in FDI?
I want to generate a cost report with landed cost, but I don’t know which data sets or which connection I should use to extract the data.
-
Not able to find the exact calculation for OTBI columns in OAC
This is more like a technical question. I was trying to migrate one OTBI report to OAC and one of the condition I was trying to create is when cdl.reversed_flag is not null or cdl.line_num_reversed is not null then 'Y' else 'N' end cdl_net_zero (Currently used condition in OTBI report). I can find the corresponding column…
-
FDI vs. OAC: Time Zone in Workbooks Preview Feature
There is a new time zone feature that came out as an OAC preview feature in the November release. This feature allows the user to override the default time zone and shows timestamp data in their time zone instead of the default. Useful when you have data produced in GMT time and user in Eastern time. This feature can be…
-
Is Description or Hover Text Supported for Custom Metrics in Semantic Model Extension?
Dear Experts I created custom metrics using a Semantic Model Extension, but I don’t see any option to define description or hover text like we have for standard metrics (refer to attached screenshot). Is this currently supported? If not, is it a known limitation? Any guidance would be appreciated. Regards Saptadip
-
Question on FDR v2: Data Access Security (Row‑Level) Refresh Timing
Our FDI implementation began last year leveraging FDR v1. During SIT, it became clear that production go‑live on FDR v1 would not be supported, as our instance was not grandfathered under the original eligibility model. As we assess the required transition to FDR v2, we’ve identified a clarification point that is not…
-
Schedule the dataset is having issues with Data Access Set to Automatic Caching
Hello Team, When I am trying to schedule a dataset, its saying No Datasets found with Data Access set to Automatic Caching. In this regard, need your inputs how to overcome below message, Thank you Gopal
-
Handling user ID in FDI post P2T refresh
In a production to test environment refresh process if a user's id does not exist in production instance, how will the user would be able to login to FDI post refresh who was earlier a service administrator. will the access need to recreated in lower ERP instance or we can primarily mitigate this issue by following some…
-
Make Master Contract ID Available to Pull into PO Report
I am creating a PO report in FDI and I have the PO number and the PO status, the ordered amount, the delivered amount, etc. I am trying to locate the Master Contract ID that we have activated in the PO. Where do I go to find that field to pull that into a report?
-
Reporting Either Project Org Hierarchy or Task Org Hierarchy Within One Set of Dashboard Filters
I'm apologizing ahead of time for the length of this post. I'm sorry. I am currently working on a Fusion ERP/HCM/FDI/OAC implementation project. We are not live yet but will be live soon. I am trying to build an OAC workbook visualization that shows Backlog Amount (Project Funding - Project Revenue). The issue I am having…
-
How to Connect Eloqua to FDI
I am trying to connect Eloqua to Fusion Data Intelligence (FDI) from the FDI Console via Data Configuration > Manage Connections, but I am encountering the following error: “401 Invalid Source configuration – Credentials or Source configuration details are wrong. Please rectify.” I have tried changing the endpoint URL in…
-
Enable Features - Allow more data extract for GL Account
What is "more", is it defined indetails in any documentation on what to expect when we enable this feature?
-
Migrating Custom Datasets between OAC Environments
In OAC, I have created a custom dataset that uses an OTBI subject area as its data source. I have then used that dataset as my data source for an OAC workbook. When I migrate the workbook from our SIT environment to our UAT environment, the dataset remains connected to the SIT OTBI data source. I then have to go into the…
-
Business requirement to convert PST time to UTC time in collaboration messaging
one of the vender using collaboration messaging to post the ASN IN messages. They have special requirement to convert date time from PST to UTC time zone. They suggested to use this in collaboration messaging <xsl:variable name="UTC-date"…
-
Connecting to FAIDP OAC instance with catalog manager?
Is it possible to connect to the FAIDP OAC instance with the command line catalog manager tool that is part of the client tools? If so, is there a restriction when using SSO authentication? I'd trying to use this command and keep getting authentication errors: runcat.cmd -cmd report -online "https://<fdi service goes…
-
Null Date
Hi All, Null dates are displayed as 11/30/0 in my dashboard. How can this to be displayed as blanks. Thank you
-
Analytics report shows previous direct reports for the Manager
Hi, In Analytics report for MSS its showing the previous direct reports for the Manager who was recently transfered. How do we fix it? Regards
-
Is there an impact if we don't update to Frequent data refresh version 2?
Recently we have started seeing the below notification in FDI- "This frequent data refresh capability is planned to be deprecated in an upcoming future release." In case if we don't update it to version, what would be the impact. Regards
-
Dimensions in FDI
Hi, When I create a dimension in the FDI semantic model, I get a query failure error, even though my joins seem good. Is it better to only extend dimensions or is there a way around creating custom dimensions? Thanks
-
How can I connect a Zebra printer to print barcodes in AIM?
How can I connect a Zebra printer to print barcodes in Advanced Inventory Management? I would like to know if anyone knows how to connect a Zebra printer to generate and print LPNs in AIM. And also if it is possible to do this locally or if it must be done through a server.
-
Why Oracle is not allowing to connect Oracle Fusion database using SQL Developer
Summary: Why Oracle is not allowing to connect Oracle Fusion database using SQL Developer similar to EBS database connection Content (required): By Connecting using SQL Developer, we can directly utilize data as per need instead of creating additional layer for extraction.
-
Oracle FDI - Any HCM Predictive Analytics samples - Attritions/Exit risk
Hi, In Oracle Analytics Cloud/FDI,I don't find any pre-built predictive analytics for HCM Analytics. We have diversity analysis in demo's for ML but we don't have that sample to see how the data model built and LLM selected. Can you please share/suggest if any sample data models using prebuilt subject areas or datasets in…
-
Data Augmentation for contract history
Hello, Both of these PVO don't give the history of a contract for a data augmentation : HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVO HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVOViewAll I need to have in the adw the history of the contract, especially the field ContractPEOType. I checked in HCM though BI…
-
Not able to connect to ADW using SQL developer
We are trying to connect to ADW with OAX_USER using SQL developer but getting error while doing so. But when we try to create connection using OAC DV with same wallet file and OAX_USER. Its working.
-
FDI ERRO AO CARREGAR DADOS
Olá, sou de uma equipe de HR e estamos com um problema que já ocorreu 2x em que o painel/dashboard começa a atualizar os dados em loop e não permite fazer mais nenhuma alteração no painel "erro ao carregar NOMEDODEPARTAMENTO DE NÍVEL 4". A barra laranja corre até o final rapidamente várias vezes até que a sessão cai por…
-
Steps requires to perform in FDI instances when there is a scheduled or ongoing patch in ERP/SCM
What is the best practice for managing FDI instances while the linked Fusion ERP/SCM instance undergoes patching?
-
FDI – Custom Financial Categories in OOTB GL Subject Areas
Dear Experts Is there a supported way to bring custom financial categories from Fusion GL into FDI and use them in OOTB GL subject areas? We understand that prebuilt metrics are based on standard categories and may require derived metrics. Looking for any recommended or proven approach. Regards Saptadip
-
Worker count goal numbers using My Calculation in FAW
Hello, I am trying to enter in goal numbers base on worker count for a legal entity by month. I'm trying to create a calculation and this is what I have so far. CASE WHEN "HCM - Workforce Core"."Legal Employer"."Legal Employer Name" = 'Legal Employer' THEN CASE WHEN "HCM - Workforce Core"."Time"."Month" = '2026/01' THEN…
-
Custom Metric Showing Zero in FDI Logical Star but Works as Calculated Column
Hello Community We have created custom metrics using Logical Star in Oracle FDI and added them to the GL – Balance Sheet subject area. However, the metric is returning zero values when used as a custom metric in the semantic model, while the exact same formula works correctly when created as a calculated column in the…
-
Application Role-Group-User-Dashboard
Hi All, is there any option we can download in an excel /csv file. Application role→Group→Users Application role→Dashboard Regards Joji Gubili
-
Number of allowed FDI instance and licensing model
I would like to understand how the licensing model operates in FDI. Is there an additional cost associated with creating an FDI instanse beyond the development and production instances? In case of multiple fusion instance. kindly provide clarification on this topic.
