-
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.
-
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…
-
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
-
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.
-
FAW HCM Restricted Author Role
Hello, we are currently setting up the roles and security in Fusion AI Data Platform. We tried to use the "FAW Licensed HCM Restricted Author Role" Based on our understanding, this role is intended to support analytics authoring (e.g. analyses and dashboards) on existing subject areas, while restricting more advanced…
-
How to check FDI demo refresh date?
We want to make a demo to a prospect and we need to customize an FDI demo environment. We know that when refresh occurs all customizations are lost so how to check what is the environment refresh date?
-
Time Series Function Limitation with Measures and Dimension Attributes in SME
Description: In the Semantic Modeler (SME), we are facing an issue with the Time Series function: The Time Series function works correctly when applied to fact table measure columns only. However, it does not work when combining measure columns with dimension attributes. Currently: In SME, the aggregation rule is applied…
-
Extending with scripting and sequencing scripts
Hello, I'm looking at using the new scripting functionality for doing post Fusion SaaS ETL transforms. Essentially I want to add a subject area with type 2 SDC some attributes for AR and AP transactions, i.e. the ability to look at invoices as if they were at a point in time (at least at a day level granularity). The…
-
Which functional area to be refreshed if Potential Ratings fields are not giving lates data in FDI
Which functional area to be reloaded in FDI if Workforce Core → Potential Ratings fields such as (Potential ratings date from/to), numeric rating, rating model name, level name (all the profile details) are not giving lates data in FDI when compared with fusion.
-
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 →…
-
Oracle AI Analytics Assistant: Enhancements
Hello everyone, following a post that we had opened some months ago, we would like to ask if there are any planned enhancements on the Oracle Analytics AI Assistant feature. As we had previously described, our main issue was that custom calculations could not be made available for indexing, unless they were included in a…
-
Does FAW/FDI have an in-built WAF protecting either a Public or Private endpoint deployment model ?
-
In FDI way to easily identify Pipeline and linked Standard
In FDI is there a way to easily identify Pipeline Requisitions and their associated linked standard Requisition from Oracle Recruiting cloud for reporting? We have a request to create visualizations on the various statuses beginning with the Pipeline and ending with the Linked standard requisition.
-
FDI add custom font
Hi, Is it possible to add custom fonts in Oracle FDI?
-
Facing issue for using the SUBSTR function with negative number in eText Template
We have requirement to print the last 4 digits from summed value in eText template. We have used the below code to print the last 4 digits but its not working. please let me know if any one of you worked on similar requirement. SUBSTR((SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’Net…
-
Suppress zeroes and nulls in FDI Data Visualization
I am hoping to suppress all of the rows showing with null or zero in the screenshot below, while retaining all rows that show values other than zero. I've seen some options for an Expression Filter using the 'Aggregate By' function, but have not yet been successful. I'd also like to convert the nulls to zeroes if at all…
-
Why does the FDI AI Assistant occasionally return different results when the same question is asked?
We have observed on occasion that the AI Assistant in FDI will return different results when asking it the same question. Why is that? It makes the feature seem unreliable to our business users when this occurs. In the below screenshots, you can see an example where the same query is being posed to the Assistant, but it…
-
Inject JSON file as data source.
I everyone, I was just wondering if it was possible to inject a JSON file as a source file (just like we're doing with CSV/Excel today). I could not see any option on this when creating a datamodel, but probably i'm doing it wrong. In our specific case, setting a REST link to that platform is not an option, and turning…
-
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…
-
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…
-
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.…
-
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" ?
