GET_BAL_COMP_VAL returning 0
Summary:
Plan Term is 1st Sep to 31st Aug. Employee enrolled into the Plan as on 1st Sep 2023, I did load initial balance as on 1st Sep 2023. Ran the accrual for the period 1st Sep 2023 to 31st Aug 2024. Issue is if i calll function GET_BAL_COMP_VAL with parameters as 1st Sep 2023 and 15th Dec 2023 for Initial Load
GET_BAL_COMP_VAL('A',to_date('2023/09/01'),to_date('2023/12/15'),'INIT') it always returns 0. Can you please advise what am I missing.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):