Absence and Accrual
Discussion List
-
Query to pull balances and carryover on a specific dateHi experts, we need to generate a report that would display/ pull the balances and carryover as of specific date (Jan 1 2025). Currently, analysis is not able to do that… -
N/ASummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie…C.R.Balaji 82 views 5 comments 3 points Most recent by Akhilesh_Singh-Oracle Reporting and Analytics for HCM -
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…User_UM4C6 1.2K views 6 comments 0 points Most recent by Rohini Rayavaram Reporting and Analytics for HCM
-
How to extract deleted records from HCM cloud?Summary: Extract deleted records from HCM Cloud for PaaS for SaaS integration Content (required): We are trying to build a framework, where different business objects in…BhaskarMukherjee-Oracle 304 views 6 comments 0 points Most recent by Niraj Reporting and Analytics for HCM
-
Need fetch past date absence plan balanceSummary: Need to fetch past absence balance Content (please ensure you mask any confidential information): My requirement is to perform inbound integration via OIC from …
-
How to pause scheduled process and prevent a child process from running?Summary: Hello everybody. I recently discovered that releasing a process that was on hold will cause it to run all child processes, even if the date/time of the original…AppsSupport 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
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…
-
vacation plan accrual balanceHi Team, Please find the attached screenshot below. I’m looking for the balance days of the Accrual Plan Balance in the Vacation Plan. Could anyone please let me know th…Karthikeyan s-Oracle 11 views 5 comments 0 points Most recent by Karthikeyan s-Oracle Reporting and Analytics for HCM
-
I have developed custom resource alert using workers api but it's not trigger notification for HRSummary: I have developed custom resource alert using workers api to trigger notification to HR if any employee return from maternity leave but it's not trigger notifica…
-
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…Anup Karmankar 11 views 3 comments 0 points Most recent by Anup Karmankar 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):…
-
Absence Calendar / Dashboard (Sample Report)Summary This dashboard creates an absence overview that can be used by either HR or the line manager to get more information about absences for the organization, team, o…Even Kjorsvik-Oracle 1.2K views 16 comments 4 points Most recent by GraemeC Reporting and Analytics for HCM -
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 301 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
-
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 102 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 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 41 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 72 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 4.6K views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
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 -
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 Phani S-Oracle Reporting and Analytics for HCM