Global HR
Discussion List
-
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 105 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 177 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 101 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 96 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 206 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 474 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 781 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
-
Table name to find the approved date and approve by columnSummary Table name to find the approved date and approve by columnContent Hi, I have a requirement to create a report with approved date and approved by column. My custo…User_2025-01-29-01-27-20-754 67 views 3 comments 1 point Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones …
-
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 29 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM