My Oracle Support Banner

Oracle Fusion Benefits: Not Able to Trigger a Life Event Based on EIT Changes (Doc ID 2239991.1)

Last updated on JANUARY 14, 2020

Applies to:

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

Goal

Requirements :
I am trying to trigger a life event based on changes in a person's EIT

In EBS : The table "PER_PEOPLE_EXTRA_INFO" was in the "Table Name" LOV

Issue : I am not able to identify the table that could trigger the change

I tried using the below formula (type = "Person Change Causes Life Event" ) and still not working cause I am not able to trigger the change ( i did use the formula override though) but I was not able to find "IN" and "IO" for any of the EIT fields

Formula :

DEFAULT_DATA_VALUE for PER_PERSON_EIT_ALL_PEI_INFORMATION2 is 'N/A'
DEFAULT_DATA_VALUE for PER_PERSON_EIT_ALL_PEI_INFORMATION_CATEGORY is 'N/A'

k = 1
l_return = 'N'

WHILE (PER_PERSON_EIT_ALL_PEI_INFORMATION2.EXISTS(k))
LOOP
(
l_medicare_EIT = PER_PERSON_EIT_ALL_PEI_INFORMATION_CATEGORY[k]
l_Medicare_Status = PER_PERSON_EIT_ALL_PEI_INFORMATION2[k]

if l_medicare_EIT = 'RA Medicare Eligible' and l_Medicare_Status = 'Y' Then
l_return = 'Y'
k= k + 1
)

Return l_return
 

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.