Absence and Accrual
Discussion List
-
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…Marcus Aurelius 12 views 2 comments 0 points Most recent by Marcus Aurelius Reporting and Analytics for HCM -
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 26 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…
-
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 12 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM
-
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 24 views 4 comments 0 points Most recent by Jyothi Gorantla 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 40 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle 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 24 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 41 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…
-
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 47 views 2 comments 2 points Most recent by Monique Dias Reporting and Analytics for HCM -
What table is absence Plan Period Start Date stored?Please see sample screenshot:notautomni9 19 views 1 comment 0 points Most recent by Mandeep Gupta 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 25 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 11 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 25 views 10 comments 0 points Most recent by Mandeep Gupta 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…User_4NHZO 74 views 16 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Authorization error with REST API to move candidate between phases / statesSummary: Content (required): Hello everybody, We are trying to use the rest api made available by Oracle to move a cadidate present in the system in the ORC module betwe…Gerardo Peluso 22 views 3 comments 0 points Most recent by Mandeep Gupta 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 …
-
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 34 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 11 views 5 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Leave Balance Calculation date showing different than UI in BIP reportSummary: Hi Team, Leave Balance Caluclation date showing diffrent than UI in BIP report Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 11 views 16 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM