You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

absence validation formula does not consider those rejected or awaiting approval

good morning experts

I am using the following formula but it considers rejected and awaiting approval absence statuses.

Could you help me exclude those states from the absence sum?

formula

DEFAULT FOR IV_START_DATE IS '4712/12/31 00:00:00' (date)

DEFAULT FOR IV_END_DATE IS '4712/12/31 00:00:00' (date)

DEFAULT for IV_TOTALDURATION is 0

DEFAULT_DATA_VALUE for ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR is 0

DEFAULT FOR ANC_ABS_ENTRS_ABSENCE_TYPE_ID is 0

DEFAULT FOR ANC_ABS_TYP_NAME IS ' '

DEFAULT FOR ANC_ABS_ENTRS_END_DATE IS '4712/12/31 00:00:00' (date)

DEFAULT FOR ANC_ABS_ENTRS_START_DATE      IS '0001/01/01 00:00:00' (DATE)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!