-
Absence Adjustment value in the database doesn't match the front-end
I am using the Workforce Management - Accrual Real Time subject area, from which I am retrieving the "Front-Loaded Plan - Other Adjustments" field. The report is displaying adjustment values for some employees, even though no adjustment value is currently available for them in the front end. These values appear to be…
-
How do I get Project Cost Adjustments detail and history data in FDI?
Using the standard out of the box subject area(Project Costing), I am unable to get project adjustments data and history. For example, I would like to get all project cost transfers from project A to project B; including data such as transaction numbers to/from, project number to/from, creation date, transaction amount,…
-
How to prevent visualisation filter options from resetting when a data action refilters the canvas?
When a data action is used to pass values using an analytics link and then filter the linked canvas it also appears to reset the checkboxes on visualisations within that canvas which determine if the visualisation should be refined by those canvas filters. It seems the data action causes all visualisations on the linked…
-
How to trigger FDI data pipeline jobs externally?
Is there any way to invoke or trigger FDI data pipeline jobs externally — for example, via a REST API call, or any other integration method — instead of manually initiating the job from within the admin console UI?
-
We configured FDI Security (Users/groups) using Fusion IDCS. User group is not syncing properly in
We created licensed shell role in Fusion. When a user is removed from the shell group in Fusion, it is not reflected in IDCS. This is impacting security in FDI. Have anyone faces this issue while using Fusion IDCS combination ?
-
FDI - Custom schema recommended?
Using a custom schema for ETL and semantic model extensions instead of OAX_USER has been our practice for a while, based on guidance like this: FDI: Replicating access of OAX_USER for a Custom Schema The original blog we used to reference for custom ETL setup is now a 404, and we're finding a few other older articles have…
-
HOW DO WE GET ALERT INFORMATION IF ANY OF THE DATA PIPELINES GOT FAILED OR DISABLED.
Team, In FDI , how can we know if data pipelines got failed or disables or stopped to get the latest data from the source. Do we have any way other than manual monitoring and checks? Regards, Guru
-
AUTO DELETE OF TRANSACTIONAL RECORD IN FDI/FAIDP
Team, We have implemented a solution which needs a customization and created a materalized view on top of ADW. Now, Can we put this object for FDR or Priority refresh schedule? As we asked to manually refresh the object for the latest records updates. do we have a other solution?
-
HOW DO WE GET ALERT INFORMATION IF ANY OF THE DATA PIPELINES GOT FAILED OR DISABLED.
Team, In FDI , how can we know if data pipelines got failed or disables or stopped to get the latest data from the source. Do we have any way other than manual monitoring and checks? Regards, Guru
-
HCM Analytics
The prebuild dashboard in HCM Analytics is showing incorrect "headcount". We are off by 40%. It is showing some person headcount as 0. And it is not matching. However, the "computed headcount" matches. I am not able to figure it out how the head count is calculated. Based on the metrics calculation, - Headcount…
-
AUTO DELETE OF TRANSACTIONAL RECORD IN FDI/FAIDP
Team, We have implemented a solution which needs a customization and created a materalized view on top of ADW. Now, Can we put this object for FDR or Priority refresh schedule? As we asked to manually refresh the object for the latest records updates. do we have a other solution? Regards, Guru
-
AR Aging Dashboard Customization – Multi-Segment Grouping
Hello Team, Our client has requested an AR Aging dashboard. However, the required criteria combine multiple Chart of Accounts segments, including Cost Center, Business Line, Division, LOB, Product, and Receivables Account. Standard FDI Account Groups cannot support this requirement directly, as each account group is based…
-
FDI Subject Area fields Showing Absence Data Based on Current Manager Instead of Historical Manager
I'm building an absence report in FDI using a Subject Area and filtering by Manager Name (under Assignment manger list). I've noticed that when an employee changes managers, the report only returns absence records from the date they started reporting to the current manager. Historical absence records under the previous…
-
FDI CX -Opportunity Revenue Line:Resolving Registry IDs Across Sales Account Hierarchy
Hi Team, I am working in Fusion Data Intelligence (FDI) using the CX - Opportunity Revenue Line subject area and need some clarification on Sales Account Hierarchy behavior. My requirement is to display the following for each Opportunity: Opportunity ID Sold-to Customer Number Top Registry ID Parent Registry ID (Level 8)…
-
Is there any documentation available on OOTB Financial Categories
Is there any documentation available on OOTB Financial Categories in ERP GL, which eventually helps user to assign correct Categories to correct accounts in GL. Any descriptive Documentation would be really helpful in this sceanrisceanrio
-
What are the roles required for Fusion Service Accounts used to run BI Publisher Data Augmentation?
Hi, We are using BI Publisher data augmentation for loading FDI. We want to understand the roles that should be assigned to Fusion Service account.
-
Is it be possible to add drill-down from the Oracle AH screen to the OAC DV report
We know drill down can be enabled from Oracle AH to an OAC classic report through a deep link, but will this also work for an OAC DV report? We're working on a requirement and tested the configuration below, but it's not filtering my OAC DV report and it is based out of transaction Number.
-
Any idea for this Flow error?
-
Average Annual salary in the Salary basis Subject area is not giving exact results
Average Annual salary column/metric in the Salary basis Subject area is not giving exact results for the frequency 'Hourly'. Its working for Monthly but not for others. Kindly let me know how can we handle this. Also guide me how to extract the queries which are used for FDI Key metrics/facts. Thanks, Keerthana
-
Invalid Credentials after saving Pipeline
Under Data Configuration > Pipeline Settings I saved a new setting but got a message: "Invalid Credentials", "Data pipelines have been disabled fot BI Publisher". Why?
-
What are the different ways to access the Oracle ADW database without having the relevant User name
Is there a way to access the Oracle AADW database without being assigned the FAW Service Administrator role, using only a native database username and password with read/write privileges? If so, can this access be provisioned and managed dynamically?
-
Number of canvases in workbook based on filter selection?
Hi, Is it possible to create a workbook where the number of canvases displayed is dynamic - based on a user's filter selections? Use case: a general ledger budget v actual report where we'd like to show a canvas for each lowest level cost centre in the segment hierarchy based on the parent cost centre segment selected. For…
-
SKILL STORY DASHBOARD.
Team, Is anyone being aware of Skills related category details available in the Pre-built subject areas. I have analyzed the available Talent Profile and Market Place i could not be able to see it. Please share your comments. Regards, Guru
-
EXPORT LIMIT OF ROWS FROM OAC REPORTS INTO EXCEL IS BASED ON OCPU'S.
Team, Any workaround if customer wants to exort data from Oracle Analytics Cloud Workbook in to Excel. they have huge data hence i'm recommending to downstream the CSV format, but customer is morely using other foramts like excel , pdf etc. is anything mapped in roadline, Please share your thoughts and ideas. Thanks, Guru
-
Cannot find negotiation subject area in FDI
Cannot find negotiation subject area in FDI
-
FDI Position Management – Displaying Vacant Positions with Leader Security
FDI: How to Report Vacant Positions with Direct/Indirect Leader Security? We're looking for guidance on the best approach to report on Position Management data in Fusion Data Intelligence (FDI). Our primary requirement is to identify and report on vacant positions (positions with no incumbent assigned) and surface this…
-
Help Needed: Steps to Migrate Standalone OAC HCM Project to FDI
Hi Experts, Could you please help me understand the steps involved in migrating a standalone OAC HCM project to FDI? Any guidance or documentation would be greatly appreciated.
-
FDI Licensing Clarification: External Users, Third-Party Data Sources, and Public-Facing Analytics
Hello experts I am looking for clarification on Oracle Fusion Data Intelligence (FDI) licensing for the following scenario. Scenario An existing FDI customer would like to: Build custom data pipelines to ingest data from external sources (e.g., Salesforce, custom applications, and other third-party systems). Extend…
-
Oracle FDI to OTBI connections - is OAuth available?
We are currently using basic authentication when creating our Oracle FDI to Fusion OTBI Data Connection. We would like to move to OAuth based authentication as we have for our integrations to the Fusion web services. Is there a way to do this? Thanks.
-
FDI security: Read-only access on one subject area with authoring restricted to another for the same
Problem: In Oracle Fusion Data Intelligence (FDI), can a single user or role be granted differentiated access across subject areas such that the user has Read-only (consume) access to reports built on one subject area, while Authoring/Write access is restricted to a different subject area only? Concrete example: We have…
