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

BEN_PIL_LF_EVT_OCRD_DT DBI is not returning Life Event Occurred date its always 1951/01/01

Summary:

I want to get the Life event occurred date, So, I used BEN_PIL_LF_EVT_OCRD_DT DBI in the fast formula. but it always shows 1951/01/01

Content (please ensure you mask any confidential information):

DEFAULT FOR BEN_PIL_LF_EVT_OCRD_DT is '1951/01/01 00:00:00'(date)
DEFAULT FOR PER_ASG_ASSIGNMENT_ID is 0
DEFAULT for CMP_ASSIGNMENT_SALARY_ANNUAL_AMOUNT is 0
DEFAULT FOR PER_ASG_ATTRIBUTE1 IS '00'
ELIGIBLE = 'Y'

l_eff_date = BEN_PIL_LF_EVT_OCRD_DT

l_eff_new_hire = BEN_PIL_LF_EVT_OCRD_DT
l_eff_year_char = TO_CHAR(l_eff_date,'YYYY')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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