Absence and Accrual
Discussion List
-
OTBI:I need to pull the carryover limit of persons enrolled in an absence planSummary: I need to pull the carryover limit of persons enrolled in an absence plan Content (required): I need to create a BI Publisher report that pulls the carryover li…Jose Lorenzo Amarado 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM -
HowThere is aCansel Karasoy 41 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM -
Need to know approval date file & table name of absence records attached my sql, if anyone please moSummary: we use oracle fusion cloud. OBI report and analytic Need to know approval date file & table name of absence records attached my sql, if anyone please modify and…RIfdhy Zain 503 views 3 comments 0 points Most recent by RIfdhy Zain Reporting and Analytics for HCM -
How do I get absences that are ongoing during a period but may start/end outside it?Summary: We are trying to build an absence summary report that shows individuals off between two dates but the start and/or end dates may not be during the dates in the …
-
Any function is available that can be used in OTBI reports for calculating annual leave balance.Summary: Any function is available that can be used in OTBI reports for calculating Annual leave balance. It should work same as 'balance calculation' in oracle fusion h…Meera Sajeevu 211 views 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM
-
OTBI created to fetch details of Absence accrual balance is not picking latest dataSummary: Content (required): We have created a custom otbi report which fetches the details of accrual balance. But we observed that the data is not getting updated on d…Veeru15 203 views 5 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
View Display Error - Error Codes: EKMT3FKSummary: I am running a fairly simple OTBI analysis and the report won't return all the records. The below error is presented when exporting the report: View Display Err…
-
Time Entries SQL HelpHi Experts, we need to fetch all the time entries including Absences.SO for Absences we need to have a column for Absence Type.But i am not sure how can we find the abse…minati_behera-Oracle 41 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
we need below BI columns but unable to development of those from absenceSummary: any one help me and to the requirement Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that …AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI report run for some users onlyDear , we have custom otbi report which is showing absences and working fine for all users but suddenly it is works for some users and not working for some users can any…Mirza_Adeel 51 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
End Dated values no longer appear in OTBI reportsSummary: We have end dated a number of Sickness Reasons (sub reasons), which used to pull through on OTBI reporting, these no longer appear after being end dated Content…Luke Harrison-126889 41 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is it possible to customize AbsenceApprovalEmailNotification report to get Absence Balance included?Summary: We need to somehow modify the data model so that the absence balance of the absence type from the absence request gets displayed on the report. Content (require…bervin13 51 views 2 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM -
we need annual accural and carry over columns in biSummary: Hi Team, we looking above two columns from BI reports . any one can help me on. Thanks, Ajay Content (required): Version (include the version you are using, if …AjayKumar Maddipati 61 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Delegation Approval Query /TableSummary Delegation Approval Query /TableContent HI , i have a requirement to create BI/OTBI report for delegation approvals. Can any one please share the table/query whi…
-
Count of week days for absence reportSummary: We need to count the weekdays (Mon - Fri) in a selected period to calculate absence percentage. Anyone a suggestion or solution how to get this done? WouterWouter.Schaap 51 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Can't see absence reason in reports after putting end date inside the relevant absence typeSummary Can't see absence reason in reports after putting end date inside the relevant absence typeContent Hi, We have an issue that after putting the end date to an abs…Markovich Chen 33 views 3 comments 0 points Most recent by Jonny Varley Reporting and Analytics for HCM
-
MonthName function not WorkingSummary MonthName function not WorkingContent Hi All , I am trying to get the Month Name (Jan / Feb / Mar) from a Date entry - Eg -I'm using the following function - Mon…Jo Black 79 views 11 comments 0 points Most recent by Raghavendra_M-Oracle Reporting and Analytics for HCM -
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
how to restricted otbi report to show employee absencesDear , I have a otbi report which is showing correctly result with all employees absences but issue is its showing for those employee who applied leaves on 2021 Dec to 2…Mirza_Adeel 31 views 6 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
In Otbi reports where we find Absence DatesDear , I need to put Absences Dates in otbi report but i cant find Not need Date Start and End Date i need only Date For example if one employees taken 30 leaves from 25…
-
Unable to Join Multiple Subject AreasSummary: Unable to join "Workforce Management - Absence Real Time" Subject Area with "Workforce Management - Worker Assignment Real Time" Content (required): Our require…Jyothi Gorantla 31 views 4 comments 0 points Most recent by Jyothi Gorantla Reporting and Analytics for HCM
-
Otbi report not shows data when used union allDear , I created one OTbi report for absences , it shows data fine but when i used union all for same its not shown data why ? can anyone help me? Thanks
-
Where can we find Leave Balance in OTBI Subject areaDear , I want to leave balances for my users i created a otbi report (Workforce Management Absence Real time) but cant able to find leave balances in front i can see tha…
-
OTBI does not show accrual/absence balance dataSummary: I'm trying to create a report which shows an employee's accrual. However it does not show any data in OTBI. Content (required): I want to create a report in OTB…Nicolas Vahman 322 views 8 comments 0 points Most recent by Sandeep001rp Reporting and Analytics for HCM
-
Adding Department to existing report - Employee Absence CalendarSummary: We are using the report - Employee Absence Calendar - from here - https://community.oracle.com/customerconnect/discussion/70219/employee-absence-calendar/p1 it …Ian.Gooderham 61 views 6 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
User account data restriction issueSummary: Data Restriction issue. Content (required): Hi Team, Me and my HR using same admin user account. And in my organization we have one of the report called Leave B…
-
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 42 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 201 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM