How To Diagnose ORA-01427 Error When Running Create Settlement Batches For Bank Account Transactions (Doc ID 1524057.1)

Last updated on AUGUST 19, 2024

Applies to:

Goal

When attempting to run Create Settlement Batches for bank account transactions, an ORA-01427 error is seen in the log file:

IBY_FC_CREATE_SETTLE_BATCHES module: Create Settlement Batches
+---------------------------------------------------------------------------+

instr_type: BANKACCOUNT
prog_name: IBY_FC_CREATE_SETTLE_BATCHES
retry_flag: N
Task Parameter: key: P_PAYMENT_SYSTEM_ID, value: <PAYMENT_SYSTEM_ID>
Task Parameter: key: P_INTERNAL_PAYEE_ID, value: <INTERNAL_PAYEE_ID>
Task Parameter: key: P_PAYMENT_CHANNEL_CODE, value: BANK_ACCT_XFER
Task Parameter: key: P_BATCH_NAME, value: 
Task Parameter: key: P_INSTRUMENT_TYPE, value: BANKACCOUNT
Task Parameter: key: P_CONC_PROGRAM_NAME, value: IBY_FC_CREATE_SETTLE_BATCHES
Task Parameter: key: P_FC_EFT_PROFILE_ID_SENTRY, value: X
Task Parameter: key: P_SETTLEMENT_DATE, value: <SETTLEMENT_DATE>
Task Parameter: key: P_RETRY_FLAG, value: N

Processing EFT BATCH CLOSE operations ..

java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
ORA-06512: at "APPS.IBY_FNDCPT_EXTRACT_GEN_PVT", line 449
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 174
ORA-06512: at line 1

.....


IBY_TRANSACTIONEFT_PKG.createBatchCloseTrxnsNew2: validate_open_batch <MBATCHID>

The ORA-01427 error indicates a possible data issue.  How can we diagnose where the data issue lies and fix it?

Solution

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