Get absence plan balance as of certain date in Oracle

Summary:

I am reaching out regarding the option to get absence balance in fast formula. Mentioned below the configuration set up and the data structure:-

• We have set up a front loaded plan with accrual dates from 1-Jan to 31-Dec,

I have run the accrual for the employee for 3 periods starting from 1-Jan-2025 to 31-Dec-2027

Content (please ensure you mask any confidential information):

As part of our rollover option we are trying to rollover upto 10 days of balance to the rollover plan and the rollover plan limit should not exceed 25 days.
To achive this we have tried using the GET_PLAN_BALANCE and GET_BAL_COMP_VAL function. Upon running the "Calculate Accrual Plan Balance" process,