-
Logic behind Workers with Active Profiles
Hi, We are validating FAW reports against Fusion HCM and we need to know what exactly oracle is considering for active profile in FA. Please share the logic behind Workers with Active Profiles. Navigation: People Leader's Dashboard-Talent Profile Overview-Workers with Active Profiles. Regards, Hitha
-
Can we Set the Multiple default values for BIP Report
Example:- Set the default value for the parameter "Person Type" to the following: Selected: Employee, Expat, Fixed Term Employee, Intern, Retirement Term Employee, Specified Term Employee, Third Party Employee. Not Selected: DPP/DPC contracts in Czech Republic – ONLY, Seasonal Worker Current Behaviour: 1)Default Value…
-
How to make the BI Report column Action Link work when the report is sent via BI Agent?
-
FDI Connectors General Availability
Hi All, I see that all the available connectors in FDI are under preview mode and are not suggested to use in Production. Could you please confirm when these connectors would be generally available in the coming releases. Thanks, Nagesh Manda.
-
Unable to Archive BICC Files in UCM daily
Hi Team, We currently have BICC configured in our application, and daily files are being uploaded to the UCM server. The UCM server retains the last three months of BICC files. I would like to know if there is a way to archive these files daily at a specific time. Any input would be greatly appreciated. Thank you! Regards,…
-
SEC_SECURE_BY_OBJ_MEMBER_USER limitations
Hi, I've been experiencing limitations on some common attributes like Legal Employer, and my client as well. I have another account user who is not experiencing these limitations at all and I don't know how to fix that ? Any idea or steps to take ? Thank you. Regards, Lauriane
-
Which data do i bring from ERP to report on resource utilisation in FDI
We have fresh install of FDI and I need to report on the resource/employee availibility/utilisation. With OTBI, I can use Project Resource Management - Resource Management Real Time subject area. However, in FDI this does not axits as Funtional area and i can not see it in the Suplemnatry data either. Is above subject area…
-
AVG Calculation not calculating as expected in FDI.
I have written the below calculation to calculate Tenure for my workforce and when this is added to a table the calculation populates as expected. However, when I try to average the calculation, it does not return the expected outcome Is anyone able to assist with how this may be corrected? I have also tried using Facts -…
-
Convert FDI Workbook Tables into Datasets
What is the most direct way to convert a table that a user has created within a workbook into a standalone dataset? I understand the table visualization can exported to csv/excel and uploaded via 'Create Dataset' - however, a method to complete this entirely within FDI is preferred. I am exploring Data Actions, but each…
-
Recruiting - Opportunity Market Place Real Time to FDI
As part of the new 25R release there is a new subject area we enabled Opportunity Market Place - Gigs - However, this doesn't include the Gig preferences that a seeker set for example Job Interest. Though somehow the HcmTopModelAnalyticsGlobalAM.HcmRecOppMarketplaceAM.MPSeekerAlertPrefPVO contains the preferences - there…
-
How to create a connection between Google BIG Query and Fusion Data Intelligence
Hi, Customer is looking for reports using data from different sources like ERP and Google BIG Query. Idea is to bring the required data from augmentation and prepare a subject area from Semantic Model Extensions to build reports out of it. We checked in the documents for Third Party Connectors we don't have a connector for…
-
Best way to get data from 'Standard Lookups' (FND_LOOKUPS) in Fusion into Fusion Data Intelligence
What is the best way to get data from 'Standard Lookups' (FND_LOOKUPS) in Fusion into Fusion Data Intelligence? We are creating a procurement dashboard in FDI and we'd like to be able to map cost centres to business lines and business leaders. The team is planning on storing this mapping in Fusion in the FND_LOOKUPS table.…
-
Purchase Order Line Description column not available
Our team noticed "Purchase Order Line Description" is not an available field in Procurement - Purchase Orders subject area or any other procurement subject area. Is there a plan to add this field? It would be extremely helpful for our team as the PO header description doesn't typically provide line detail.
-
FDI - Remove Export Options in DV
Is there a way to remove the option to export data to CSV/Excel within a DV analysis? I know that you can remove it from dashboards individually but is there a way to turn it off globally? Ideally there would be the option to enable/disable it by role.
-
I've encountered an issue when trying to create a table by using new field but, it no data displayed
Hi all, I added a new field called "Probation End Date" under the assignment information in workforce core subject area. That field is displaying data correctly. However, I've encountered an issue when trying to create a table that includes any other field along with this new one. Unfortunately, no data appears in the new…
-
ADW synonym tables
Hi, Ist there any documentation detailing all the native HCM tables in ADW (FDI product) in the synonym folder ? My client is asking how and where he can find some info, and I think it would be useful for him to have an Oracle documentation with the synonym tables details. Thank you in advance. Regards, Lauriane
-
Filtering by Employee in Expense Transactions Real Time Subject Area
I came across this: Document 2501076.1 Has anyone been able to apply and have it resolve their issue? I've followed it but my parameter drop downs are still FirstName LastName instead of LastName, FirstName like it needs to be in order.
-
FDI: Timestamp column values are not getting extracted during BI Publisher Data Augmentation
Hi, I am trying to utilize the BI Publisher data in FDI. I have created the simple BIP report and trying to load that data using data augmentation. But when I execute the step, the data got loaded successfully. But for the timestamp columns are loaded with null values. Could you please help me on this?
-
FDI De-Provisioning
Hello, Customer has provisioned FDI in a wrong tenancy. Currently, only the non-prod instance have been provisioned. Therefore we are seeing "0 non-prod instances are available", and "1 prod instance is available". Questions: How to de-provision the non-prod instance? Is it as simple as just deleting the non-prod instance?…
-
How does FDI handles the HCM organization hierarchy restructure
There could be scenario in HCM Fusion where the organization hierarchy might be restructured. I am sure that FDI data will also be refreshed according to the new organization hierarchy structure. But want to understand if the history of organization hierarchy will be maintained or it will be only the latest organization…
-
Lease Accounting in FDI - ETA?
Hi, Does anyone know when Lease Accounting will be included in ODI yet? I cannot find anything official, only a vague 'Lease Accounting feature is on ERP future roadmap'. Much appreciated! Thanks, R
-
Filtering different datasets with a common attribute Expression Filter vs Regular Calculation (Case)
Current Version: FDI 24.R4.P2 / Oracle HCM Cloud 24D (11.13.24.10.0) Context: For a simple / proof of concept type dashboard, we want to drop in some subject areas and CSV data sets that are pretty disparate (not joined). They have a few fields in common, like Business Unit. Question: Is the expression filter + parameter…
-
I need to know the key column information to be associated with the OOTB subject area.
I need to know the key column to be tied to the OOTB subject area. I want to create a custom subject area in the semantic model extension based on the OOTB subject area definition. It is difficult to define in the Semantic Model Extension because the definition of the Dimension/Fact binding settings (inner join , left…
-
FDI access for Non-ERP user & support for Essbase cubes in Semantic model
Hello Team, I'm reaching out to inquire about the recommended approach for granting system access to individuals who are not ERP users. Should we utilize IDCS for this purpose, or is it preferable to define a custom role within the ERP system and then associate that role with a predefined application role (such as author…
-
FDI Group Calculation Limits
Can anyone confirm if there is a limit for the number of Group Calculations that can derive from one another in FDI workbooks? For instance, I have a series of Group Calculations that roll up specific account codes. Then I roll up these Group Calculations into description titles via another Group Calculation. When I try to…
-
user not able to access the report from the dashboard with ssp access
Summary: User is getting the below error once he clicks on the report link from the dashboard, user has the ssp access Content (required): Error View Display Error Please have your service administrator review this error. Error Details Error Codes: ACIOA5LN Unable to access the report.png Version (include the version you…
-
Leveraging Oracle Fusion Data Intelligence Data Validation Functionality
Ensuring the completeness, accuracy, and integrity of data after loading the data from Oracle Fusion Cloud Applications to the data warehouse in Oracle Fusion Data Intelligence is paramount. The Data Validation feature is crucial for reliable business intelligence and informed decision-making. Below video highlights best…
-
Overall Benefits of Oracle Fusion Data Intelligence Vs. Fusion OTBI and BI Publisher Data Models
I'd like to hear if users see a big benefit to subscribing to Oracle Fusion Data Intelligence vs. just having the pre-delivered Fusion OTBI and BI Publisher that is available to Fusion ERP customers? The data sheets look interesting but overall it reminds me of OTBI so I don't know if it is just more subject areas or more…
-
Linked parameter for multiple departments not working correctly?
I have an overview page that looks at both ERP and PPM data. We need to have a department filter on this page so that our users can look at specific departments rather than the whole entity. I had an idea to create a parameter that binds the value of the department for the ERP department filter to the values in the PPM…
-
Does FDI allow user input exchange rate in Pipeline settings?
What do these options represent? Is the last 'User' an option to manually enter the exchange rate? If so, where can this be done?
