My Oracle Support Banner

Error ORA-06502: PL/SQL: numeric or value error in Central European Bank Statement Loader Program (Doc ID 2794339.1)

Last updated on JUNE 12, 2023

Applies to:

EMEA Add-on Localizations - Version 12.1.1 and later
Information in this document applies to any platform.


Problem statement
Bank Statement Upload (CLE: Central European Bank Statement Loader) fails with error if bank account balance in the statement is negative due to overdraft.

Error message
ORA-06502: PL/SQL: numeric or value error: character to number conversion error.

Steps to replicate
The issue can be reproduced at will with the following steps:
1. Cash Management Superuser responsibility for Czech Republic
2. Go to View > Requests > Submit a New Request.
3. Run the CLE: Central European Bank Statement Loader program.
4. Notice that the program failed with error.

Expected behavior
Expectation is such that the bank statement upload program should be completed successfully.


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

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