Absence and Accrual
Discussion List
-
Not able to fetch the absenec plan balance adjustment date ( i.e ProcdDate in PersonAccrualDetail.daSummary Need to Fetch Balance Adjustment details for different plans . Not able to fetch Balance adjustment date ( i.e ProcdDate in PersonAccrualDetail.dat file)Content …User_2025-01-30-17-37-30-647 34 views 4 comments 0 points Most recent by User_2025-01-30-17-37-30-647 Reporting and Analytics for HCM -
Error with Month as a Presentation Variable PromptSummary ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-codedContent OTBI Report runs fine in Edit mode and s… -
Query Absence Pending TransactionsContent Hello experts. I'm trying without success to create a report that gives me the history of transactions. Category - Status - to whom - initiated at - Approver (As…Pedro Teixeira 283 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached …Vasanthakumar Ravi 117 views 6 comments 0 points Most recent by Debkanya! Reporting and Analytics for HCM -
Identify retro changes on absence entriesSummary Identify retro changes on absence entriesContent How do we identify retro changes on absence entries? For example. employee A applies for leave from 10/1/2020 to…Sowdha Murugan 29 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Workforce Management - Accrual Real Time/Worker Assignment Event Real TimeSummary Issue when combining subject areasContent Hi! Really hoping someone can help with my query. I would like to show the annual leave absences taken by month for a p…
-
Report on Absence approved dateSummary Report on Absence approved date in OTBIContent Please share the steps to capture Absence approved date when reporting on other absence details in OTBI. I have se…
-
Absence Booked in future date with complete detailsSummary Absence Booked in future date with complete detailsContent Hi Team, We wanted to fetch all the employees who booked their absences in future-date (for example be…Mahendra 41 views 9 comments 0 points Most recent by User_2025-02-04-23-40-44-792 Reporting and Analytics for HCM
-
Absence balance reportContent I am trying to create an absence balance report for each accrual plan by employee. The report would look like the attached using the "Employee Plan Participation…Annette M 130 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Absence OTBI reportSummary Absence OTBI reportContent Hi Team, Can you please share if we have any OTBI report or analysis/dash board to fetch carry over, accrual and vacation balance ? (F…
-
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…User_2025-02-04-08-51-08-912 33 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 71 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 99 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 37 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 41 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 35 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 480 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 45 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 22 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 98 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 34 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 60 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