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 JUNE 12, 2023
Applies to:
EMEA Add-on Localizations - Version 12.1.1 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |