Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Query to Pull Reported Time and Absences Entered on a Timecard
We have requirement to list time entered on timecards in a report, the output needs to match the exact name of what's been displayed and entered in Timecard.
For instance, employee enters 8 hours of Regular, the report needs to be display 8 hours of regular rather than 8 hours of Reg base pay element.
With our custom SQL we are able to pull reported time underlying element used on layout sets, not the display of the timecard Element or absence type used.
If you anyone have insights or SQL on pulling display value and entered time that would be great.
0