Life Event Fast Formula Not Working (Doc ID 2382510.1)

Last updated on MARCH 12, 2024

Applies to:

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

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