Absence and Accrual
Discussion List
-
How can I add a column for % Holiday Balance remainingSummary: Hello, I'm looking to see if anyone has the correct formula for me to use, or has already added in the column for '% Balance Remaining' for the annual holiday a…Karen Doig 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Remove filter values from Export to Excel from DashboardSummary: Content (required): I would like to remove the filter from a dashboard when exporting to Excel. As seen below there is a screenshot of the Excel export I made. …Nicolas Vahman 11 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
OTBI - Is it possible to retrieve working days per employee?Summary: Hi, We are using absence mgmt module (no time and labor) and one of the reports requires us to display how many days a month is an employee supposed to work (ba…HulyaAkan76 111 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Summary ReportSummary: Does anyone have an absence summary report? Content (required): We are looking for a report (or better yet, and analysis) that tells us how many hours each empl…Jenna Savage 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to report on initial absence start date while maintaining current absence start/end date columnsSummary: Hi All, I have a requirement to report on the initial start date of consecutive absences, while also showing the start date and end date of the current absence.…User_2025-02-11-06-38-03-841 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Can't view own record in OTBISummary: I have a custom role where I would like to see my own data, only in OTBI but not to be able to correct it in HCM. Like add absence to my own person. I don't wan…Nicolas Vahman 501 views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Absence Attachment in Report OutputSummary Absence Attachment in Report OutputContent Hi All, I have a requirement in which i have to display absence attachment content in report output for each employee.…nitin Sharma 65 views 5 comments 2 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM
-
Sum Parts of a ColumnSummary: We have a table with the %age of absence per absence name however on the pie chart, I need to sum the ones that are at the lower end of the spectrum. Content (r…Dawn Cawston - CPS 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create a report to show both accrual values for an employee and absence value for an employeeSummary: I want to create a report, that shows how much holiday an employee has left on their balance, and in the same report show how many days of absence an employee h…Nicolas Vahman 11 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Min and Max columns on Assignment Effective Dates are blank in OTBI analysisSummary: 'Latest Assignment Start Date', 'Earliest Assignment End Date' columns showed data while building the report. After adding more columns and filter condition the…Vinay Hardas 251 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to read the info from the Calendar?Summary How to read the info from the Calendar?Content Hello, do you have any query that is able to read from the Calendar under Work Schedule Assignment? Many thanks to…Nicola Petri 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Accrual balance with different start dates for plansSummary: my customer is an international company and the various countries have different accrual plans. For most countries the plans start at January 1th of a year, but…Wouter.Schaap 11 views 4 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Workforce Management - Absence Real Time Subject Area not returning any dataContent Workforce Management - Absence Real Time Subject Area displays 'No Data found' . Can someone who has used this Subject Area please let me know the roles that hel…Shruthi Ramesh 185 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
Users cannot see their own accrual balanceSummary: Users cannot see their own holiday accrual balance in OTBI accrual report Content (required): I have an OTBI report showing Accrual Balances using the Accrual R…s_b 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Why would OTBI reporting show a row with no absence plan name against an employee?Summary: Multiple rows showing with a blank Absence plan name Content (required): I have created a simple analysis with Person number, Name, Absence plan name and termin…Elizabeth Docherty 31 views 1 comment 0 points Most recent by Elizabeth Docherty Reporting and Analytics for HCM -
Display Extended Absences by day from Absence ModuleSummary: We have a requirement to show absences by day if they are booked over a period of time. Content (required): The example we have is if someone books a week long …User_2025-01-31-00-25-12-234 21 views 2 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Subject Areas for Work SchedulesSummary Our clients requirement is to create on the ratio of Planned/Scheduled Hours vs Actual Hours.Content Dear Experts, Our clients requirement is to create on the ra… -
Amalgamated Absence DaysSummary: My report is totalling the absence days for all absences of the same reason name and displaying that total on each line of absence in the report. I need it to d…Dawn Cawston - CPS 11 views 6 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 231 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Absence Management | Hours Worked Year to DateContent Hi all, I have a request to create a report that shows hours worked year to date. Is there a specific subject area that I should be referencing? We do have the A…Tristan Aquino 20 views 2 comments 0 points Most recent by Tristan Aquino Reporting and Analytics for HCM -
Issue with "Workforce Management - Absence Real Time"Content Hi Team, We have designed a specific report using the OTBI "Issue with Workforce Management - Absence Real Time". This was working fine till last month and now w…Kiran Kancherla 23 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…User_2025-02-04-13-27-19-123 119 views 4 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM
-
Ability to find out the Work Schedule based on ShiftSummary Ability to find out the Work Schedule based on ShiftContent Dear Team, Basic Requirement is to develop the custom BI report based on Shift Details to find out th…User_2025-01-31-16-34-04-599 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI report to extract Status information for Absence ManagementSummary Any pre build report to extract absence type and status information for Absence Management?Content Hello, If anyone has any pre build report/query to fetch the d…
-
Subject Area which includes Maternity Weekly Average EarningsContent Can any one help me to identify subject area which contains below highlighted field in the attachment? Absence Administration (Maternity Leave) -> Override Avera…ViswanathaReddyKetireddy 29 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM
-
Override Average weekly earning field in OTBIContent Does anyone know if the Override Average weekly earning field that can be found in Absence Records under legislative information is available in OTBI?Tasha 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this …Susan Anderson 41 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…Mitch_123456 21 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM