My Oracle Support Banner

R12:Initiate Invoice Workflow Approval Get Header Approver Activity Failed with Error 'ORA-01427: single-row subquery returns more than one row' (Doc ID 2441827.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to initiate approval for invoice
the following error occurs.

ERROR
Failed activity: Get Header Approver
Activity Type Function

Error Name -1427

Error Message ORA-01427: single-row subquery returns more than one row

Error Stack AME_ENGINE.fetchRuntimeGroup(6366033) AME_ENGINE.getRuntimeGroupMembers(6366034) AME_AG_CHAIN_HANDLER.handler(6366035) AME_ENGINE.processActionType(6366036) AME_ENGINE.processRules(6366037) AME_ENGINE.updateTransactionState(6366038) AME_ENGINE.updateApprovalStatus(6366039) AME_API2.updateApprovalStatus2(6366040) APINVAPR.process_doc_approval(APINVAPR, 6231733-1, 303382, RUN) Wf_Engine_Util.Function_Call(AP_WORKFLOW_PKG.PROCESS_DOC_APPROVAL, APINVAPR, 6231733-1, 303382, RUN)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


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