PO approval workflow error with approving PO
When PO is getting approved we receive the following error message.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Approval workflow database error occurs while approving Standard Purchase Order 500060554
Contact your system administrator to identify the problem and to use SQL*Plus or Workflow Monitor to reactivate the approval workflow where it left off.
Give your system administrator the following information:
PL/SQL procedure: PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO
Error: ORA-00060: deadlock detected while waiting for resource
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Can you please help us in resolving this issue permanently.
Thanks a lot.