-
Hi All, Please help me to find the exact table mapped to the demand planning data from Oracle Fusion
Demand planning objects data is not matching with back end tables. Please help us program behind this calculation and back end tables to build BIP Report.
-
Add Filteration to "Existing Time Cards" to filter the Status of Time Card
Dear Team, We have received a proposal to add a Status filter to "Exisiting Time Card" (Me > Show More > Exisiting Time Cards). Because by using that Employee can filter out "Incompleted" time card or "In Error" time card and do the necessary fix by him/herself. Which would be very helpful and efficient during Payroll…
-
Give Full Control over Datasets to Application roles not working
Hi I am trying to make sure, that all of our datasets can be edited by all users, who has the "Modeler" application role, as it is only the BI team who has that… But for some reason, when I add the Modeler application role to a datasets access menu and give them full control, nothing happens… No user, that has the role,…
-
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
-
How to get started with FDI
Hi Experts I'm a beginner and my company is asking me to learn FDI ad i don't know how to get stated. Please help me How to get started How to get a free instance to practice how to create a first report how to use it in fusion like those basic questions
-
FDI People Leaders dashboard
In the FDI People Leaders dashboards, on the Hires and Terminations pages, the graphs for Hiring Trend by Gender and Termination Trend by Gender, as well as the Hiring Predictions for the Next Three Months and Termination Predictions for the Next Three Months, are not displaying the correct hiring or termination…
-
Is there a REST API to get the report built with FDI ?
Hi Experts Is there a REST API feature in FDI to get the report like we have for BIP report ? we want to get the report built using FDI using the API from Oracle Integration. Please help.
-
OTBI access query
Hi I have the access for Subject Area in OTBI but the metrics are showing zero while creating report you had any idea , what kind of access is missing for me
-
Anyone else having issues clearing out Budget and Milestone Data in FDI?
We are deleting budget data in fusion applications, but the deleted data is still showing in FDI. Anyone else having this issue? We have never had this issue before.
-
Unable to delete the published main branch step in user extension from semantic model extension.
We've encountered an issue with the session variable we created in the user extension and merged with the main branch. Unfortunately, it isn't working as expected, and we're trying to delete it. However, we keep running into an error that states: -Steps belonging to published version in master branch cannot be deleted. We…
-
Is there a way to hide the drivers license information under person management > person > Document?
Is there a way to hide the drivers license information under person management > person > Document?
-
Oracle FDI - Resume/Profile Matching with Open Requisitions
For resume screening based on current open requisitions for Oracle Recruiting Analytics in FDI, Do we have any available subject areas or charts in FDI? like profile or resume matching applications count and analysis trends for open requisitions. Mainly looking for candidate resume skills, etc matching for open…
-
Oracle FDI – HCM security
Hello Everyone, We have a requirement to restrict all access to C-Level executive data (e.g., CEO, CFO, CHRO, etc.) within Oracle Fusion HCM FDI Analytics. This restriction needs to apply across all subject areas and attributes, ensuring that both consumers and authors cannot view or interact with any data related to…
-
Locate Offer Salary
Hi, For the context, we are using HCM 25A. I'm trying to query the offer salary amount in the job offer. I have checked IRC_OFFERS, and it doesn't contain the information. Using CMP_SALARY doesn't give me the initial offer salary either.
-
BI Publisher Reports pulling blank and/or timeout errors with no modifications done
Wondering if anyone has run in to similar situations. We have custom SQL/BI Publisher Reports that are encountering unexplained issues. For example reports that have been in place for an extended period of time are now randomly pulling blank data or experiencing time out issues for users. In most cases there have been no…
-
How do I get the Public holidays details in FDI
One of my requirement to calculate working days. for that, I need to exclude week ends and public holidays. But, In FDI, I don't know, where to get that public holiday details. Can anyone assist me on this?
-
Users can't see data or only their information
Hi Experts, We are experiencing a very unique issue. Out users can't see data or only their information. We validated that there are no security assignments at user level, or security configurations on data application roles. What can cause this? Any insights are appreciated.
-
Limitations on FDI / OAC Narrative views for row counts even when set to display a single row
We have some analyses in FDI's OAC Classic instance that are getting Maximum Row Limit Exceeded errors on Narrative views that are set to only display a single row. The standard format for the analysis has a narrative at the top that displays the row count which is a column that has a formula of MAX(RSUM(1)).. below that…
-
Facts columns are missing in local subject area HCM - Diversity Analysis
I am not able to see fact values under HCM - Diversity Analysis . when I try to add the annualized full time salary, then data is not visible Example 2 : after adding Fact column : None of the fact column alone itself is not working:
-
Summary of AI capability in FDI
Hi All, I was wondering if there’s a cheat sheet or a one-pager available that outlines the key built-in AI capabilities within FDI—particularly in the context of Fusion ERP, HCM, and SCM. It would be helpful to have a quick reference to understand what’s available out of the box. Thanks in advance!
-
Semantic Model Status Skipped - Data Augmentation
Hi - I was recently working through data augmentation and noticed that almost all of the data augmentation currently configured are displaying a status of to skipped due to issues with the joins. I'd like to get the joins fixed however, i'm running into issues finding documentation to correct. Has anyone come across this?
-
How to create a date from a period field in OAC Dataflow (function DATE not available)
Hello everyone, I’m currently working in the Dataflow menu of Oracle Analytics Cloud (OAC). I’m trying to transform a period field that I derived from dates, in order to obtain a proper reference date in the format DD-MM-YYYY, starting on the first day of the period. For example, for January 2025, my current field value…
-
Expression Filter to Filter to MAX Date
Hi, Request any help the possibility for an expression filter to filter to the MAX Date. "SCST - Savings Impact Reporting"."Time"."Snapshot Date"
-
What's wrong with this metric?
I have this metric: SUM( CASE WHEN "HCM - Workforce Core"."HR Action"."Action Code" in ('HIRE','ADD_CWK','REN_CWK','ADD_CWK_WORK_RELATION') AND "HCM - Workforce Core"."Assignment Information"."Primary Flag Code" = 'Y' AND "HCM - Workforce Core"."Assignment Information"."Assignment Status Type Code" = 'ACTIVE' THEN 1 ELSE 0…
-
Using data Validation feature, when there is a mismatch of counts how to get the OTBI query
Newly configured Data validation feature and we are successfully able to get Detailed validation and scheduled validations. For some of the metrics when we were doing Detailed validation there was a mismatch and I am able to get the FDI SQL query in session log but , when we login to source HCM OTBI not able to see query…
-
How to join GL Account Analysis and AP Payments Subject Area
We have a workbook using GL Account Analysis and AP Expense subject areas. We use this to analyze our GL and AP SL data together. We want to be able to pull in payment/paid date of the invoice. When we try to add AP Payment subject area (because it seems to be the only one with payment date), we either get a query error or…
-
What is the purpose of "Reload Data" and "Refresh Data" actions
When updating descriptive flexfields in FDI > Custom Data Configurations, there are actions to Reload Data or Refresh Data. What is the purpose of these actions? I cannot find documentation on it.
-
Query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groups
Can someone please help with a Oracle Fusion SQL query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groups. I found the attached as a start but am only finding the element names of Regular Pay and Regular Pay Earnings data. Maybe our system doesn't have anyone with PTO hours in the subset we…
-
How to Identify relative column on OTBI side for an FDI Column
Trying to test latest release updates on Oracle HCM . HCM - Talent Acquisition subject area has these enhancements: New Metrics - New metrics related to openings filled, openings to be filled, requisitions with and without active offers on it, and days since a requisition is open is added to the Facts - Job Requisition…
-
Custom Group calculation isn't subtotaling in pivot table
My Group calculation of JE Classification is working fine to group things together, but the subtotal function is bringing back the first value instead of summing it. The Group calculation is set as Text type, but i don't see any method to change that, and really it is text. Any way I can get this to display with a summed…
