Getting Error While Submitting PO: ORA-00001: unique constraint (APPLSYS.WF_NOTIFICATIONS_PK) violated (Doc ID 2092841.1)

Last updated on DECEMBER 29, 2015

Applies to:

Oracle Workflow - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Approvals - Req, PO

When attempting to submit PO for approval
the following error occurs.

ERROR
-----------------------
NOTIFY_APPROVER_SUBPROCESS_WGP/PO_PO_APPROVE_PDF ERROR #EXCEPTION

> The error details are:

Activity RESULT Error Name
--------------------------------------------- --------------- ------------------------------
Error Message
------------------------------------------------------------------------------------------------------------------------------------
Error Stack
------------------------------------------------------------------------------------------------------------------------------------
PO_PO_APPROVE_PDF #EXCEPTION -1
ORA-00001: unique constraint (APPLSYS.WF_NOTIFICATIONS_PK) violated
Wf_Notification.SendSingle(CC338500, POAPPRV, PO_PO_APPROVE_PDF, WF_ENGINE.CB)
Wf_Notification.Send(CC338500, POAPPRV, PO_PO_APPROVE_PDF, WF_ENGINE.CB)
Wf_Engine_Util.Notification_Send(POAPPRV, 434432-275086, 306683, POAPPRV:PO_PO_APPROVE_PDF)
Wf_Engine_Util.Notification(POAPPRV, 434432-275086, 306683, RUN)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit PO for approval
2. Workflow fails in the reported error

Cause

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