New work relationship Life event should not trigger — 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

New work relationship Life event should not trigger

edited Sep 5, 2020 12:10AM in Benefits

Summary

New work relationship Life event should not trigger

Content

Hi All,

We have requirement, in CANADA we have 3 legal entities, if Employee moving from among these 3 Legal entities then Newwork Relationship life event should not trigger. I have written below fast formula and still Life event is triggering.

 

DEFAULT FOR PER_ASG_EFFECTIVE_START_DATE IS '0001-01-01 00:00:00' (DATE)
DEFAULT for BEN_PPS_IN_LEGAL_ENTITY_ID is 99999999
DEFAULT for BEN_PPS_IO_LEGAL_ENTITY_ID is 99999999
 
inputs are BEN_PPS_IN_LEGAL_ENTITY_ID, BEN_PPS_IO_LEGAL_ENTITY_ID
l_eff_date=GET_CONTEXT(EFFECTIVE_DATE, to_date('1951/01/01 0:00:00'))
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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