Belgium Localization : CLE Load Bank Statement Data(1) failing with error "ORA-01422: exact fetch returns more than requested number of rows" (Doc ID 2546576.1)

Last updated on MARCH 13, 2023

Applies to:

Symptoms

 Reported Issue
 -----------------
 CLE: Load Bank Statement Data(1) running into error if same bank account is used for future end dates.

 Error message
 ----------------
 Error 1 :
 **Starts**09-NOV-2018 05:47:57
 **SQL error and free**09-NOV-2018 05:49:13
 ORACLE error 1422 in FDPSTP

 Cause: FDPSTP failed due to ORA-01422: exact fetch returns more than requested number of rows
 ORA-06512: at "APPS.CLEF081_BANK_STATEMENT_LOADER", line 4462
 ORA-06512: at line 1
 
 Error 2 
 Value of gc_hdr_currency_code CLEF081_BANK_STATEMENT_LOADER.insert_line at line-1261 is: CHF
 Exception occured in CLEF081_BANK_STATEMENT_LOADER.insert_line at line-1381 is: ORA-01422: exact fetch returns more than requested number of rows
 Exception occured in CE_BANK_STATEMENT_LOADER.load_others_coda128 at line-3542 : -1422
 Exception occured in CE_BANK_STATEMENT_LOADER.load_others_coda128 at line-3543 : ORA-01422: exact fetch returns more than requested number of rows
 In when others exception in CLEF081_BANK_STATEMENT_LOADER.load_bank_statement line-4174: ORA-01422: exact fetch returns more than requested number of rows

Steps for replication
----------------------
1. Create 2 bank accounts with a number . Lets consider '220-0866777-21', as an example. 
   This is for currency code 'EUR'.
3. Run the CLE: Bank statement loader and verify CLE: Bank Statement Load data program
3.The program is ending in error with too many rows exception
 
 Expected Behavior
 --------------------
 Expects that concurrent / report should be completed normal.

Changes

Cause

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