ECM: Import Bank Statement errors with -- ORA-01427: single-row subquery returns more than one row -- at Step TR_BSP_LOAD.BK_BAL_U.Step05 (SQL)

(Doc ID 2033336.1)

Last updated on MARCH 17, 2016

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Import Bank Statement abends at Step TR_BSP_LOAD.BK_BAL_U.Step05 and/or Step TR_BSP_LOAD.BK_BAL_U.Step06 with an error.

Process ABENDED at Step TR_BSP_LOAD.BK_BAL_U.Step05 (SQL) -- RC = 1427


Process ABENDED at Step TR_BSP_LOAD.BK_BAL_U.Step06 (Action SQL) -- RC = 1427

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


1.  Ensure that there are multiple Banks with the same Bank ID and multiple Bank Accounts with the same Account Number in the system

2.  Run Import Bank Statement to load a BAI2 bank statement file


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms