iRecruitment Reminders Being Sent To The Wrong Person

(Doc ID 2204843.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle iRecruitment - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.


HW are running iRecruitment, and if the candidate has registered on the external tier a suitable FND row is created and the offer e-mail and offer expiry reminder notifications are sent successfully. If the candidate is entered manually by the HR department then the offer is sent by letter, and there is no FND row, hence no e-mail address for Workflow to use.
The problem seems to arise when the Offer reminder concurrent program runs. If an offer for a manually entered candidate is due to expire within the next 7 days then that offer is selected for a reminder e-mail, however if there is no FND row, the e-mail is being sent to the previous candidate also selected, which means that some candidates are receiving e-mails reminding them that their offer is due to expire and some mails telling them that an offer that was made to someone-else is due to expire.
The concurrent program that is running is iRecruitment Offer Expiry Notifications , which calls a PL/SQL package irc_offer_notifications_pkg.send_expiry_notification which is a seeded package, provided by file irofrnotif.pkh, /* $Header: irofrnotif.pkh 120.3.12010000.4 2011/05/17 13:55:31 nchinnam ship $ */ and irofrnotif.pkb /* $Header: irofrnotif.pkb 120.21.12010000.13 2012/08/21 11:26:51 sbaswa ship $ */

For the concurrent request to disregards the fact there is no FND username and send the email out to the correct person.


The issue can be reproduced at will with the following steps:
1. Manager creates candidate
2. Several candidates apply for a job
3. offer is extended to one of the candidates
4. When offer expiration concurrent requests runs over night a notification is sent to the wrong candidate. Notification is sent the the first candidate with an email if the actual candidate receiving the offer does not have an email address.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms