Change request is getting stuck in the workflow

Symptom: Requestor gets an error notification email with the following subject
"Approval workflow database error occurs while approving Purchase Requisition" and change request gets stuck in the workflow at the below workflow node.

Reason:
Item type: POREQCHA
Activity: "VERIFY_APPROVER_AUTHORITY"
WF Error message: User-Defined Exception
Error stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY, POREQCHA,

Workaround: Retry the WF fixes the issue and workflow moves to the next node successfully.

LTF: There is a Oracle patch for this. Work with Oracle to get the patch.

Requisition not getting approved || Requisitoin remains in IN PROCESS || User-Defined Exception||Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.VE

Issue:
Requisition is not getting approved. It remains in "IN PROCESS" status.


Symptom:
--Requestion remains in IN PROCESS status when viewed in iProc.
--No error notification is generated.


Facts:
1> Preparer and requestor are different persons.
2> Last approver has approved the requisition and has all the authorization limit. But still the requisition is in IN PROCESS status.


Reason:
Requisition is in error in the REQAPPRV workflow at following node,
Node: VERIFY_APPROVER_AUTHORITY
Process:VERIFY_APPROVER_AUTH_APPROVE
Error message:User-Defined Exception
Error stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY, REQAPPRV, ...


Suggested Fix:
Login to Oracle apps>Workflow Administrator>Status monitor>Retry the workflow for the ITEM TYPE:REQAPPRV and for the item key