What's new in Customer Journeys?

Connect and learn more! ×
GET_BAL_COMP_VAL returning 0 — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GET_BAL_COMP_VAL returning 0

Received Response


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!