Absence and Accrual
Discussion List
-
Report Absence based on rolling 12 months from start of monthSummary How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm inContent Hi I would like to report absence on a rolli… -
Conditional Formatting in Pivot TableSummary Colour by Absence Type working in Table but not pivotContent Hi I'm trying to show a calendar for this month and next month. The number of days/hours shows corre…
-
Customization in Seeded Line Manager Dashboard for Absence pageContent Hi Experts, In the Seeded Line Manager Dashboard, the Absence page has an Absence for Today and Tomorrow analysis which displays absentees for Today and Tomorrow…Jaswant Prajapati 37 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Day Difference excluding weekends in OTBISummary Day Difference excluding weekends in OTBI From Workforce Management - Absence Real TimeContent Hi All, I need to calulate the difference between two dates - Abse…Dharmendra Jha 45 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Function for getting leave balance prior to execution of monthly leave accrualSummary Function for getting leave balance prior to execution of monthly leave accrualContent Hi, Please share function name or logic in order to get the leave balance o…Ghouseuddin Mohammed 47 views 6 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Absence Report showing Annual Accrual, Carryover and remaining balanceSummary Require a report that will show the employee absence information for reporting purposesContent Hi All, I need some help in trying to figure out where my numbers …User_2025-02-04-08-51-08-912 512 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Trying to embed a dashboard on shared My Team PagesSummary Trying to embed a dashboard on shared My Team PagesContent On the Manage my team absence balance page (We have renamed this to Time Off Balances) I have embedded…Matthew DeCilio 50 views 3 comments 1 point Most recent by Matthew DeCilio Reporting and Analytics for HCM
-
Want to subtract two dates for absence leavesSummary Hi all, I am trying to create a column with the total days in an absence.Content I am trying to subtract the start and end dates of the leave to create that info…Mario B 27 views 2 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
OTBI report to show Line manager direct and indirect reporters and not as per the person security prContent Hello Experts, We are creating a Absence report to for the Line Manager to display their direct and indirect reporters absences. We have a scenario where the lin…HarishVummidi 103 views 2 comments 0 points Most recent by Carlos Cuéllar Flores Reporting and Analytics for HCM -
Report on Terminated Employees Sickness AbsenceSummary We cannot report on sickness absence data for terminated employeesContent Hello, We have a requirement to report on the average working days lost for all employe…Dawn Cawston - CPS 39 views 2 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Single day Entry for each absence durationSummary Single day Entry for each absence durationContent Hi All, We have requirement where we need to fetch all the absences of employees as a single day entry. for exa…
-
Absence Days between DatesSummary Data must be returned where the absence is between two datesContent Hi all Can anyone help me with a problem where the Workforce Management - Absence Calendar De…Dawn Cawston - CPS 65 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Termination ActionSummary Where is Termination Action in OTBIContent Good afternoon We have created a leaving report in Work Relationship Real Time subject area however the Termination Ac…Dawn Cawston - CPS 68 views 16 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
OTBI Subject Area for availability patterns of a employeeSummary OTBI Subject Area for availability patterns of a employeeContent Hi, Anyone knows subject area to get availability patterns of an employee? Regards, RashmiUser_MC37Q 36 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to link consecutive absences with same absence type together in an analysisContent We are not using OT&L and have an interface bringing in absence hours into Oracle HCM. The absences are stored in 1 day intervals so when we have employees on a …
-
Restricting Access to OTBI Dashboards / Reports not Working as ExpectedSummary Restricting Access to OTBI Dashboards / Reports not Working as ExpectedContent Hi, We use Custom Roles and have configured the following: - Employee Role: No Acc…Karen Waddell 129 views 26 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Absence BalancesContent Hi all - I am working on a report to show absences taken during a period of time, and I have it just fine for calculating how many absences someone has taken in … -
Accrual Balance by DateSummary We need to create a report which allows us to report on accrual balances for previous years - Oracle have said this isn't possible in OTBI and to use BI - does a…KellyReed1976 103 views 5 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Absence Approval/Rejection Comments- BI ReportSummary Absence Approval/Rejection Comments- BI ReportContent how can we fetch Absence Approval/Rejection Comments in BI Reports.Priyanka_Kumari 51 views 6 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Reporting in Working days when absence UOM is hoursSummary I need to know how to convert a duration from hours into days using WPContent We are on 19D and our UOM is set to hours so when i report on absence, the duration…Dawn Cawston - CPS 74 views 2 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Weekly & Monthly Team Calendar View for Employees & ManagersContent Hello! I don't think a day goes by where we are not asked for weekly and monthly team calendars to allow our managers to make informed decisions around holiday r…Kevin M Storrie 104 views 2 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
How to fetch Accrual Balance based on the Assignment ID.Summary How to fetch Accrual Balance based on the Assignment ID.Content Hello Experts, I need to pull the Accrual Balance based on the Assignment ID. I am using the tabl…Chinna Reddeppa-110484 68 views 3 comments 0 points Most recent by Chinna Reddeppa-110484 Reporting and Analytics for HCM -
Leave adjustment detials for employeesSummary Leave adjustements for employees is available in any subject areas in OTBIContent HI, In the Absences sometime HC team are doing adjustment in the annual leave, …Farooq Syed, CPA, PMP, CISA 33 views 4 comments 1 point Most recent by User_2025-02-06-09-29-18-902 Reporting and Analytics for HCM -
Work Schedules in OTBIContent Afternoon all, Has anyone managed to report on all of the details that sit within Fusion Work Schedules from OTBI? I've built a fairly simple report, that pulls …User_2025-01-28-05-39-23-766 381 views 6 comments 3 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
How to get the employees without accrual plan - OTBISummary Is there a simple way to get the Employees without accrual plans? Currently we have BI report but would like to know if it is possible thru OTBI? Please advise. …User_2025-02-01-05-30-40-151 48 views 5 comments 1 point Most recent by Jenna Fuchs Reporting and Analytics for HCM
-
Is there a Worker Availability Report which include schedule and booked absence?Content Hello I wondered if anyone knows if there is a way of combining the old Worker Availability from the Manager resources dashboard with the calendar view of employ…Helen Thomas 77 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Summary OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Content Hi All, I have a couple of queries around reporting on Wo…Richard Beet 161 views 14 comments 2 points Most recent by User_2025-02-04-17-55-40-189 Reporting and Analytics for HCM
-
Leave accruals and usage by absence typeContent In our legacy system we had a report that listed, by employee, all leaves that were accrued and all absences taken, by leave type, sorted by date. Is there a rep…Annette M 68 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Productivity ReportSummary A Report from Oracle to provide site productivityContent Can i ask if a report like this is possible? They are looking to measure productivity in the sites, so t…User_2025-02-04-17-26-38-144 52 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Number of days left of vacationsSummary Number of days left of vacations for a person who's been let go or has resignedContent Hi, I'm trying to get the number of days left of vacations from a person w…User_2025-02-05-01-30-45-449 45 views 5 comments 0 points Most recent by User_2025-02-05-01-30-45-449 Reporting and Analytics for HCM