Global HR
Discussion List
-
Report to show where Referral payment due on completion of Probation periodSummary: We are trying to build a report which alerts us to employees who have now reached the end of their probation period and were referred by an employee during recr…Emily Robinson 31 views 7 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM -
How do take End of the Month Prompt in OTBI?I am trying to fetching the count of Legal employers , total cost based on the categories and required prompt is end of the month as per selection should come count of L…Nagaraju P 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to get inactive or future dated employees in OTBISummary: Content (required): We are using the subject area "Workforce Management - Worker Assignment Event Real Time" and we are unable to get inactive or future dated e…Vinay Gharge 31 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
we have requirement of how extract person history detailsSummary: Hi Team, we need to create the report on history details of person like surname before marriage and after marriage , etc of person history details Content (requ…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can hourly rates be reported on?Summary: Our workforce has both salaried and hourly associates and we have a requirement for an analysis to show hourly rates using the SA Compensation Salary Details Re…
-
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 21 views 1 comment 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Nested IFNULL and CASE StatementSummary: Hi All, I'm trying to write a CASE statement where if the Annualised salary is blank I need it to say 'Not Reported' Content (required): Below is what I am tryi…
-
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 91 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Query to Display the employee and the supervisor chain bottom upSummary: Does someone have a query for the employment and Supervisor/Manager hierarchy ? Content (required): Hello , I have very little experience in HCM tables, hence I…Cesar Saveedra 2.9K views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM
-
Multiple date rowsSummary Multiple date rows In analysisContent Hello friends, i am migrating a direct sql analysis to a new analysis using the subject area, but I have a problem with the…User_2025-01-25-01-17-59-580 38 views 7 comments 0 points Most recent by MarkHodges Reporting and Analytics for HCM -
Is there any way to automatically download the data and upload to FusionSummary: Is there any way to automatically download the data using BI Report and upload it back to Fusion Content (required): We have a requirement to generate some data…Dharmendra Shukla 51 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Last Day of the Previous Month Active HeadcountSummary: SQL for Period Start Active Headcount minus 24 hours Content: We are looking for a SQL formula that takes the delivered measure Period Start Active Headcount mi…Rebekah Gilday 21 views 2 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Need help of running Element Entries - Real Time report for Workers Element entriesSummary: Hi Experts, We need to report on payroll elements for Employees. We have tried to use the subject area Payroll - Element Entries Real time. Whenever we are addi…Silpi 41 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Ethnicity- Multi resulting in errorSummary: I am trying to decode the multiple option selected in the race condition used: COUNT(DISTINCT "Worker"."Employee Ethnicity Code" by "Worker"."Person Number") > …Anita 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Generate Employment Letter after approvalSummary: Employment letter can be generated using BI Reports but client wants certain letters to generated once manager/hr approves Content (required): Is it possible to…VivekHCM 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
LSQL with Prompts inputs not workingSummary: I've got a combined subject area LSQL which looks at 3 possible input prompt which can be blank or filled with values by end users. I'm passing the prompt input…Rohan Fernandes 21 views 2 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Reporting on real trends in headcount by hierarchy excluding impacts of reorganisationsSummary: We need to provide headcount trend data to our business leaders and managers for their respective organisation without the impact of reorganisations being visib…User_2025-03-07-20-15-16-297 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Turnover Dashboard for Line ManagersSummary: I would like to provide a Turnover Dashboard for Line Managers in OTBI but the seeded / sample dashboards provided by Oracle are not returning data when logging…User_2025-03-07-20-15-16-297 132 views 13 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 131 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Using Variables in Etext templateSummary: Hi Team, I was reviewing a oracle guide for etext template. For one of my requirement I am trying to use Variables in etext template. GetVar(var-name) ResetVar(…Mohan Murali 1.8K views 6 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Turnover Analysis - Line Manager DashboardsSummary Count fields - Termination Headcount, Voluntary Termination Headcount under Subject Area "Workforce Trends" are not reflecting correctContent Hello, We are looki…User_2025-02-05-07-43-29-505 136 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Fiscal Year HR ReportingSummary Needing to have reports such as a Turnover Report that is based on Fiscal Year vs Calendar YearContent Does anyone have any experience or examples on how i could…Rob Stahly 91 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there any way to identify which roles have security profiles?Summary: Is there any way to identify which roles have a View All Document Types and View All People person security profile, and who these are assigned to? Content (req…Abhimanyu Kumar27 51 views 3 comments 0 points Most recent by Rachel Martorelli-Oracle Reporting and Analytics for HCM
-
Aligning a physical or alternate location to virtual employees (mostly for communications)Summary: Now that a larger number of employees have switched to virtual work at home or hybrid, requirements mostly centered around communications have arisen concerning…Shawn Gertler 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
Gender Pay Gap ReportSummary Has a Gender Pay Gap report been release for HCMContent I am trying to find the equivalent Gender Pay gap report that existing in EBS. Is there one? If not what …User_2025-01-23-23-03-09-078 177 views 15 comments 4 points Most recent by TarunAggarwal Reporting and Analytics for HCM
-
Login In, Login Out and Login Duration of a user in an OTBI analysis.Summary Login In, Login Out and Login Duration of a user in an OTBI analysis.Content Hi, We need to find a subject area that gives the login time of the user into fusion…User_MC37Q 302 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Bursting - Multiple Templates - Multiple DestinationsSummary: Bursting Query for sending email notifications to an employee and line manager, each with their own template. Content (required): Hello, We have a requirement w…
-
Getting the Period Start Active Headcount to equal the previous months Period End Active HeadcountSummary: Getting the Period Start Active Headcount to equal the previous months Period End Active Headcount Content (required): We need to get the Period Start Active He…Rebekah Gilday 61 views 6 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
Seeded HR Reports not returning any resultsSummary: Hi , We actually have to run all the seeded HR reports and present the output to the client . Now I got the list of the seeded reports but when I am trying to r…Gaurav Rath- PGC 41 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…