My Oracle Support Banner

Life Event Fast Formula Not Working (Doc ID 2382510.1)

Last updated on JANUARY 30, 2020

Applies to:

Oracle Fusion Benefits Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal


Life Event FF not working


Requirement:
Client currently using US LE to hire employees from other countries where there is no legal entry defined
Client has a requirement to trigger New Hire Life event for employees whose assignment location country is US only.

Other locations with Country outside US shouldn't get the New Hire Life event.

For those employees work location will be outside of US so they shouldn't get the new life life event triggered.

To achieve this requirement, client wrote a FF as below to look for Employee Assignment Work location country.

Fast Formula:

DEFAULT FOR PER_ASG_LOC_COUNTRY IS 'abc'
DEFAULT FOR PER_ASG_ASSIGNMENT_ID IS 0
DEFAULT for ACP_HIRE_DATE IS '4712/12/31 00:00:00' (date)

l_return = 'N'


CHANGE_CONTEXTS(HR_ASSIGNMENT_ID = PER_ASG_ASSIGNMENT_ID, EFFECTIVE_DATE = ACP_HIRE_DATE)
(
log = ess_log_write('PER_ASG_LOC_COUNTRY => ' + PER_ASG_LOC_COUNTRY)
IF(PER_ASG_LOC_COUNTRY ='US')
THEN
(l_return='Y')
)


return l_return

Issue:

This FF is working as expected when they create a person change based on "Per_all_assignments_m" and Assignment_id Column but not working with other tables like per periods_of_service.

Even though it is working with Assignments table context that doesn't solve client requirement because when create additional assignment for a person life event will be triggered.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.