Global HR
Discussion List
-
Exported analysis output is not formatting correctly in ExcelSummary Exported analysis output is not formatting correctly in ExcelContent Hi Team, PFA catalog file of analysis. We have created an analysis which we use to pull dire… -
CEO direct reportee nameSummary CEO direct reportee nameContent Hi all, We have a requirement to pull CEO direct reportee name For eg. Get the name of manager4 Employee->manager1->manager2->man…Reddykrishna Chidella-Oracle 25 views 3 comments 0 points Most recent by User_2025-02-05-06-26-19-951 Reporting and Analytics for HCM -
Need query to get Termination or Resignation Requests pending for approvalContent Need query to get Termination or Resignation Requests pending for approvalMohamed Salah 1.1K views 5 comments 0 points Most recent by Mohamed Salah Reporting and Analytics for HCM
-
Inaccessible column: "Organization Hierarchy"."Level 01 Organization Name"Summary Error trying to access Org Hierarchy column with Employee roleContent Hi, We need to access "Organization Hierarchy"."Level 01 Organization Name" column through …Suresh Pallapothu 35 views 2 comments 0 points Most recent by Suresh Pallapothu Reporting and Analytics for HCM -
Starters as at Start DateSummary Data must be returned as at the Start DateContent Hi all I have a starters report that provides me with all the starters between two points in time however the d…Dawn Cawston - CPS 27 views 26 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
EEO reporting with the new check box system for Personal Details?Summary How are you getting around the removal of "Two or More Races" as an option? How are you adapting to multiple choices for ethnicity?Content Hi all, We recently up…CIT Shane 183 views 25 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
How to add a BI Report to a Fusion PageSummary This document explains how to add a report to an HCM pageContent How to add a BI Report to a Fusion Page This document explains how to add a Salary Range Analyti…Gail Langendorf-Oracle 472 views 4 comments 6 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …NusratB 92 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA) Can you please advise if possible to notify th…Bernard T 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Could not able to find the "Sequence" field in Checklist Real Time subject areaContent Hi Experts, I am trying to build a OTBI report using Checklist Real Time subject area but i cannot able to see the "Sequence" Field. Has anyone faced this issue?…Harish Vummidi 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Conditional formatting in Logical SQL OTBI reportSummary Conditional formatting does not reflect in OTBI report where Logical SQL is usedContent We have a requirement where we had to write a logical SQL query to show p…Akash Kiran Jana 62 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Denmark country specific HR reports and analyticsSummary Denmark country specific HR reportsContent Hi, Are there any Denmark specific HR reports available? Denmark is Tier 1 localization and expecting some seeded HR r…Anuradha T 16 views 1 comment 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM -
Rating ChangesSummary Rating ChangesContent Hi, I have created analysis, we have date parameter based on the passed date it will show the rating changes , But we need to add another c…Reddykrishna Chidella-Oracle 29 views 5 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM
-
LSQL Newbie questionSummary Trying to learn to write LSQL. Need assistance with the errorContent Hello all, I just started learning to write LSQLs. After going thro the training materials, …User_2025-02-04-15-06-22-759 41 views 2 comments 1 point Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM -
Bar graph drill down filtered on dateSummary Bar graph drill down filtered on dateContent I have built a bar graph that captures disclaimer status by action date. The drill down takes to a different OTBI re…User_2025-02-10-08-27-16-805 27 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Extract Content Id for the attachment from Document of RecordsSummary Extract Content Id for the attachment from Document of RecordsContent As per the Oracle document https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=…Sowdha Murugan 50 views 3 comments 0 points Most recent by AvishekNandi Reporting and Analytics for HCM -
How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DaSummary How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DashboardContent Hi Team, I want to move OTBI Report options (Ex…Mahendra 58 views 8 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
A parent for this record wasn't found. Use any of the four supported key-resolution systems to supplSummary While importing a Worker.dat file via HDL i'm getting the error : A parent for this record wasn't found. Use any of the four supported key-resolution systems to …
-
How to calculate tenure in jobSummary How to calculate tenure in job using OTBIContent Gurus— I need to calculate the time in job per employee, for the current job (not previous jobs). I searched the…justin.field-Oracle 325 views 6 comments 3 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Worker Age in Workforce TrendsSummary What to use to calculate age in Workforce TrendsContent Hello! I've been calculating the Age Bands by using a formula to gather the difference between the date o… -
Trying to sort the month prompt on a dashboardSummary The prompt for Month using a Case to convert to month names instead of integer is now sorting alphabetically by month instead of by integerContent Hi I have look…LynneLBL 26 views 2 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee Distribution Summary ReportSummary Employee Distribution Summary ReportContent This sample report gives an insight into the different types of Source System Owner along with the total employee rec…AshishERPCloud 46 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get Manager and it's repotee details using OTBI AnalysisSummary How to get Manager and it's repotee details using OTBI AnalysisContent Hi Experts, I have a requirement in OTBI, I want to build a Manager report. It has to fetc…User_2025-02-05-04-17-04-394 64 views 8 comments 0 points Most recent by Mahendra Reporting and Analytics for HCM
-
D&I reporting - what works for your organisation?Summary D&I reporting - what works for your organisation?Content Hello all - over the years I've helped lots of customers with many diversity reports, but the world is m…Caroline Gladwin-Oracle 81 views 2 comments 1 point Most recent by User_2025-02-05-07-43-29-505 Reporting and Analytics for HCM -
HCM Last date a vacant post was filledSummary is there a way to report out when a position was last filled which is currently vacantuser1028626 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to have Pivot in BIP based on a Logical SQL Pivot OTBI Report.Summary An OTBI Report is built based on Pivot View and based on the Logical SQL of that OTBI Report , a BIP Report is built but there the Pivoting is not working as Exp…User_2025-02-08-08-08-53-292 93 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Need the AOR Information in OTBI ReportContent We need the AOR Information in OTBI Report. Please let us know if we have this details captured in any Subject area. Thanks Version 20BUser_2025-02-04-17-42-01-535 95 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM