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

Last updated on DECEMBER 03, 2016

Applies to:

Oracle iRecruitment - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
iRecruitment - Version: 11.5.10



Goal

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

Results

Message Status Mail Count
Type Status

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
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
transactions?


Solution

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