Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Report on retro absence records
Summary
Retro absence records for payrollContent
Hi all,
I am trying to modify a custom report to include absences that were added to the system during the pay cycle but was taken previously
For example:
Pay period between 08-22-2020 and 09-04-2020
Employee was out sick from 08-11-2020 to 08-17-2020 but the manager didn't add it to the system until 08-25-2020
Our report is looking for anyone that has time booked over the 80 hours per pay
The original query is
SELECT
SUM(absecedetails.duration)
FROM
anc_per_abs_entry_dtls absecedetails
WHERE
absecedetails.per_absence_entry_id = absence.per_absence_entry_id
Tagged:
0