Global HR
Discussion List
-
Error advanced sql request using two subject areasSummary avanced sql query errorContent Hello , Attached the request I did to display competeny proficiency and target for the job profile. I have an error message . Any …User_I6AXL 44 views 4 comments 0 points Most recent by Anil Pillaresetty Reporting and Analytics for HCM -
Annualized Salary by QtrSummary Ability to report annualized salary by qtr when no salary changed occurredContent Hi I have attempted to create a report to show annualized salary by qtr for 201… -
Person, Assignment, Payroll data for Employees with Multiple AssignmentsSummary The following definition will extract basic person, assignment, payroll and element entries data for active employees.Content It is assumed that employee has one…Rachel Martorelli-Oracle 103 views 1 comment 3 points Most recent by Rachel Martorelli-Oracle HCM Extract -
Person, Assignment, Payroll data for Employees with Multiple Work Relationships and AssignmentsSummary The following definition will extract basic person, assignment, payroll and element entries data for active employees.Content It is assumed that employee has mul…Rachel Martorelli-Oracle 153 views 1 comment 7 points Most recent by Rachel Martorelli-Oracle HCM Extract
-
Person and Historical Assignment data for Active and Future Employees with One Work Relationship andSummary The following definition will extract basic person and assignments historical data for active and future employees.Content It is assumed that employee has one wo…Rachel Martorelli-Oracle 178 views 1 comment 7 points Most recent by Rachel Martorelli-Oracle HCM Extract
-
Competencies : target level and mine level in OTBISummary Competencies by target level and mine levelContent Hello, I cannot find in OTBI the mine level and target level . For example for the competency ITM_Architecture…
-
Report capturing BPM workflow configurationSummary Can we create a report to capture workflow configuration rules for validation?Content Hi All - We have almost 100 rules configured for *VariableAllocation task.I…User_2025-01-25-04-02-13-126 100 views 4 comments 1 point Most recent by Piyush Mohapatra -OC Reporting and Analytics for HCM -
Reporting on Sickness Qualification PlansContent Morning all, We currently already use OTBI to report on the number of sickness absences employees have. However, we also have configured the Qualification Plan f…User_2025-01-28-05-39-23-766 97 views 3 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Standard report to capture position changes for employeesSummary Position Change ReportContent Hi folks, Is there a standard Oracle report available now to capture an employee's position title changes, which occurs to Promotio…User_2025-01-29-23-35-12-713 290 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Self-Service & DashboardsSummary How do you share your reports with your users?Content Hello experts - I am hoping to find out best practices as to how you do reporting for your company (or how …Prudence K 112 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way to catch the No Results message with a user-friendly message?Summary Is there a way to catch the No Results message with a user-friendly message?Content A way to catch the No Results error message with a user-friendly messageI hav…Kimberly Nguyen 68 views 7 comments 1 point Most recent by Kimberly Nguyen Reporting and Analytics for HCM -
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…User_2025-01-28-17-24-53-863 204 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Unreadable content when reporting on GoalsSummary Excel generated error when using Export to ExcelContent Hi, when I'm reporting off the 'Workforce Goals - Goal Status overview real time' subject area, the analy…Alex Andreadis-70445 49 views 5 comments 1 point Most recent by Alex Andreadis-70445 Reporting and Analytics for HCM -
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 475 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
Donuts instead of PiesSummary Is it possible to output Donut charts instead of pie charts?Content Most modern dashboards contain at least one donut / doughnut chart. Few contain pie charts an…User_2025-01-23-23-50-04-709 102 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Top N querySummary Filter top 5 leaving reasonContent Hi, I want to create a report that shows the top 5 reasons of leaving (e.g. 'found another job", "Low salary" etc.). I know wh…
-
Job Function NameSummary Need Function Name in BI Publisher reportContent Hello, I am building a BI Publisher report and need to pull in the Job Function Name I found the JOB_FUNCTION_CO…User_2025-01-23-21-24-21-434 785 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
How to Obtain "People Group" Field through BI PublisherSummary How to obtain "People Group" field through BI PublisherContent Hello All, I am unable to obtain "People Group" and "Legal Employer Name" fields through querying …Aahiri_Sarma 65 views 7 comments 0 points Most recent by Aahiri_Sarma Reporting and Analytics for HCM -
Manager Types in reports - HELP NEEDEDContent Hi All, I want to create a report that will show the manager type + manager name for each employee. i.e. Person Name Manager Type Manager Name Dudi Levi Line Man…Dudi Levi 97 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM