What's new in Customer Journeys?

Connect and learn more!
Absence Plan should be accrued once in a lifetime. — 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

Absence Plan should be accrued once in a lifetime.

Received Response
16
Views
1
Comments
edited Oct 25, 2023 8:27AM in HCM Communicate 1 comment

Summary:

Hi Folks,

Here i got requirement where the plan balance should be accrued only once a career to the employee. So i used the below Formula.

DEFAULT FOR PER_PER_WORK_RELATIONSHIP_MAX_DATE  IS '4712/12/31 00:00:00' (DATE)

l_hire_date = PER_PER_WORK_RELATIONSHIP_MAX_DATE

l_enrollment_Year = to_char(l_hire_date,'YYYY')

l_effective_date = GET_CONTEXT(EFFECTIVE_DATE, '4712/12/31 00:00:00' (date))

l_effective_date_Year = to_char(l_effective_date,'YYYY')


IF (l_enrollment_Year = l_effective_date_year) THEN

  accrual = 225

ELSE

accrual = 0 

RETURN Accrual


I used the above formula, but is is not working as expected . it is failing for the employees who hired past years. Please suggest which condition do i need to use.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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