Popular Tags
- OTBI 1,440
- Reporting 1,388
- FDI 1,102
- Analysis and Data Visualization 982
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 581
- Administration 555
- OAC 441
- OBIEE 433
- Analytics 400
- BI Publisher Data Models 353
- Security 292
- Answers 264
- HCM 262
- BIP 260
- Analyses 255
- Developers 244
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 189
- Report Output 184
- Fusion Data Intelligence 168
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Fusion HCM Analytics
Ask questions about Oracle Fusion HCM Analytics, the prebuilt cloud native solution for Oracle Cloud HCM. Get answers from human resource professionals on employee attrition, retention, talent acquisition and management, compensation, workforce diversity, and more.
Discussion List
-
I need a SQL Query to pull Hours and Wages by Day paid.The Periodic Payroll Activity report list Wages and hours summarized by process Date and element. Staff are able to view the Run Results by person and by day in the Run … -
Request for Legal Employer of Manager in OTBI AnalysisHI in the subject area "Workforce Management - Worker Assignment Real Time", I need to retrieve the legal employer of the manager. Is this possible? If not, is it availa…
-
FTE ReportingLooking to know if there are examples of good FTE reporting that comes out of the box from Oracle on the fusion or FDI side?
-
Cannot open or schedule a custom report. An error occurred while processing your request.Receive error message after 10 minutes when opening the report or scheduling it, even the parameter is not visible.
-
Count vacant positions in FDI using Position Managment Subject AreaWe need to get vacant positions through Position Management subject area. The business need is that : the position is considered as vacant if there is no incumbent or if… -
I need to pull detail data from tables populated by a payroll run.This includes taxes, earnings and deductions. I managed to get some of this information using OTBI and the subject Payroll Run Results Real Time, but I'm not sure all de… -
Sanbox keeps spinning foreverHi Everyone, I created a sandbox and performed my changes. I have submitted to apply changes and the apply changes step is spinning since couple of hours now. Why is it …
-
FDI HCM Security - AoR still requires Augmentation?For AoR Security, according to this blog post: https://blogs.oracle.com/analytics/post/faw-hcm-data-security-using-dept-hier-aor-attribute There are 2 augmentations requ… -
HCM Learning - Redundant item rating metricsWhat is the difference between the "Average Learning Item Rating" and "Overall Learning Item Rating"? the calculation logic sheet shows the same formula for both. Is the…
-
How can we get "From" and "To" Department Hierarchy in FAW workforce Gain and Losses Subject areaHi All , We are using workforce gain and losses subject area to build the promotion and demotion information including various Job and employee related attribute . This … -
Assistance with Costing Key Flexfields in Oracle Analytics (FDI)Hi Experts, We are trying to export person costing details in Oracle Analytics using the HCM - Workforce Rewards - Payroll Costing subject area. However, we are unable t…
-
What is the minimum information necessary to update contractsSummary: Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTR…
-
FDI HCM Position Time dimension not working with date value = 11/04/2025 current datefor our position management dashboard we cout our positions by date everyday. today in production while we try to count as of 11/04/2025 the dashboard shows no data. thi…
-
Logic behind Workers with Active ProfilesHi, 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 Worke…
-
Can we Set the Multiple default values for BIP ReportExample:- Set the default value for the parameter "Person Type" to the following: Selected: Employee, Expat, Fixed Term Employee, Intern, Retirement Term Employee, Speci…
-
-
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… -
ADW synonym tablesHi, 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,… -
Cities in France displayed in other countries when we use FDI MapDear team, We are facing an issue while trying to display our positions by city in the map. the data for some french cities are displayed in other countries. please see …
-
Oracle Fusion Cloud HCM Areas of Responsibility (AOR) Using custom contexts & custom securityWe have a use case to implement data security in FDI Fusion HCM Analytics for recruitment related dashboards by leveraging area of responsibility assigned to users in Or…