PO Approval Process Stuck Randomly. Debug Errors: PO_REQAPPROVAL_INIT1.send_error_notif ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2774565.1)

Last updated on JUNE 08, 2022

Applies to:

Symptoms

Purchase Orders sometime get stuck in the Approval Process when using Approvals Management Engine (AME).

Workflow status activities as per EBS Procurement Approval Analyzer <Document 1525670.1> shows:

1 08-APR-21 11:31:36                                ROOT/PARALLEL_APPROVAL_PROCESS ACTIVE #NULL
1 08-APR-21 11:31:36 08-APR-21 11:31:36 PARALLEL_APPROVAL_PROCESS/START COMPLETE #NULL
1 08-APR-21 11:31:36 08-APR-21 11:31:36 PARALLEL_APPROVAL_PROCESS/PO_NEW_COMMUNICATION COMPLETE Y
1 08-APR-21 11:31:36 08-APR-21 11:31:36 PARALLEL_APPROVAL_PROCESS/PDF_GENERATION COMPLETE
1 08-APR-21 11:31:36 08-APR-21 11:31:36 PDF_GENERATION/START COMPLETE #NULL
1 08-APR-21 11:31:36 08-APR-21 11:31:36 PDF_GENERATION/DELETE_PDF_ATTACHMENTS COMPLETE
1 08-APR-21 11:31:36 08-APR-21 11:31:36 PDF_GENERATION/GENERATE_PDF_AME_BUYER COMPLETE
1 08-APR-21 11:31:36 08-APR-21 11:31:36 PDF_GENERATION/END COMPLETE #NULL
1 08-APR-21 11:31:36                                PARALLEL_APPROVAL_PROCESS/WAITFORCONCURRENTPROGRAM NOTIFIED

Also, Document Action History shows wrong sequence and 'No action' :
SEQUENCE_NUM   ACTION_DATE    ACTION_CODE
           1                  29-Apr-21          SUBMIT
           2                  29-Apr-21        NO ACTION
           2                  29-Apr-21          APPROVE
           2                  29-Apr-21        NO ACTION

Additional information taken from PO & workflow debug logs :

itemtype: POAPPRV itemkey: 263095-198483 Message Text: po.plsql.PO_AME_WF_PVT.insert_action_history:010
itemtype: POAPPRV itemkey: 263095-198483 Message Text: PO_REQAPPROVAL_INIT1.send_error_notif: 10
itemtype: POAPPRV itemkey: 263095-198483 Message Text: PO_REQAPPROVAL_INIT1.send_error_notif: 20 username: doc: Standard Purchase Order 2020020527 location: 020 error msg: ORA-01422: exact fetch returns more than requested number of rows
itemtype: POAPPRV itemkey: 263095-198483 Message Text: po.plsql.PO_AME_WF_PVT.insert_action_history:020

po.plsql.PO_AME_WF_PVT.get_next_approvers:030 Calling AME API with
transaction id
po.plsql.PO_AME_WF_PVT.get_next_approvers.040: g_next_approvers.count:0
l_completeYNO:  W

Steps to reproduce the issue :

------------------------------------

1. Create PO.

2. Submit it for approval.

3. PO remains stuck In Process.
 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.