Absence and Accrual
Discussion List
-
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached …Vasanthakumar Ravi 132 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Unable to Extract 2026 Holiday EntitlementSummary: Hello there - I'm trying to evidence each workers 2026 holiday entitlement but the standard HCM accrual reports only seem to be set up to report accural balance…Dave at Miller 16 views 0 comments 0 points Started by Dave at Miller Reporting and Analytics for HCM -
How to use Work schedule in Eligibility for Fast FormulaSummary: Hi Team, we have a requirement : We have a Absence Type- That should be eligible to only employees who are having work schedule A. How to make it possible in El…
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…User_2025-02-04-13-27-19-123 141 views 5 comments 0 points Most recent by Liyaquath Ahmad Reporting and Analytics for HCM -
Multiple Absence Actions Sharing the Same Object IDThere was an error rendering this rich post.
-
Incorrect values are appearing in OTBI report for leave durationSummary: We have created OTBI report where we are fetching absence details based on year and month (monthly absence report). If employee has taken leave for single month…
-
Absence Plan: Monthly Accrual That Expires at Month-EndHi, I want to create an absence plan where each employee receives 1 day of leave every month (this part is clear for me). The requirement is that if the employee does no…
-
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.4K views 17 comments 4 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Need inputs to fetch the Absence "Plan Use" informationSummary: Need inputs to fetch the Absence "Plan Use" information Content (please ensure you mask any confidential information): In the absence records, we need to fetch …
-
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.7K views 21 comments 3 points Most recent by Raymund J 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…
-
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…Jin Yus 60 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Seniority based shift assignments in workforce schedulingSummary: The requirement is to assign the shifts in accordance with CBA seniority date rules to the employees and then allowing employees to claim shifts accordingly. Re…Chaitanya Mantripragada 6 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Unable to see data in "VOIDED_BY" and "VOIDED_DATETIME" in ANC_PER_ACRL_ENTRY_DTLS tableSummary: Unable to see data in "VOIDED_BY" and "VOIDED_DATETIME" in ANC_PER_ACRL_ENTRY_DTLS table Content (please ensure you mask any confidential information): We are a…
-
Absence Record Not showing after Global Transfer Or TerminationSummary: Hi Guys, I’m unable to view the absence records after an employee is terminated or globally transferred. Could anyone please help me understand what might be ca…Dharani Dhar Gupta 38 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…JSAHOO1988 18 views 3 comments 0 points Most recent by Anusha Bhat-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 5K views 8 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
OTBI Report Is Not Showing Any Employee's Absence DataHello Everyone Summary: We developed an OTBI report to extract employee absence details (leave balance, unapproved leaves, total leaves taken, etc.) using the Workforce …Andriampeno Odilon 71 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Report: Missing Seniority, Entitlement, and Vacation BalanceI’m building the Employee Vacation and Sick Leave Balance Report in OTBI with the following filters: Assignment Status is in Active – No Payroll, Active – Payroll Eligib…
-
Accruals on Payroll Activity ReportSummary: Payroll Activity Report is pulling PTO Accruals as of Inception to Date for Rehires which is incorrect. Content (please ensure you mask any confidential informa…Ayesha Islam 18 views 2 comments 0 points Most recent by Ayesha Islam Reporting and Analytics for HCM
-
Can we set the absence accrual repeating period to daily?Summary: Can we set the absence accrual repeating period to daily? I tried searching for the delivered Daily Calculation repeating period in the absence accrual plan, bu…Shannon Teves 17 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
Fast Formula for getting balance avail date in Oracle Absence Management?Summary: fast formula for getting balance avail date in Oracle Absence Management Content (please ensure you mask any confidential information): I need a fast formula fo…Ruvina Khan 34 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme…Vasanthakumar Ravi 17 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 18 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
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…
-
Absence Plan Use report via OTBII need to create an Analysis report in OTBI (I am new to this so I have not yet able to create reports etc) that will show employees sickness absence and the days used a…Julie Searles 295 views 7 comments 0 points Most recent by Gillian Kilbride Reporting and Analytics for HCM -
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 43 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
Change to absence start or end date - event level reportingSummary: We have a requirement to report on changes to absence start and end dates i.e. when someone edits an existing absence. The OTBI Subject Areas are all Real Time …Amanda Hope 29 views 3 comments 0 points Most recent by Shivam Trivedi-Oracle Reporting and Analytics for HCM
-
How to eliminate duplicate measure after joining 2 OTBI subject areaSummary: Hi all, I have a report with 2 subject areas (HCM and Projects) Is there a way to show for highlighted values 8, instead on 40 reported hours? Basically is the …Raluca Balan-Oracle 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM