Still Getting Workflow Error WFENG_ITEM_UNIQUE Even When There Is Only 1 Subscription To The Business Event oracle.apps.per.irc.common.notifications

(Doc ID 1924403.1)

Last updated on OCTOBER 30, 2017

Applies to:

Oracle iRecruitment - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

There are no notifications being sent in iRecruitment as the error below is getting raised in Oracle Workflow:

Event Error Name: WFENG_ITEM_UNIQUE
Event Error Message: 3122: Duplicate item 'IRC_NTF/<nnnnn>' could not be created.
Event Error Stack:
Wf_Engine_CreateProcess(IRC_NTF, <nnnnn>, IRC_NOTIFICATION_PRC)
IRC_NOTIFICATION_WORKFLOW_PKG.launchNotificationsWorkflow(oracle.apps.per.irc.common.notifications, <alphanumeric code>)

According to the note below, the fix is to only have 1 enabled subscription to the business event oracle.apps.per.irc.common.notification:
<Note 1313111.1> - SYSADMIN User Receives Error Notification: 'An Error occurred in the following Event Subscription: Event Subscription'

But based on the results of the sql queries from the note above, there is only 1 subscription to the event. So why is the issue still happening in the instance?

 

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