My Oracle Support Banner

Irc_wf Message Type Stays in Open Status/Purge Obsolete Process Can't Clear (Doc ID 796556.1)

Last updated on OCTOBER 26, 2023

Applies to:

Oracle iRecruitment - Version to [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(*)
from wf_notifications
where message_type like 'IRC%'
and status = 'OPEN'
group by message_type, status, mail_status


Message Status Mail Count
Type Status

IRC_WF OPEN Failed 784792
IRC_WF OPEN Sent 308142
IRC_WF OPEN Errored 145
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
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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.