Absence and Accrual
Discussion List
-
Absence calendar in line manager dashboard shows more workers for next monthSummary: the absence calendar in line manager dashboard shows absence for current and next month. I found the next next month does not only present direct reports, but a…Wouter.Schaap 33 views 3 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM -
What table is absence Plan Period Start Date stored?Please see sample screenshot:notautomni9 203 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to remove a subject area access from duty role?Summary: How to restrict subject area access in a duty role? Created copy of "Absence Management Transaction Analysis Duty" role. Want to remove "Payroll - User-Defined …K Qureshi 81 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Absence AttachmentSummary: Report on Absence Attachment. Is it possible to create a Report which will say who has attachment on Absence Content (required): Hi Experts, Is it possible to d… -
Unable to see absence data in Workforce Management - Absence Calendar Details Real TimeSummary: Hello While running the Employee absence calendar report, I cannot see any absence data. Employee Absence Calendar — Cloud Customer Connect (oracle.com) Content…Helen Thomas 131 views 4 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
In which table we can find Accrual Plan Balance DatesDear , i want to know which table i can find leaves dates same like you can check there is details you can see date also i want that dates table? ThanksMirza_Adeel 41 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
ANC_PER_ABS_ENTRY_DTLS table is emptySummary Absence entry Detail table not getting populatedContent Hi All When absence entry is created from the UI with basic mode, data is not getting stored in table ANC…Amol Patil HCM-Oracle 608 views 16 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Annual Leave Following Maternity LeaveSummary: Pick up if an absence spell directly follows a different type of absence, Content (required): In OTBI is there anyway to detect if an an absence spell directly …David McLellan 11 views 0 comments 1 point Started by David McLellan Reporting and Analytics for HCM
-
Where to check if employee received a pager unit and their on-call premium?Summary: I'm trying to look where in HCM this information can be visible: Employee received a pager unit and their on-call premium. Thanks!notautomni9 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Ability to report on modified approved future-dated absence entriesSummary: Content (required): Hi - is there a way to report on absences that have been modified by employees ? Example: On 11-Aug-2022, an employee applies for a 2 day ab…
-
Looking for a sql query to get the absence plan and corresponding element name associatedSummary: Hi, We have a requirement to get the data of the Absence Plan and corresponding element data using the sql. If anyone has come across such requirement then plea…Peeyush Chandel 3.1K views 1 comment 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM -
Issue: Unable to find Donation related Entry reason in Absence tableSummary: Unable to find Donation related Entry reason in Absence table Content (required): We can see the Additional Information stored in Adjustement_Reason but when it…
-
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use…
-
Where is 'Elective Disbursement' details of Absence Plans stored?In the details of absence plans, which tables/lookups can I find values of this field? This is what it looks like in front-end: Thanks!
-
How is Absence Days metric is calculated?Summary: Hi, We would like to understand how Absence Days measure is calculated. It gives different results (one correct and the other is not) I don't know what the issu…HulyaAkan76 51 views 5 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get plan start and end dates for a persons absenceSummary: I want to build a report to show the start and end dates of a person enrolment in a plan as we need to write to each person when a plan will expire. Content (re…Sharon Harper 12 views 6 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Employee Vacation Schedule and vacation rate Listing ReportSummary: Looking for sample OTBI report for Employee Vacation Schedule and vacation rate Listing Report. I looked at customer connect "HCM Report Sharing Center" but cou…User_2025-02-12-21-07-06-233 21 views 4 comments 0 points Most recent by User_2025-02-12-21-07-06-233 Reporting and Analytics for HCM -
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!notautomni9 32 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Leave Balance showing incorrect IN Custom BIP reportSummary: Hi Team, Some of emplyoees showing incorrect leave balance that zero and some of have showing corret value . Could you please assit on ? Thanks AJAY Content (re…AjayKumar Maddipati 22 views 6 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Need to remove one measure column's grand total value in OTBISummary Need to remove one measure column's grand total value in OTBIContent We have Grand total value for two measure columns in OTBI Report. We need grand total value …User_2025-02-04-17-42-01-535 155 views 5 comments 0 points Most recent by user11468604 Reporting and Analytics for HCM
-
AZA: Consecutive Absence ReportSummary: Hi team, We have a requirement to build an absence report for a specific absence type, report should pull the data if the duration of the absence is greater tha…Ahmed AZA 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Absence report shows different end dates on different browserSummary: Content (required): We have an absence reports which shows the employees absence. Absence type, start date and end date. However depending on which browser I us…Nicolas Vahman 52 views 9 comments 0 points Most recent by Nicolas Vahman 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 212 views 5 comments 0 points Most recent by BhaskarMukherjee-Oracle Reporting and Analytics for HCM
-
Using CASE to return formula-calculated valueSummary: Requirement is to build an analysis to convert hours leave balance to days equivalent, using employee assignment working hours value. As employee working hours …Alastair Wood 14 views 2 comments 0 points Most recent by Alastair Wood Reporting and Analytics for HCM
-
How can I add a column for % Holiday Balance remainingSummary: Hello, I'm looking to see if anyone has the correct formula for me to use, or has already added in the column for '% Balance Remaining' for the annual holiday a…Karen Doig 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Remove filter values from Export to Excel from DashboardSummary: Content (required): I would like to remove the filter from a dashboard when exporting to Excel. As seen below there is a screenshot of the Excel export I made. …Nicolas Vahman 12 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
OTBI - Is it possible to retrieve working days per employee?Summary: Hi, We are using absence mgmt module (no time and labor) and one of the reports requires us to display how many days a month is an employee supposed to work (ba…HulyaAkan76 111 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Summary ReportSummary: Does anyone have an absence summary report? Content (required): We are looking for a report (or better yet, and analysis) that tells us how many hours each empl…Jenna Savage 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to report on initial absence start date while maintaining current absence start/end date columnsSummary: Hi All, I have a requirement to report on the initial start date of consecutive absences, while also showing the start date and end date of the current absence.…User_2025-02-11-06-38-03-841 22 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can't view own record in OTBISummary: I have a custom role where I would like to see my own data, only in OTBI but not to be able to correct it in HCM. Like add absence to my own person. I don't wan…Nicolas Vahman 453 views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM