Absence and Accrual
Discussion List
-
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 93 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 69 views 4 comments 0 points Most recent by Mohammad Afghanul Payroll and Global Payroll Interface (GPI) -
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 231 views 24 comments 0 points Most recent by Greg Rank Reporting and Analytics for HCM -
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…
-
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 11 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 34 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.6K 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 43 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 17 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 16 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… -
Absence Calendar Direct Reports Current Month not returning any valueHi Experts, When we are running the report "Absence Calendar Direct Reports Current Month" from Line manager Dashboard, It is coming as empty. I have checked then backen…Nivya M 76 views 8 comments 0 points Most recent by Gunasagar Thimmapuram-Oracle Reporting and Analytics for HCM -
Need to report on Employees work schedules and patternsContent Hello, We need to be able to report on employees work schedules and patterns so we can create a report that looks like a calendar and show the days that employee…