Data of ANC_PER_ABS_ENTRY_DTLS table is inconsistent — 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

Data of ANC_PER_ABS_ENTRY_DTLS table is inconsistent

edited Apr 16, 2025 11:54PM in Benefits 3 comments

We have a requirement where a custom BI report used to extract the annual accrual entitlement for the Absence Plan called Wellness Days. The report is run annually. The logic for Wellness Days accruals is based on the number of Sick Leave Absences taken throughout the year. Employees who have taken more than 3 days of Sick Leave are not entitled to Wellness Days whereas Employees whose Sick Leave is 3 days or less are entitled to Wellness Days.

But for some the cases where Sick leave over lapping between two years then absence duration not calculating currently.

Instead of ANC_PER_ABS_ENTRIES, we supposed to use ANC_PER_ABS_ENTRY_DTLS to calculate the duration.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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