-
HCM Dashboards Not Loading in FDI (SCM/ERP Working Fine)
Hi, I am facing an issue in Oracle Fusion Data Intelligence (FDI). SCM and ERP dashboards are loading correctly and data is being retrieved as expected. However, HCM dashboards are not retrieving data properly, except for Workforce-related dashboards. I have already run all required pipelines and full loads for the HCM…
-
FDI ERP Accounts Receivable Transactions not Importing Accounted Transactions
Data validation (Detailed Validation) for the "Enterprise Resource Planning" "Financials AR Transactions" offering, shows 20 missing records. (Source Total Records 27, Warehouse Total Records 7, Source Unique Records 20). Investigation of the source transactions in OTBI/ Fusion shows that all the transactions appear to be…
-
Double Suppression on protected Characteristics
Hi, I’m not sure if this is the right forum to post my question. If not, could you please direct me to the appropriate forum? I’m currently trying to apply double suppression in a pivot table using conditional formatting for Protected Characteristics and running into an issue. For example: If there are 3 Females and 6…
-
Dashboard and Canvas filters suddenly no longer working for certain users in a specific department?
We've had a long time deployed Principle Invesigator Dashboard that has been working perfectly for a couple years. Suddenly, a few weeks ago all of the Financial Administrators in the Engineering and Computer Science Department found that several visualizations at the bottom of the dashboard no longer reflect any of the…
-
Model artifacts are either not generated or not available locally
I have a python data science model but when I run it I encounter the following error: File "/home/datascience/Main.py", line 243, in <module> sk_model.save() File "/opt/conda/lib/python3.11/site-packages/ads/model/generic_model.py", line 2134, in save raise ArtifactsNotAvailableError ads.model.generic_model…
-
Learning - OTBI or BIP tables that can be used to list all rulesets tied to Learning initiatives
Are there tables or subject area that can be used to list all OTBI-based rulesets tied to a learning initiative?
-
Is there a way I can set up Email notifications in FDI when any pipeline or OAX job failed?
I am looking for help with Email or any kind of notifications set up in FDI when any pipeline or OAX job failed. Everyday will have to check manually all pipeline refreshments are happened or not and similar with oax jobs/DF/Sequences. Please share any documentation, link if available. Thanks!
-
Import incremental data from csv
Can someone explain me how incremental loading works in FDI? As per my experience every time I import a csv file I can only use the data contained in it, not data uploaded in previous flows
-
Implementation of Dynamic Buttons to Trigger Specific Sub-Agents in Chat Interface of an AI Agent
I am currently developing an AI Agent/Digital Assistant and I am looking to enhance the user experience by using interactive UI elements rather than just text input. Requirement: At the end of a service flow, I want the chatbot to ask, "Is there anything else I can assist you with?" and simultaneously display two buttons:…
-
We should Replace or Merge while deploying semantic model extension bundles from UAT to PROD FDI ?
I have created a holiday table in ADW & with help of semantic model extension joined this dim table with existing OOTB Subject area. Changes have been merged & published to main sandbox in UAT. So, while deploying UAT SME bundle in Prod we have to select "Merge Sandbox content" or "Replace Sandbox content" ?
-
Pre process csv
I'm importing this csv: Person_Number Company FTE Salary 001 A 0.5 40000 001 B 1 50000 002 A 1 30000 Is there a way to pre process data in order to group by Person_Number using SUM/AVG/MAX (or complex formulas) in other fields? The purpose is to make charts that are not only Pivot Tables but also Bar Charts and so on
-
Do we have any OOTB FDI/ADW table which stores Individual compensation data in FDI HCM?
Do we have any OOTB FDI/ADW table which stores Individual compensation data (ICD)/Awards that can be used in FDI Data Augmentation.
-
What all bundles should we import while planning to migrate our FDI-PROD to new lower non-prod FDI?
We need some guidance regarding the sequence of bundle import in lower environments. If I import Data config bundle followed by environment bundle - that should suffice ? Or I need to import all bundles separately- Security, content, Semantic bundles ? I have security & semantic model extensions in Prod environment. Is…
-
Is it recommended to change my FDI production instance from Standalone to Integrated type?
I’m facing an issue where, after my FDI instance went down or lost connection with my Fusion applications, we re-established the connection with the help of an SR. However, my FDI instance is now set as Standalone, and the connection method is password-based. Before this, my PROD instance was integrated, so the connection…
-
How to embed the report built with FDI in fusion or any web page
Hi Experts Could you please let me know the steps how to embed the FDI report in fusion or any web page. I'm not sure how to get the URL of the FDI report for embedding. Please help me
-
Embed FDI reports in Fusion
Is there any other way to embed FDI reports in Fusion other than through Visual Builder? I found this blog where they explain the procedure for doing this using Visual Builder: https://blogs.oracle.com/analytics/post/embedding-fusion-analytics-content-in-oracle-application-cloud But is there any other alternative, or is…
-
New Licensed Roles - Viewer vs. Consumer
In 26R1 there are new licensed roles that make a distinction between "viewer" vs. "consumer". What's the actual implication for having viewer vs. consumer licensed role access? Licensed Roles
-
FDI BIP Connector - Run In Chunk Mode - Invalid parameters for BIP chunking error
Hi, I am trying to use the Run In Chunk Mode option in the BIP Connector configuration in FDI to handle a large BIP report (~4M rows).We have configured the following in the connection: → Run In Chunk Mode: enabled → Chunk Days: 30 I get the following error when testing the connection:…
-
How to create a custom role which can be given to users to schedule the workbooks in Orace FDI ?
How to create a custom role which can be given to users to schedule the workbooks in Orace FDI as we cannot give BI admin access to all the users. Not able to find any role with "Schedule Workbook" access.
-
Will updating the source URL details affect the ADW OOTB tables or remove custom schema objects
Will updating the source URL details affect the data stored in ADW out-of-the-box tables or remove custom schema objects? Please clarify the consequences for Oracle FDI and OAC reports, configuration —will SME changes still be preserved in FDI?
-
How to Enable Indexing on CSV Dataset in Oracle Analytical Cloud
I am following the same steps for enabling indexing on CSV dataset, but getting error "Run now failed: Indexing is not enable." Why?
-
Is it allowed to update connection details while creating fusion cloud integrated FDI instance
Is it permissible to update Fusion connection details during the creation of a Fusion cloud integrated FDI instance, Since oracle is showing the below note: If not under which configuration users are allowed to update source connection details in FDI.
-
No Data Showing in HCM Dashboards (FDI) Despite Successful Pipeline Run
Hi everyone, I’m currently working with Oracle Fusion Data Intelligence (FDI) and have configured and executed the data pipeline for Human Capital Management (HCM). The pipeline completes successfully without any errors. However, when I open HCM dashboards — for example, the Absence Dashboard — the dashboards display: “No…
-
OOTB Workbooks lineage to Fusion Modules
With more and more OOTB contents being created and available in FAIDP/FDI, what is the best way to figure out the workbook to Fusion module lineage e.g. a newly available workbook in HCM Analytics called GROW, what modules customer must be using to be able to see data in this workbook. Is there a simple way to get this…
-
DFF values are coming as code not description
I am noticed in a client implementation that while in OTBI the Grade DFF brings the right values from description but the same DFF in FAIDP/FDI is bring the corresponding code rather than the description/value. Anyone seen this behaviour?
-
Enable AI Assistant for Datasets not just Subject Areas
In OAC there's a capability to index a specific dataset for AI assistant usage. Is this supported on the FAIDP side? When going to the OAC console of FAIDP I see subject areas listed, but not datasets.
-
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…
-
OTBI Report Automation - Upload .catalog file
This might be repetition of the question - Is it possible to upload a BIP report .catalog object using the SOAP web services? - Oracle In order to enforce change control and git actions, we are automating the BIP Report upload process. To keep things consistent for FRS, BIP, OTBI reports, we are going to ask developer to…
-
Slowly Changing Dimension - type 2
Hi All I want to keep track about my customers, like how many join/left and rejoin on daily basis. Also want to track with many other attributes. Does FDI support SCD-2 or change data capture (CDC)?
-
Conditional Formatting Against Dynamic Targets
I want to apply conditional formatting for one value against another calculated value. We can use turnover as my example. Let's say the YTD annualized turnover value for the company is 15%. I've created a visualization that applies all the applicable filters and produces a value of 15% for the entire company. I want my…
