-
Understanding Oracle Payroll Element Mapping
Hello Experts, I'm seeking information on Payroll Element types (salary, basic pay, NI, tax, etc). Can you guide me on where to find a table, view, report, or configuration that shows how these payroll element types are mapped to categories such as Total Deductions, Gross Pay, and Basic Pay? I'm a consultant, not an Oracle…
-
How to set Month filter to current month?
Hi, I want to give users the possibility to change month for displaying data, in order to let them see past data. I can set the month as a fixed value but in this way it doesn't update while time passes. I can also set the month by using an expression filter (YEAR(CURRENT_DATE) = YEAR AND MONTH(CURRENT_DATE) = "HCM -…
-
Help with Receivables transaction query
I'm creating a transaction attributes report, and I need to bring the CNPJ (Brazilian company identification number). I have two queries, which I will leave below, but I can't relate them because the LEGAL_ENTITY_ID column doesn't return any data. Does anyone have knowledge of this table? Q1 WITH ICMS_CALC AS ( SELECT…
-
24.R4: Which limited availability features will be included?
Release notes for 24.R4 does not appear to include the ‘limited availability’ features. How can we evaluate which of the limited availability features will be implemented with this major application release?
-
How to import Excel file for new data
In my environment I have cities and I can correctly view them in a map layout. I need to view them grouped as regions but regions are not in the system so I want to try to use an Excel sheet to group cities in regions. I'm not sure if this will help to display regions instead of cities in my map layout so I have 2…
-
Used same input parameters for the multiple Grid and need to avoid/revoke from my FRS Report
Hello Exports, I have Created the complicated Income statement (IS) in (FRS) and its included the 4 different Grid with in a report. While running the Income statement report, then the business need to pass the 12 same/repeated Input Parameters (4*3), now i need your support to avoid the repeated parameters.
-
FAW Data Augmentation - "Versioned Dataset" Option
Hi, We are working with the FAW data augmentation interface and noticed an option when creating a new fact or dimension to make the data set Versioned. I was trying to understand the benefits of the "Versioned Dataset" option being checked. So when this box isn't checked, the incremental/primary keys are used as defined -…
-
Which security roles are required to view any delivered FDI Dashboards around HCM Learning
Hello I believe there are some delivered FDI Dashboards around the HCM Learning Subject Area. Can anyone advise on which security Groups or Roles need to be assigned to users in order to have visibility to these Dashboards? In our new implementation, we are not seeing any Learn Dashboards. Thank you
-
OAC case statement with condition
Hi, Could you help me write the following case statement please : I have a "seniority date" which has been calculated in ADW and added to the HCM native dataset to the worker personal info folder dimension/folder. I'd like to find a way to have the number of employees (assignment count) between 0 and 1 year of seniority, 1…
-
Issue with tenure band
Hi, I would like to have the Assignment count column (Effectif global in French) displaying the total of the assignment and not the assignment based on the Seniority band that I've created in the FDI console (less than 1 year of seniority, btw 1 and 2 and btw 2 and 3). I thought that by creating a new metric using only…
-
Default inclusions for HCM Payroll Analytics Warehouse Balance Group
Are default inclusions for Payroll Balances still not supported in FDI? Reference: https://community.oracle.com/products/oracleanalytics/discussion/11065/faw-hcm-workforce-rewards-payroll-balances-offering/p2 Does this need an enhancement request on the idea lab?
-
BI Publisher data does not match OAC data
I created a report in BI Publisher, made the connection in FDI to BI Publisher, created a dataset using data augmentation, connected to Oracle Autonomous Data Warehouse to use the BI Publisher dataset, however, the data does not match in FDI. For example, the supplier AMAZON in BI Publisher registers 6 invoices but in FDI…
-
How to display map by region and not by city
Hi, I have this: but I want something like this: Problem is that regions are not in the system. How can I do it? Can we import them somehow? thank you
-
Create Primary Mailing Address Column
Hello, We're trying to create BIP Report that that extracts all employees address. One of the requirement is to create Primary Mailing column, output values should be (Y/N) to check if employees address is primary or not. Our SQL uses PER_ALL_PEOPLE_F, PER_ADDRESSES_F and PER_PERSON_ADDR_USAGES_F but we haven't figured out…
-
How do we enable the Duty Security Step in FDI/FAW?
Hi We really want to hide the seeded workbooks from our end users in FDI. We raised an SR about this and we were given this link: Oracle Fusion Analytics Warehouse: Configuring Object Security and Custom Duty Roles This references being able to add a Duty Security Step: "As a modeler, navigate to Console and to Semantic…
-
Is it possible to program an alert when a KPI exceeds a stipulated target?
For example, if we have an accounts payable KPI of 1M dollars, when this value is exceeded, is it possible to configure an email, SMS, or message via Slack to be sent so that the person responsible receives this alert?
-
Guidance Required for Configuring OTBI Reports with Multiple Subject Areas
Hi, We are encountering an issue in our current business requirement, which involves creating an OTBI report by utilizing multiple standard and custom objects across four to five subject areas. To ensure data availability, we are required to add a measure when incorporating these subject areas. However, we are facing…
-
Calculation Assistance - Person of Color Ratio
Hi - I'm trying to create a calculation which returns the person of color ratio for headcount in Workforce Core; however, I'm receiving an error. Any idea where I'm going wrong? 100*((Filter("HCM - Workforce Core"."Facts"."Workforce Headcount") USING "HCM - Workforce Core"."Ethnicity"."Ethnicity" in ('American Indian or…
-
'Ethnicity - All' Headcount for US legislation to include 'Two or more Races'
Based on the current functionality the only way to report on employee headcount by ethnicity is to use 'Ethnicity' which selects a primary ethnicity for each employee (Cannot use in the US because employee's do not select a primary ethnicity) or to use 'Ethnicity - All' which will inflate headcount numbers by counting…
-
Standard template is getting selected while custom template is default in Payables Trial Balance
In Payables Trial Balance report we have added one custom template which is the default one but sometimes standard template is getting selected automatically. This issue is an intermittent one.
-
Pre-requisites for Fusion SCM Analytics
Hi All, Can you please share the Prerequisites for Fusion SCM Analytics? Thanks & Regards, Vivek Gautam
-
seniority tenure range issue
Hi, Instead of using the FDI manually setup tenure bands that does not give me the result I'm looking for or the flixibility I need, I wanted to create a different metric for each range I wanted. Seniority from 0 to 1, From 1 to 2, From 2 to 3. I then created my first metric. This issue I'm facing now is as follows: If I…
-
Where can we find the documentation about the datamodel of a Subject Area?
When adding an Attribute in FDI using Semantic Model Extensions (SME) we have to understand the datamodel of the Subject Area. Also when we try to combine data from 2 Subject Areas with a Common Dimension and a Fact from both Subject Areas we often get wrong values (Facts) or the values of all rows are the same. To solve…
-
Numbers in map
I have this setup: In I can see numbers if I go on top with mouse: So why my map has only city names and not numbers? As far as I know this is driven by "Data Label Position" which is "Center" like highlighted above
-
Why my metrics disappeared from my views?
The customer says that the environment was untouched but suddenly all my metrics were removed from my dashboard. Can someone explain what could be the cause? Thank you
-
How to get other fields or more information from ERP fusion modules
I have the following business need: We want to create an AP report to have consolidated information when preparing payments. This report contains detailed information about the supplier, invoices, payments, etc. I have tried to make this report with the subject area: "Financials - AP Invoices" but it is evident that all…
-
Groups/Roles flow from ERP Fusion to FDI
We have removed groups from user in ERP fusion environment. But those groups are still assigned to user in FDI. Wanted to know is there any specific job which runs and update the groups. We are running Security Configuration Option functional area as part of the incremental load in pipeline. But it has not captured the…
-
Hi All, Good day! Is there way in FDI to connect to Oracle Accounting Foundation Cloud Service AFCS
Is there any feature in FDI to connect to Oracle Accounting Foundation Cloud Service AFCS
-
Purchase Requisition Details in CAA
Hi, Is Purchase Requisitions details are not available to configure in CAA? We can see PO's, Invoices and other details but not Purchase Requisitions. Regards, Shiva
-
Tenure band ranges
Hi, When we set up ranges for the tenure band that are going to be used in reports, do we only have 1 choice ? What if my client wants to have 2 different reports with 2 different ranges ? For ex 0-3 and 3-10 in one report and maybe 0-2 and 3-5 in another one ? It seems like I can configure only one option. Regards,…
