How to get the 'Plan Period Start Date' in absence plan balances? — 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

How to get the 'Plan Period Start Date' in absence plan balances?

edited Jun 1, 2023 2:09AM in Reporting and Analytics for HCM 6 comments

I am creating a report that would output each plan's balances by year. But this one sample, for 2023, its calculation started from 2022, it's a bit complex I think.

For its 2023 balance calculation, it'd be 11/17/2022 up to current date

For its 2022 balance calculation, it'd be 11/17/2022 up to 12/31/2022

the first entry for the date 11/17/2022 is of type COVR



I'll be using the ANC_PER_ACRL_ENTRY_DTLS table to calculate.



Thanks!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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