-
OTBI Action Link to BI Publisher Report – Migration Issue (Page Not Found)
Hi Team, In Oracle Transactional Business Intelligence dashboard, I am using Action Link to open a Oracle Analytics Publisher report (.xdo). Current full URL works: https://<host>/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=... Issue: I want to remove hardcoded host for migration (DEV → TEST →…
-
Failed to Extend Entity
I tried to extend the subject area 'HCM - Workforce Core' to get the National Identifier , using HcmTopModelAnalyticsGlobalAM.PersonAM.PersonDetailsPVO but I am not getting NID details under the subject area. I am getting all other details ,but not Primary National Identifier. Is there anything missing from my end.…
-
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…
-
Need FAIDP SCM User for Demo Oraclecloud Instance
Hello team, I am having access for demo.oraclecloud.com and want to access FAIDP OOTB reports of SCM pillar. but unable find user that works and having access of SCM pillar reports from list of all users available in demo.oracle.com Thanks, Dhiren
-
Will Integrated Fusion Data Intelligence use Oracle Fusion Application Cloud Access Control List
The Fusion Data Intelligence allows for 19 Access Control List configured. We are using Integrated Fusion Data intelligence and want to check if it will also use the Oracle Fusion Application Cloud Access Control List as it is configured within the same virtual control network of fusion. Please can you advise if this is…
-
Business Capability field for Skills Library Content Items - which transactional table stores it and
We are working on a reporting requirement in Oracle Fusion Data Intelligence (FDI) to add the Business Capability attribute to the Talent Profile/Skills subject area. We have been investigating both the HCM transactional tables (via BI Publisher) and the FDI ADW schema (OAX$OAC) but cannot locate where this field is…
-
How to enable additional OTBI Subjects Areas in FDI? - Oracle Fixed Assets Subject Areas
There are only 2 Subject Areas for Fixed Assets available in FDI namely Financials - Assets Analysis and Financials - Assets Transactions. The following Subject Areas are in OTBI and not in FDI. We like to know how we can make the following OTBI Subject Areas also available in FDI. 1. Fixed Assets – Asset Depreciation Real…
-
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…
-
Embedding FDI Workbooks within External Applications like Salesforce
I came across this post but was curious to find out if anyone had tried to do this with the FDI-version of OAC: Any issues faced/gotchas?
-
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
-
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…
-
Salary Code Data in HCM/Payroll workbook
Is there any subject area holding the salary code values in either HCM or Payroll subject areas (Either in OTBI or OAC)? I could find this in General Ledger Subject area, but not in HCM/Payroll . Element name column in Payroll subject area is somewhat similar,but not the same. Regards, Sreeja M B
-
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…
-
Oracle FDI and Oracle AIDP
HI All, I need help in understanding how is Oracle Fusion AI Data Platform different than Oracle FDI. I thought Oracle FDI is now rebranded as Oracle AIDP. Please help me to understand more on this.
-
How to assign licensed group from oracle fusion application cloud
Hi, We would like to manage the user provisioning for FDI from Oracle fusion application cloud. We want to create custom abstract role in oracle fusion application cloud for each FAW licensed group. Assign the abstract role to user in fusion and want the user in FDI to get the FAW licensed group. I followed the below…
-
Setup Single Sign On in FDI
I'm trying to setup SSO in FDI environment following these instructions: https://docs.oracle.com/en/cloud/saas/analytics/26r1/fawag/user-access-single-cloud-account.html Unfortunately it seems more related to HCM because if I go to Configure JWT Authentication Provider it seems referring to HCM So does exist some tutorial…
-
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…
-
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:…
-
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:…
