For more information, please refer to this announcement explaining best practices for getting answers to questions.
Alert is built based on action_code = 'HIRE' but still alert getting triggered for 'Global Transfer'
Summary:
I have built Alert based on action_code = 'HIRE' on the 20th and 40th day after joining, but still employee getting 20th and 40th day notification after completion of 'Global Transfer' & 'Create WR'
Content (please ensure you mask any confidential information):
Below is the expression built in alert, which specifies that action_code = 'HIRE' But why employee getting notifications after 'Global Transfer' & 'Create WR' ? When we do 'Global Transfer' & 'Create WR' we don't use action_code 'HIRE' we only specify start date.
${StartDate} Like SYSDATE-40
${StartDate} Like SYSDATE-20
exists(select 1 from per_all_assignments_m where action_code = 'HIRE' and assignment_type = 'E' and person_id = ${PersonId})