Notification Failed When Method Is Email "PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO ORA-00060: deadlock detected while waiting for resource"

(Doc ID 2252662.1)

Last updated on APRIL 07, 2017

Applies to:

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

Symptoms

Application version 12.1.3

PO is Approved and Email Notification failed with message "Notification has been closed and did not require a response"

Workflow Ending with error:

MAIN_POAPPRV_PROCESS / EMAIL_DOC_PROCESS PO Approval Process Email PO ACTIVE
EMAIL_DOC_PROCESS / DOES_USER_WANT_DOC_EMAILED Email PO Does User want document e-mailed ERROR #EXCEPTION

Notification failing with error:

PL/SQL procedure: PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO
Error: ORA-00060: deadlock detected while waiting for resource

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