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
Not getting the exact data by using ANC_ABS_ENTRS_ABSENCE_STATUS_CD = 'SCHEDULED'
Summary:
While using the ANC_ABS_ENTRS_ABSENCE_STATUS_CD = 'SCHEDULED' we want to count all the scheduled absence from 1 jan to 31 dec but when we are using ANC_ABS_ENTRS_ABSENCE_STATUS_CD = 'SCHEDULED' this it is counting and throwing null value.
While using ANC_ABS_ENTRS_ABSENCE_STATUS_CD = 'SUBMITTED' it i counting scheduled but as well as Completed also
i tried many methods even 'COMPLETED' is also not working
so how to count the Scheduled Absence only
Ref- all lookups values of Absence Status in the Absence Record Page Stores in the lookup type "ANC_PER_ABS_ENT_DISPLAY_STATUS"
Tagged:
0