How to handle New Hires During Open Enrollment ( BENEFITS) — 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 Started with Redwood: Oracle Cloud SCM and Purchasing

How to handle New Hires During Open Enrollment ( BENEFITS)

edited Nov 6, 2023 7:29PM in Benefits 2 comments

Fast Formula for Enrollment Period End Date : " I tried replacing the 90 days with 31 Days in the below Fast Formula , Result is Enrollment window for New Hire shows Balance 31 Days Remaining, But for Open Hire Life event, it still Calculating HireDate +90 Days and allowing the employee to enroll only after 90 days instead of 31 days.

DEFAULT FOR ACP_HIRE_DATE IS '4712/12/31' (DATE)

RULE_VALUE = TO_CHAR(ADD_DAYS(ACP_HIRE_DATE,90))

RETURN RULE_VALUE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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