Global Absence Entry Validation based on P_occurances in GET_ABSENCE_COUNTS function is not working.
I am using the code below in my validation formula.
I want to validate from more than 3 occurrences for the leave type, but I am starting with greater than zero to check if the code is working. Formula is not validating on entry, even though I have more than 1 previous taken transactions for this leave type. Does anyone have an idea where I am going wrong in my formula please?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
DEFAULT FOR IV_START_DATE IS '4712/12/31 00:00:00' (date)