GET_PLAN_BALANCE function is not returning value in Absence entry validation formula

Summary:

I am trying to get the accrual plan balance for my absence plan using get_plan_balance in absence entry validation formula. But, the function is returning zero where as the accrual balance is 23. Has any one used it? Please provide your inputs.

Example:

---------

Employee is having 40 days leave balance and trying to submit the leave request for Feb 2023/March 2023 today(sysdate). Its throwing validation error saying "plans does not having the balance ".

Content (required):

Version (include the version you are using, if applicable):

22D

Code Snippet (add any code snippets that support your topic, if applicable):