The new hire coverage start date formula is giving error while evaluating — Cloud Customer Connect
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

The new hire coverage start date formula is giving error while evaluating

We are getting the following error while evaluating the new hire event -

We are using the following formula and are unable to troubleshoot -

DEFAULT FOR PER_REL_ORIGINAL_DATE_OF_HIRE is '1951/01/01 00:00:00'(date)
DEFAULT FOR PER_PER_LATEST_REHIRE_DATE is '1951/01/01 00:00:00'(date)
DEFAULT FOR ACP_HIRE_DATE is '1951/01/01 00:00:00'(date)

l_asg_id = GET_CONTEXT(HR_ASSIGNMENT_ID,0)
l_effective_date = GET_CONTEXT(EFFECTIVE_DATE, to_date('1951/01/01 00:00:00'))

l_hire_date = PER_PER_LATEST_REHIRE_DATE

if (PER_PER_LATEST_REHIRE_DATE WAS DEFAULTED) then
(
l_hire_date =ACP_HIRE_DATE
)

L_TEMP = ESS_LOG_WRITE('log start ************ l_hire_date '+ to_char(l_hire_date) )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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