Global HR
Discussion List
-
How Do I Expand the Width of a BI Publisher ReportSummary How Do I Expand the Width of a BI Publisher ReportContent Hello Everyone, I created a BI Publisher Data Model for a new report. Then, I Viewed Data and Saved as …Daniel McMillian 246 views 4 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How can we have a Notification when an employee becomes a line manager ?Summary How can we have a Notification when an employee becomes a line manager ?Content Hello, We would like to have a notification that will trigger when a user is assi…Revital Mefano 45 views 2 comments 0 points Most recent by Abhishek Nigam Reporting and Analytics for HCM -
Not able to find Line manager in Subject AreaContent Hello, I am trying to get information from workers' assignment regarding their line manager. But when I select the info from the subject area Worker Assignment R…Virginia M. Calvi 35 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Tuning a rolling 12 Months turnover reportSummary How to performance tune a trend based report when using Ago and Rolling PeriodContent Hello Experts! In my ongoing saga of working with the trends subject area t…Rob F 144 views 4 comments 0 points Most recent by Abhishek Dixit-Oracle Reporting and Analytics for HCM -
How to Fetch the Direct reports of Line Manager as of specific dateSummary How to Fetch the Direct reports of Line Manager as of specific dateContent Hi Team, PFA catalog of analysis. We have created an analysis which we use to pull the…
-
OTBI Analysis performance is very slow on Dashboard PageSummary OTBI Analysis performance is very slow on Dashboard PageContent Hi Team, We have created a sample analysis using Worker assignment real-time subject area and it'…Mahendra 179 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 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 904 views 5 comments 0 points Most recent by Mohamed Salah Reporting and Analytics for HCM
-
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed…Annette M 78 views 8 comments 0 points Most recent by Rakesh Lathiya 2018 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 34 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 451 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 13 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 29 views 5 comments 0 points Most recent by Reddykrishna 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 48 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 299 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…LTalbott2 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