Absence and Accrual
Discussion List
-
Absence Balance MismatchHi All, Several employees have a balance discrepancy between the plan level and the accrual level. Is there a query available to retrieve this information and identify t… -
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b…Elizabeth Docherty 236 views 25 comments 0 points Most recent by ZeyadAbdullaMohamed Reporting and Analytics for HCM -
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…
-
Absence Plan does not update when worker's employment details updated.Summary: Has anyone encountered an issue where, when a worker's employment was updated, the new eligible plan was not enrolled, even though the Update Accrual Plan Enrol…Shannon Teves 21 views 1 comment 0 points Most recent by Priya Palanivel-Oracle Workforce Management
-
Plan period start date in absenceSummary: Hi Team, I am trying to get absence accrual detail in OTBI report. Please let me know how to get these details with plan period start date. Thanks Content (plea…
-
Absence Date Start in OTBII created a report using Workforce Management - Absence Real time that shows absences employees have along with the date created, and date start of the request. I notice…
-
Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES TableSummary: Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES Table Content (required): Hi All, Can anyone please let me know the use of the column PAYROLL_CHG_FLAG in ANC…
-
Exclude Bank Holidays from Absence Days calculationSummary: Bank holidays are counted in the absence days calculation for a sickness absence but should be excluded Content (required): We have a number of sickness absence…Dawn Cawston - CPS 97 views 22 comments 2 points Most recent by Dawn Cawston - CPS Workforce Management -
In what Subject will I find Vacation Service Date?Summary: I am looking for pull the Vacation Service Date for all EEs, however, this does not appear in the analysis listing and I cannot find the specific subject that t…Kelly_at_D&R 61 views 4 comments 0 points Most recent by Mohammad Afghanul Payroll and Global Payroll Interface (GPI) -
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.4K views 18 comments 3 points Most recent by Mirza_Adeel Reporting and Analytics for HCM -
Absence type display feature tab attributesGood day! I need help in identifying what is/are the table source/s for the items boxed in red below… it is in the Display Features tab in Absence Type: TIA.notautomni9 12 views 1 comment 0 points Most recent by Rajinikanth Sridharan-Oracle HCM-Oracle Workforce Management -
How to link absence details and payroll detailsSummary: Hi all We need a report that provides absence details along with the payroll elements processed based on those absences. Specifically, for the OFFICIAL TRIP abs…Shameer Muhammed P M 14 views 0 comments 0 points Started by Shameer Muhammed P M Reporting and Analytics for HCM
-
How to Customize the sub-template for AbsenceApprovalNotificationTemplate?I want to change a couple of words in the content of "AbsenceApprovalNotificationTemplate" workflow notification. As the required place was not found in the AbsenceAppro… -
How to add Role in the Parameters in the Absence Workflow?Summary: Setup a Workflow in Absence wherein we need to check if the initiator of the Absence Entry is a User that has a Specific Role. Requestor's Role Details is not a… -
we looking lapsed(Forfeiture) data in all plan types as on dec 2024Summary: Hi Team, we looking lapsed(Forfeiture) data in all plan types as on dec 2024. please find xml of report. Thanks, Ajay Content (please ensure you mask any confid…AjayKumar Maddipati 1 view 0 comments 0 points Started by AjayKumar Maddipati Reporting and Analytics for HCM -
BI Publisher report errors while running from Scheduled ProcessesSummary: Hello Team, Our technical team has developed a BI publisher report under Reports and Analytics—>Custom—>HCM folder. But when a user tries to run the same from T…Neha_C-Oracle 32 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …Raghavendra M 3.7K views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Transaction Console -> Error Description and Error Resolution (hrc_txn_error)Summary: I have a requirement to get the data related to the transaction console when the transaction fails I need to get the error description and error resolution as d…
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 41 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
How to disable the deeplink from the bot responseSummary: How can I remove the deeplink "Schedule time off" from the response coming from custom component. Content (please ensure you mask any confidential information):…
-
Need to report on Work schedule with attached work pattern and attached holidaySummary: Hi Every one, I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday. Below is sample output:-…Krishna Manmohan 11 views 1 comment 0 points Most recent by Kumar-S-Oracle Reporting and Analytics for HCM -
Absence Calendar Subject Area not showing all dataSummary: When I run my report using the Absence Calendar Subject Area a large amount of data is missing. I have tried running the Generate Daily Breakdown of Absence Det… -
Absence notification is not sent to Line Manager after Employee withdraws it.Summary: In the Absence approvals, when an absence is requested by an employee and is approved by their Line Manager, when the employee attempts to withdraws the absence…
-
How to show person data at the time of absence submission in OTBI?Summary: We have a requirement to show the person data at the time of submitting their absences. But the OTBI report brings the latest job name, FTE, department, busines…Ridma Karunanathan 12 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
is there a way to access other countries absence calendar?Hello, I was thinking if it's possible to access other absence calendar like for example from HR from Brazil to access US absence calendar. is this possible?
-
Cost of absence sicknesSummary: Report to show cost($ amount) of employee leave balances Content (please ensure you mask any confidential information): Hi Team, We have developed a report for …Thomas Samuel19 22 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
What is the fast formula definition for Enterprise Hire dateSummary: I'm building a fast formula that will pull the Enterprise Hire Date of an employee for an eligibility profile. Need your help please. Content (please ensure you…
-
Is there other table store info about qualified entitlement planHi Teams, table anc_per_abs_qual_entl is holding the data when user records an absence, do we have any other table or view stores the entitlement information when user n…
-
OTBI Analysis Columns displayed by prompt valuesHi Experts, We have a balance report that works well. However, we would like to display in it some context based assignment DFF's. We would like to keep 1 report for eac…