ECM: TR_BSP_LOAD Process Abends at TR_BSP_LOAD.BK_BAL_I.Step01 When Bank File Has Multiple Bank Accounts For Same Bank ID (Doc ID 2004689.1)

Last updated on SEPTEMBER 15, 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

TR_BSP_LOAD Process fails at step TR_BSP_LOAD.BK_BAL_I.Step01 when Bank Statement file in PSBD1/BAI2 format has multiple Bank Accounts for the same Bank ID.

Steps
-------
1. Load file into the server that contains multiple Bank Accounts for the same Bank ID.
2. Navigate to Banking > Bank Statements > Import Bank Statements and run the process.
3. IMPORT_FILES process goes to success.
4. TR_BSP_LOAD process abends with the following error message.

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

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