Absence Entry Validation formula failed to restrict gap between Parental Leave and Sick Leave — Cloud Customer Connect
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

Absence Entry Validation formula failed to restrict gap between Parental Leave and Sick Leave

Hello Experts,

We have the requirement that "After parental leave, 4 weeks of work are required before self-certification sick leave can be used" and to achieve this the following logic is applied. But the entry validation is not working and sick leave is getting submitted after Parental leave

/*==========================================================FORMULA TYPE: Global Absence Entry Validation============================================================*/

DEFAULT FOR IV_START_DATE IS '4712/12/31' (date)DEFAULT FOR IV_END_DATE IS '4712/12/31' (date)DEFAULT FOR IV_TOTALDURATION IS 0DEFAULT FOR PER_ASG_START_DATE IS '4712/12/31' (date)DEFAULT FOR ANC_ABS_ENTRS_DURATION IS 0DEFAULT FOR ANC_ABS_TYP_NAME IS ' 'DEFAULT FOR ANC_ABS_TYP_DURATION_UOM_CD IS 'D'DEFAULT_DATA_VALUE FOR ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR IS 0DEFAULT FOR ANC_ABS_ENTRS_ABSENCE_TYPE_ID IS 0DEFAULT FOR ANC_ABS_ENTRS_ABSENCE_STATUS_CD IS ' 'DEFAULT FOR ANC_ABS_ENTRS_APPROVAL_STATUS_CD IS ' 'DEFAULT FOR ANC_ABS_ENTRS_START_DATE IS '4712/12/31' (date)DEFAULT FOR ANC_ABS_ENTRS_END_DATE IS '4712/12/31' (date)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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