My Oracle Support Banner

Numeric or value error while executing Service Request Data Purge concurrent program when the Numeric format is set to 10.000,00 (European number-format) (Doc ID 2220885.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to execute the Service Request Data Purge concurrent program when the Numeric format is set to 10.000,00 (European number-format), the following error occurs:

ERROR
-----------------------
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 line 1
The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Reque"


STEPS
-----------------------
1. In Preferences set the numeric format to 10.000,00 (European number-format)
2. Execute the Service Request Data Purge concurrent program
3. The reported error occurs.
4. If the numeric format is set to 10,000.00 (US number-format), then no error occurs


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


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