Last updated on DECEMBER 03, 2016
Applies to:Oracle iRecruitment - Version 18.104.22.168 to 22.214.171.124 [Release 11.5.10]
Information in this document applies to any platform.
iRecruitment - Version: 11.5.10
Find when running the sql below, it is showing very many open iRecruitment failed workflow notifications
select message_type, status, mail_status, count(*)
where message_type like 'IRC%'
and status = 'OPEN'
group by message_type, status, mail_status
Message Status Mail Count
IRC_WF OPEN Failed 784792
IRC_WF OPEN Sent 308142
IRC_WF OPEN Errored 145
IRC_WF OPEN 4345
IRC_WF OPEN Unavail 170
When reviewing the notifications listed in the following navigations it seems the largest volume
are not listed in iRec
System Administrator Responsibility
Oracle Applications Manager>Workflow
Expand Workflow Metrics Workflow Items
Click on Active items
Select iRecruitment>View Details
Click Abort All button
select * from wf_notifications
where subject = 'New Jobs Alert'
It seems the volume are from the failed wf notifications for the new jobs alert
How can these get purged and why are there so many failed?
Why are there so many 'New Jobs Alert' WF failures open and how does one view and purge these
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms