Get Started with Redwood for Oracle Cloud HCM Begin Now
Single day Entry for each absence duration
Summary
Single day Entry for each absence durationContent
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.
Tagged:
1