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.

Symptoms

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.

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

OR

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

STEPS

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

Cause

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