My Oracle Support Banner

EAP -Brazil Localization - RECON RULE BNK_RCN_DISBRSE_VD - ABEND AT STEP FSPRECON.900-SQL.900-ST05 (Doc ID 2486600.1)

Last updated on JULY 21, 2020

Applies to:

PeopleSoft Enterprise FIN Payables Brazil - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

A bank statement has two lines with same date and amount, but different transaction codes.

Under reconciliation rule BNK_RCN_DISBRSE_VD an abend with the following error:

-- 14:01:34.303 .......(FSPRECON.900-SQL.900-ST05) (SQL)
UPDATE PS_BNK_DISBRVL_T4  SET RECON_STATUS = 'REC' , RECONCILE_OPRID = 'AUTO'
, RECON_TYPE = 'A' , RECON_RUN_ID = ' ' , RECON_CYCLE_NBR = 180830 ,
PYMNT_RECONCILE_DT = TO_DATE('2018-08-30','YYYY-MM-DD') , RECORD_SEQ_NUMBER =
( SELECT RECORD_SEQ_NUMBER FROM PS_BANK_STMT_TBL WHERE RECON_STATUS IN (
'UNR','AMT','DAT','TYP','REF','DUP' ) AND BNK_ID_NBR =
PS_BNK_DISBRVL_T4.BNK_ID_NBR AND BANK_ACCOUNT_NUM =
PS_BNK_DISBRVL_T4.BANK_ACCOUNT_NUM AND RECON_CYCLE_NBR = 180830 AND (('A' =
'A' AND PS_BNK_DISBRVL_T4.BANK_ACCT_RVL_AMT BETWEEN RECON_TRAN_AMT - 0 AND
RECON_TRAN_AMT + 0) OR ('A' = 'P' AND PS_BNK_DISBRVL_T4.BANK_ACCT_RVL_AMT
BETWEEN ROUND(RECON_TRAN_AMT - ((0) * ( RECON_TRAN_AMT)), 2) AND
ROUND(RECON_TRAN_AMT + ((0) * ( RECON_TRAN_AMT)), 2))) AND
PS_BNK_DISBRVL_T4.PYMNT_DT BETWEEN ((RECON_BANK_DT) + ( 0 - 0)) AND
((RECON_BANK_DT) + ( 0))) , STTLMNT_DT_ACTUAL =
...etc.....etc
/
-- Row(s) affected: 0
-- 14:01:34.504 Process 18067 ABENDED at Step FSPRECON.900-SQL.900-ST05(Action SQL) -- RC = 1427
ROLLBACK
/
-- 14:01:34.528 SQL Error: ORA-01427: single-row subquery returns more than one row


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
Cause
Solution
References


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