-
Has anyone been able to map EBS tables with Fusion PVOs?
What are some practical mapping strategies that can be used to map EBS tables with Fusion PVOs? Please advise if anyone has worked on this activity before.
-
FDI Deployment Issue: Environment Bundle Running Indefinitely
The Environment Bundle deployment (41 MB) has been running for over 20+ hours with no visible progress, no percentage/status updates, and no option to cancel the operation. Additionally, the Offerings page is empty, and no Data Pipelines are visible, so it is unclear whether the deployment is actually progressing in the…
-
Prompt for column not working with Logical SQL
I created a Logical SQL query in OTBI, and one of the returned columns is Business Unit. I wanted to create a prompt based on this column, so I configured the Business Unit column in the analysis as equal to a Presentation Variable named p_business_unit. Next, I created a dashboard prompt for the Business Unit column and…
-
For Financials category, doesn't FDI manage SCD type2 behavior ?
Need a help on understanding financial category maintainence in FDI, in case of any update in any account will my previous financial category doesn't remain in ADW database.If no, Is there any way to enable this nature in FDI.
-
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
-
Migrating a dashboard with a new Local Subject Area puts the LSA in Catalog
We found that after the 26.R2.P1 upgrade patch, when we migrate a report or dashboard from our development environment to our UAT environment any new Local Subject areas that we attached to the report are being put in the Catalog section instead of under Data. Previously any LSA's moved to a new environment would be placed…
-
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.
-
Oracle Analytics AI Assistant: Indexing Custom Calculations
Hello everyone, we are trying to activate the Oracle AI Analytics Assistant for creating visualizations in our workbook. We followed all the steps mentioned in the documentation but we are facing the following issue: We are only able to index the "standard" subject areas to the tool and not our custom calculations. In…
-
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…
-
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 guidance to retrieve and display Oracle ERP AP invoice attachment images directly within FDI.
Customer have implemented seeded deep link feature in FDI to navigate from FDI reports to oracle ERP fusion pages. however the current solution requires the FDI user to be authenticated and authorized in ERP fusion to access the target page and access the invoice attachment image. Our business requirement is different. We…
