Global Absence Entry Validation based on P_occurances in GET_ABSENCE_COUNTS function is not working.

Summary:

I am using the code below in my validation formula.

Content (required):

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):

23B

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)