You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Single day Entry for each absence duration

edited Jul 21, 2020 2:20PM in Reporting and Analytics for HCM 7 comments

Summary

Single day Entry for each absence duration

Content

Hi All,

We have requirement where we need to fetch all the absences of employees as a single day entry. for example employee booked an leave for duration 10/07/2020 to 20/07/2020 so the output should be one row for 10/07/2020, second row 11/07/2020 and so on.

to achive above requirement i have used anc_per_abs_plan_entries table , this table stores the single day entry for each absence but only for absence type 'Annual Leave' and 'Sickness Leave' not for other type of leaves.

Can anyone please advise how can I achieve single day entry in a report output for all type of leaves.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!