Absence and Accrual
Discussion List
-
How to navigate from OTBI report to Absence Record Entry page in Edit modeSummary There is no Deep Link available to navigate to Absence Record page in Edit Mode using Absence Entry ID. Want to know if there is any way to open the Absence Reco…User_UM4C6 52 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI > Subject Area for Employees Assigned Work ScheduleContent Hello All, I will appreciate your support in the following issue: We have defined different Work Schedules which are assigned to different population based on sp…
-
Help required to find the User Entity for the table ANC_PER_ACRL_ENTRY_DTLS to use in extractContent Can anyone please tell me what is the User Entity for the table ANC_PER_ACRL_ENTRY_DTLS so that i could use the columns in extracts. Version Oracle Cloud Applica…Amrish Kumar-210718 40 views 3 comments 1 point Most recent by Amrish Kumar-210718 Reporting and Analytics for HCM
-
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…Kiran Kancherla 22 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Extract Projected Accrual Absence Balance in HCM/BIP reportSummary Extract Projected Accrual Absence Balance in HCM/BIP reportContent Hi Experts,We have a requirement to fetched projected Absence balance of employee in extract t…Rajeev Nayan 575 views 6 comments 3 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P…AshishERPCloud 697 views 10 comments 5 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Absence cases and Details linked to absenceContent I am looking to build a report that includes the absence cases and the associated absence and details from the documents that have been attached in order to prov…Sharon Harper 29 views 2 comments 1 point Most recent by Sharon Harper Reporting and Analytics for HCM
-
How to Report available working hours of all Employees in a department excluding Absence HoursSummary OTBI Report for Available Working Hours of All Employees using either FTE or Normal Working Hours from Employee Assignment by excluding the Absence Hours during …
-
Effective date for OTL Absences issueSummary Although an effective date is set via presentation variable values are counted by a different dateContent Hi everybody, I'm struggling with the following report …User_2025-01-31-17-16-46-301 86 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Scheduled Absences FieldSummary How do I get scheduled absences for this plan year only?Content Hi I need to run an accrual report for Finance and they need the absences booked but not taken in… -
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 264 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 115 views 6 comments 0 points Most recent by User_D33E2 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 40 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 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 70 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 96 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