workflow for an invoice is going into below exception at AP_WORKFLOW_PKG.CHECK_HEADER_REQUIREMENTS.

Hello team,

users have submitted invoice for workflow approval and then invoice workflow got errored at CHECK_HEADER_REQUIREMENTS activity. In this activity we are using the standard package 'AP_WORKFLOW_PKG.CHECK_HEADER_REQUIREMENTS'.

As we observed that invoice got into exception with the below exception format.

WF_CORE.CONTEXT('APINVLDP','Check_Header_Requirements',itemtype, itemkey,

                 to_char(actid), funcmode);

Also, while verifying the error message it is showing 'ORA-01427: single-row subquery returns more than one row'.

Since AP_WORKFLOW_PKG.CHECK_HEADER_REQUIREMENTS is a standard flow, I am not getting where exactly the subquery is returning more than one row and also as per my analysis i couldn't find any subquery in the procedure.