Load Bank Statement Data Errors with "character To Number Conversion Error" (Doc ID 1514182.1)

Last updated on JUNE 20, 2013

Applies to:

Oracle Cash Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
Load Bank Statement Data - Error - "character to number conversion error"

Problem Description
---------------------------------------------------
While running the "Bank Statement Loader" concurrent program, the last request "Load Bank Statement Data" fails with a conversion error, number to string. It's probably because a number string has bad data, containing a letter, etc, but we're unsure how to troubleshoot. See attached error log.

Error Codes
---------------------------------------------------
ORACLE error 6502 in FDPSTP

 

CEBSLDR module: Load Bank Statement Data
 
ORACLE error 6502 in FDPSTP

Cause:  FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.CE_BANK_STATEMENT_LOADER", line 2876
ORA-06512: at line 1
.




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