Get Started with Redwood: Oracle Cloud SCM and Purchasing
New work relationship Life event should not trigger
Summary
New work relationship Life event should not triggerContent
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:
0