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)
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
Million Knowledge Articles and hundreds of Community platforms