Absence and Accrual
Discussion List
-
Report on retro absence recordsSummary Retro absence records for payrollContent Hi all, I am trying to modify a custom report to include absences that were added to the system during the pay cycle but…PamS 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Scheduling Report to Respective Line ManagersSummary Scheduling Report to Respective Line ManagersContent Hi Team, We have a requirement that respective line managers should receive a report on weekly basis about p… -
Day wise break up of absences in OTBIContent Hi Team We have a very basic requirement that absences for multiple days need to be broken down into individual days and be displayed on OTBI When i ran the Abse…
-
Tables/joins to create BI Publisher report for Audit trail of Absence entries.Summary Tables/joins to create BI Publisher report for Audit trail of Absence entries.Content Hi All, We have enabled audit trail for absence entries. and trying to capt…User_XT9HW 72 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
OTBI annual leave analysis displaying incorrect Other AdjustmentsSummary In an annual leave analysis, some of the records are pulling through incorrect value for Other AdjustmentsContent We have created an analysis using the below sub…Anna Kryszak 98 views 2 comments 0 points Most recent by Anna Kryszak Reporting and Analytics for HCM -
Absence Accrual Plan attributes report neededSummary Is it possible to create a report that dumps all of the attributes related to an Accrual Plan?Content In OTBI, using the Subject Area: "Workforce Management - Ac…
-
Report on data entry by useridSummary Is there a way to pull transactions by person?Content Hi All, is there a report (or do you know the tables) that could be used to find the transactions/data entr…Bonnie Lafferty 36 views 2 comments 0 points Most recent by Bonnie Lafferty Reporting and Analytics for HCM -
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 32 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 40 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 34 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 …PamS 428 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 43 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 Bove-160949 21 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…Harish Vummidi 86 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 32 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 59 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 62 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 34 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 …Mario Bove-160949 39 views 4 comments 1 point Most recent by Mario Bove-160949 Reporting and Analytics for HCM
-
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 124 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 98 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 45 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 68 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 98 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 62 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 29 views 4 comments 1 point Most recent by Andrew Collins-174647 Reporting and Analytics for HCM