Issue with Probation Period End Date Alerts — 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

Issue with Probation Period End Date Alerts

Summary:

Hi Everyone,

We have a requirement to create Probation period expiry alerts which will send an alert to Line Managers before Employee's Probation Period End Date.

This alert should trigger to Line Managers before 85 days , 20 Days and 10 Days to their Probation End Dates.

To achieve this requirement, we have taken resource as "Worker". and selected Match "Any" and added below conditions.

Ten

EXISTS(select 'X' from PER_ALL_ASSIGNMENTS_M paam,HR_LOCATIONS HL WHERE PAAM.LOCATION_ID = HL.LOCATION_ID AND SYSDATE BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE AND paam.ASSIGNMENT_STATUS_TYPE = 'ACTIVE' AND TRUNC(paam.DATE_PROBATION_END) =TRUNC(SYSDATE+10) AND paam.ASSIGNMENT_TYPE = 'E' AND HL.COUNTRY = 'PH' AND paam.PERSON_ID = ${PersonId})

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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