-
How to fetch history data for an employee through HCM - Workforce subject area
Hello Team, Client has a requirement to check on month on basis where there was a change in Department, he would like to see the history of changes with respect to department change for an employee. All effective dated rows of the employee. However, HCM core subject area is always giving the latest effective dated row…
-
Real Time Query Management tool in oracle fusion
Our client has expressed interest in a real-time query management tool within Oracle Fusion to facilitate internal communication. They are seeking functionality akin to WhatsApp, which would allow for seamless, immediate communication without relying on email for queries and issues. Could you confirm if Oracle Fusion…
-
Analytics: Oracle Fusion AI Data Platform Guidance Office Hours for 2026
📌Join the Fusion AI Data Platform Guidance Office Hours for 2026—your dedicated forum to get FAIDP (formerly, FDI) Implementation questions answered! The CEAL FAIDP Team hosts these 1 hour sessions to provide a forum where you can engage in discussions with implementation specialists and get your questions answered. The…
-
How to edit groovy script and test in Pricing algorithm?
-
Project Execution Management - Operational Milestones
I am trying to report on operational milestones in FDI. I can see the execution tasks feeding into the DW_PROJECT_ELEMENT_D table. However, those same tasks do not seem to appear in the DW_PROJECT_PLAN_LINE_DETAIL_CF table. I'm assuming they do not feed in because they are operational, not transactional. They do not have…
-
Fusion SCM workbook new schedule option in FDI not displaying
Hi Team , The user has service administrator access and read/Write permissions on the workbook. However, while attempting to create a schedule for the workbook, the "NEW SCHEDULE" option is not visible under the Schedule tab. Could you please advise how to enable or activate the scheduling option? Is this feature enabled.
-
How to apply group by on a column in OTBI in Oracle Fusion Cloud?
Hi everyone, I am working with OTBI in Oracle Fusion Cloud and I need to group by Creation Date (Subject Area → "- Supplier Organization"."Creation Date") one aggregated measure - SUM(Number of Suppliers) one non-aggregated attribute - Creation Date TIA, Nkhil Y
-
How to Drill Down from FDI to GL Journal?
Hi there! Looking for the syntax to drill down from FDI to a Journal Entry, as well as the drill down to a Subledger Transaction. Does anyone have the syntax for this drill in FDI? Sincerely, Kat Simkiss
-
Data not getting inserting after data refresh in DFF and Augmented tables
Hi , We have been facing this issue recently where Data is not getting inserting after data refresh in DFF and Augmented tables in SCM/ERP. All the DFFs are BI enabled in fusion. Quick response would be grateful. Regards Dharmendra
-
HCM - Talent Acquisition Subject Area
I have a request to add these two columns: the employee being replaced and requisition comments in Talent Acquisition SA.I looked for them, but they don’t exist.
-
We have to implement NSAW roles security by filter like vendor, customer, but we are unable to see
In Security of NSAW, I can see only these 4 assignment, I want vendor,customer and item based assignment as well so that specific can see relevant data. How can do that role based security?
-
Granularity Error When Adding Candidate and Incumbent Person Names in HCM Succession Management SA
I have a report in FDI that uses the HCM Succession Management subject area, and when I try to add from the candidate column the Person Full Name and from the incumbent column the Person Full Name, I receive an error saying that the report is attempting to combine dimensions at a level of granularity that doesn’t exist in…
-
How to schedule a report in FDI?
I want to schedule a report but all I got is this: Why?
-
The database mappings of some of the BICC VOs are not present in the list released by Oracle.
We have configured Oracle BICC to extract HCM data. I am trying to find the mappings between VOs and tables. The below support note Doc ID 2506210.1 provides list of HCM VOs in a spreadsheet but some of the VOs in BICC are missing from this list. Could you please help where I can find information about these VOs.…
-
List URL Data Action Displayed in Both Toolbar and Right-Click Menu FDI
Is It Expected Behavior for List URL Data Actions to Appear in Both Toolbar and Context Menu in FDI?
-
Backend tables to get if an approver added manually and then gets removed from the approval workflow
We have a requirement to create a report that will allow to see if an approver that is added manually gets removed from the approval workflow. We cannot see that approver in transaction console. We need to know if it is possible to pull this data. If yes, please advise on backend tables/report/mechanism to see this info.
-
FDI Managing Application Roles/Groups - Can we buid a hierarchy?
Hello, We're deploying FDI and we're trying to clean up our security management. The Target We'd like to be able to manage our employees through parent groups like "HR Analyst" instead of it's child groups like "HR Analyst - LE". The Details We have a lot of specific Duty Roles that determine the type of access a user has…
-
Cannot edit OOB Oracle workbooks even after placing in Custom folder?
I am copying and pasting (also tried saving as after editing) the OOB Oracle content workbooks into a custom folder that we manage in the catalog. The simplest of edits like changing the defaults prompt values, even though saved successfully, don't actually take. If I close after the changes and reopen the custom version…
-
How to view KYT Ratings as separate columns in from "HCM - Talent Profile Trends" Subject area
We have a requirement to view KYT Ratings in a single view as separate columns for each Section Name. What would be the solution approach to visualize KYT Rating section names as separate columns in from "HCM - Talent Profile Trends" Subject area ? Section Names & Ratings are coming from a same Table column mentioned below…
-
Pipelines for Oracle EPM - Planning and budgetting not refreshing
We are trying to configure a daily data refresh in the Pipeline Settings for FDI to Oracle Analytics Cloud with the preview feature "Oracle EPM Planning and Budgetting". The data connection is working fine, metadata gets refreshed when requested and testing the connection also works successfully. However, the refresh of…
-
Adding Supporting References to Configurable Account Analysis (CAA)
I’m working with Oracle FDI's Configurable Account Analysis (CAA). Currently, I see that supporting references are not directly available in CAA, they can only be viewed through the relevant subject areas. My question is: Is there a way to integrate supporting references into CAA reports? Could this be achieved through…
-
Signature in the report (BIP Rtp template)
I need to store authorized approver signatures in a cloud location and display the correct signature image in an Oracle BI Publisher RTF report based on business logic (e.g., department, cost, approval level). ** Oracle BI Publisher (RTF template), Oracle ERP Cloud (Fusion) ** Display the image conditionally using…
-
Bank reconciliation: how to delete check entries in Cash Management when a check is cancelled?
Is there a way to delete cheque entries in Cash Management when a cheque is cancelled? Currently, cheque entries are posted via AHCS, which transfers the entries to the GL and finally to the Cash Management module. When a cheque is cancelled, in Cash Management, when you want to perform the accounting reconciliation, the…
-
FAW EBS Adaptors
Summary: Is FAW ready with EBS Adaptors? Can you please provide more details on it like Does it pump EBS data into FAW data model or in Custom Schema? Does it include reporting? What modules are in scope from EBS, version?
-
Deeplink field not available on some Datasets such as "Financials - AP Invoices". 25.R4
The deeplink attribute is supposed to be part of various financials datasets. We are on 2025.R4, and I do not see these fields. What do we need to do to see these attributes. See Note: https://us.v-cdn.net/6037859/uploads/6M1HM36MZLWX/fdi-erp-customer-connect-application-release-25-r4.pdf
-
Getting the previous year from a parameter
I want to show the budget for the previously selected year. I have a parameter "paramYear" that is SELECT "Financials - GL Balance Sheet"."Time"."Fiscal Year" FROM "Financials - GL Balance Sheet" WHERE "Financials - GL Balance Sheet"."Time"."Fiscal Year" = EXTRACT(YEAR FROM CURRENT_DATE) I want to use this in another…
-
As an admin user in Oracle Fusion Data Intelligence, am I able to view another user's folder data?
Hi Everyone, I am an admin user with full access in Oracle Fusion Data Intelligence. I would like to confirm whether it is possible for me to view another user's folder data in the system. In the Content Management section, I am able to see all workbooks and folders. However, when I try to change the ownership of any item,…
-
Add Expand - Collapse option in Excel Templates
Hello, We currently have a requirement to add an expand/collapse feature within a report's output. We plan to use an Excel Template to design the report's layout. I would like to know if it is possible to create expandable/collapsible groups in the report output using the native Excel grouping feature found under Data tab…
-
Excluding Adjustment Period from the forecasting periods
We have a financial report where we are using standard forecasting feature to forecast the next 5 periods. The calendar runs from Jan (period 1) to Dec (Period 12) and there is an Adjustment Period (period 13). Having adjustment period 13 very common in the financial setup. When we are using the forecast functionality it…
-
Is there a way to get the difference between 2 rows as a Grand Total
I know that the msum function can get that, but I need to display it as a column total not another column. For instance using the Financials -GL Balance Sheet Subject Area and using Fiscal year Fiscal Year #Cash 2024 50,000 2025 48,000 Grand Total 2,000
