EEXBR9.1: Stage Payment Fails With "Single-Row Subquery Returns More Than One Row" Error At Step EX_STAGE_PMT.UPDATE.UPAD_BRL (Doc ID 2095782.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Symptoms

Stage Payments process fails when processing when staging Cash Advance.

Steps:
------------
1) Employee has 2 Employee Profiles. Each Profile has an associated Bank Account with Payment Method = EFT.
2) Create and submit a Cash Advance.
3) Approve the Cash Advance.
4) Run Stage Payments process

Process goes to No Success with following error:

-- 10.07.15 ...(EX_STAGE_PMT.UPDATE.UPAD_BRL) (SQL)
UPDATE PS_EX_ADVNCE_PYMNT SET PYMNT_MODALITY_BRL = ( SELECT
PYMNT_MODALITY_BRL FROM PS_EX_EE_PYMNT_DTL WHERE EMPLID =
PS_EX_ADVNCE_PYMNT.EMPLID AND BANK_SETID =
PS_EX_ADVNCE_PYMNT.REMIT_BANK_SETID AND BANK_CD =
PS_EX_ADVNCE_PYMNT.REMIT_BANK_CD AND BANK_ACCT_KEY =
PS_EX_ADVNCE_PYMNT.REMIT_BNK_ACCT_KEY), DOC_PURPOSE_ID_BRL = ( SELECT
DOC_PURPOSE_ID_BRL FROM PS_EX_EE_PYMNT_DTL WHERE EMPLID =
PS_EX_ADVNCE_PYMNT.EMPLID AND BANK_SETID =
PS_EX_ADVNCE_PYMNT.REMIT_BANK_SETID AND BANK_CD =
PS_EX_ADVNCE_PYMNT.REMIT_BANK_CD AND BANK_ACCT_KEY =
PS_EX_ADVNCE_PYMNT.REMIT_BNK_ACCT_KEY) WHERE PROCESS_INSTANCE = 18833 AND
PYMNT_MODALITY_BRL = ' ' AND EXISTS ( SELECT 'X' FROM PS_EX_EE_PYMNT_DTL
WHERE EMPLID = PS_EX_ADVNCE_PYMNT.EMPLID AND BANK_SETID =
PS_EX_ADVNCE_PYMNT.REMIT_BANK_SETID AND BANK_CD =
PS_EX_ADVNCE_PYMNT.REMIT_BANK_CD AND BANK_ACCT_KEY =
PS_EX_ADVNCE_PYMNT.REMIT_BNK_ACCT_KEY)
/
-- Row(s) affected: 0
-- 10.07.16 Process 18833 ABENDED at Step EX_STAGE_PMT.UPDATE.UPAD_BRL (Action SQL) -- RC = 1427
ROLLBACK
/
-- 10.07.16 SQL Error: ORA-01427: single-row subquery returns more than one row.

Changes

Cause

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