Why does two accrual type entries get created while loading Compensatory accrual plan types? — 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

Why does two accrual type entries get created while loading Compensatory accrual plan types?

in Workforce Management 2 comments

Summary:

When we do a HDL load for Absence Accrual for Compensatory plan type, two rows with different accrual entry type in the ANC_PER_ACRL_ENTRY_DTLS table - "ORA_ANC_COMPTIME" and "ORA_ANC_COMPTIME_DL" are getting created with SAME VALUE whereas in UI i am seeing only record with one value for this entry.

I have a requirement to query the balance as of a parameter date, and when I do so, the values are doubled.

I would like to understand which type I should use in my balance calculation as of a parameter date.

For example, for an employee, the balance as on 06/01 in UI is 1.75 hours, whereas in the backend table i see 2 rows with 1.75 hours each.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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