Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Script to find approved absences not transferred to Fusion Payroll
Summary
Script to find approved absences not transferred to Fusion PayrollContent
Below script will find all the approved absences that are not transferred to Fusion payroll
Please change the Period Start Date and Period End date based on the requirement that is highlight in red below
SELECT PER.PERSON_NUMBER "Employee Number",
TYP_VL.NAME "Absence Type",
ABS.START_DATE "Absence Start Date",
TO_CHAR(ABS.START_DATETIME,'hh24:mi') "Start Time",
ABS.END_DATE "Absence End Date",
TO_CHAR(ABS.END_DATETIME,'hh24:mi') "End Time",
ABS.DURATION "Absence Duration"
FROM fusion.anc_per_abs_entries ABS,
fusion.anc_absence_types_vl TYP_VL,
Tagged:
2