How to get absence plan accrual balance using GET_ACCRUAL_BALANCE formula

Summary

GET_ACCRUAL_BALANCE formula function is not returning the correct balance value

Content

We have a requirement which requires using the GET_ACCRUAL_BALANCE formula. Below is a sample Global Absence Accrual formula that we are using for testing;

ln_assignment_id = GET_CONTEXT(HR_ASSIGNMENT_ID,0) L_Person_Id = GET_CONTEXT(PERSON_ID,1) L_Eff_Dt = GET_CONTEXT(EFFECTIVE_DATE,'0001/12/31 00:00:00' (date)) L_Accrual_Plan_ID = GET_CONTEXT(ACCRUAL_PLAN_ID,0) L_Leave_Balance = GET_ACCRUAL_BALANCE() l_txt_o = 'L_Leave_Balance'||to_char(L_Leave_Balance) l_log = ESS_LOG_WRITE(l_txt_o) accrual = 2.5