-
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…
-
Need query for Change Order History Tab
I need query to extract these columns as mentioned in the screenshot.
-
OAC/FDI preview feature "Salary Basis Snapshots" trouble
we are on the most recent release in OAC/FDI (25.R3.P1) and enabled the feature "Salary Basis Snapshots". I believe the feature was turned on correctly as I now see the folder for Incremental Components in the subject area. However, I cannot find any details in the subject area for Simple Salary Components which is what I…
-
How to connect Microsoft SharePoint using Fusion data intellegence
Is there any connecter available in FDI console or DV connection to connect Microsoft SharePoint
-
FDI License Report
We are wanting to create a report that will list all active FDI users and the license they are consuming. I know there is the Common - Usage Tracking Subject Area, however this lists all users even if they are no longer active. Is it possible to pull this data from a table in the ADW and expose this in FDI so that we can…
-
Query on sequence of Implementing HCM in Fusion Data Intelligence (FDI) ?
Include in daily report breakdown this step is to get up to date data for Absence Management Functional Area (1) Creating Balance groups for Payroll Balances Functional area (2) Setup labels for costing segments in Cost Allocation key flexfield for payroll costing (3) Refresh Manager Hierarchy (4) Creating a user to…
-
What all access do we need to evaluate FDI Installation configuration ??
Hi Everyone, We are implementing HCM Application In FDI . The problem is FDI Instance is already provisioned by some other Vendor , Q1) How can we validate the FDI Installation configuration ? Q2) What all access roles do we need to have , to verify all these ? Q3) What all things should I keep in mind while evaluating ?…
-
Efficient way to assign FDI licenses to Users
Hello All, What is the most efficient approach to assigning FDI access to several thousand users, given the complexity of our role structure? The main challenge lies in the fact that we use 'Custom Roles' which must be mapped to 'Application Roles'. Additionally, each user may be associated with multiple custom roles,…
-
Is there is a published summary of the Oracle FDI AI capabilities?
I already have this information for Fusion Apps as it is published via the very useful link below. Is there a similar resource for FDI? https://docs.oracle.com/en/cloud/saas/fusion-ai/ Thanks, Paul.
-
Does the Content Explorer Dashboard in FDI include custom content?
The recently added Content Explorer Dashboard is very useful to show all the prebuilt content in FDI. Does it also show custom content? for example, will user-added key metrics appear here?
-
User getting access denied for Financial-GL Detail transaction subject area
One of our user created a report in FDI which was having data from Financial-AP Expense , Financial - GL profitability. Last week he added some filters on top of the report which pulled the GL Detail Transaction subject area, he is getting access denied error, and post that addition of filters he is not able to edit the…
-
how to get assignment work terms number in fusion data intelligence oac fdi
Terminated assignments not flowing to FDI, How to get the Terminated assignment details in OAC-FDI ?
-
How can I rename columns in PVO data augmentation?
I went through the effort of selecting all the columns I need and then renaming them so they wouldn't be these ugly, long names. After running the augmentation, it didn't even do it. Is this something that can't actually be done? Should we add and AI step so it can do "column beautification" to the process? similar to how…
-
Classic report with a DV dataset not working after migration due to ownership mismatch
Hi , We have an OAC classic report in FDI which uses a DV dataset (Created using DV connection to ADW Schema table) . This dataset was created by USER1If you read the session log , each column from the table is reference in the format . XSA('USER1'.'DW_X_AR_ALTYX_CASHREPORT_V')."DW_X_ALTYX_CASHREPORT_V"."ACCOUNT_NO_TEXT"…
-
Organization Hierarchy Availability in HCM Subject Areas
Organization Hierarchy is available in most HCM subject areas, however, it is not included in the Learning (generally available) subject area. Will this be available in a future release? Most of our HCM reporting aligns with our Organization hierarchy.
-
How to make Filters as mandatory in Redwood Purchase Requisitions page in Oracle Fusion SCM
the Redwood ‘My Requisitions’ page is not behaving in the same way as the Classic ‘Manage Requisitions’ page, both pages default the ‘Entered By’, but for the Redwood, if you remove this parameter all requisitions are visible, whereas with Classic you are mandated to enter other parameters. Is it possible to make parameter…
-
Is there a way to back up FDI tables and to reload the tables if a data refresh/reset is performed?
Is there a way to back up FDI tables and to reload the tables if a data refresh/reset is performed? Some of the tables in our source system have a data retention policy of less than 90 days. We are looking for potential methods to back up these tables or pipelines and then reload these into the system in the event that a…
-
How to show Indirect reportees to custom Line manager
We have configured custom line manager and custom HR role as mentioned in the blog below Setting Up Custom Human Resource Analyst and Line Manager Data Security Access (oracle.com) "Core"."Dim - Assignment Manager List"."Manager Identifier"=VALUEOF(NQ_SESSION."HCM_PERSON_ID") However, with this condition only Direct…
-
Agreement Amount for Past One Year metric shows in $ while expected in GBP
Hi Team, I've noticed an issue on the Purchase Agreement Analysis Dashboard under Procurement - Agreements Subject Area(ERP analytics). The Agreement Amount for Past One Year metric is displaying in USD ($) instead of the expected GBP (£). All other currency analytics metrics on other dashboards are correctly shown in GBP.…
-
Cash Management Subject area
Recently Financial Cash management subject are has been enabled in FDI, wanted to see if anyone has any out of box dashboard to share?
-
List of native HCM metrics in FDI
Hi, Do you know where I could find the list of the HCM workforce Core native metrics available in FDI through the pipe please ? With the details of what they stand for. Thank you very much. Regards, Lauriane
-
Supporting references in FDI Local Subject areas
Hi Is it possible to get supporting references in to FDI Subject areas? I have managed to augment some, but they are only showing the description, not the value of the supporting references… For example I get the description "Project Number" but not the actual project number. Has anybody had any success with this? Kind…
-
FDI to ATP Connectivity
Hi Experts, Wanted to check if you any documents / steps on FDI ( Fusion data Intelligence) connecting to ATP to develop the Reporting usecase. Does this require a loadbalancer setup ( any related documents) ? Regards Dheeraj
-
Termination date appearing in following Enterprise Period – FDI
When working on Turnover reports/visuals in Fusion Data Intelligence Terminations which fall on the last day of the month fall into the following Enterprise Period. I am aware this is how Oracle calculates terminations however, I am curious to understand how other companies are calculating their turnover data in FDI? Have…
-
Ability to connect from FDI to Private endpoint
We have an oracle database in another tenancy than the one where our FDI is. Could we create a connection to that database from FDI? The target is private DB
-
Oracle FDI- Profile Matching with open requisitions
I am looking to build recruiting analytics for candidate profile/resume matching with open requisitions in oracle FDI. Please suggest any inputs to build. I don't find seeded dashboard chart or subject areas to use for profile matching charts with requisitions. Thanks, Prasad
