Service Request Data Purge Fails With ORA-06502 and character to number conversion error
(Doc ID 2117667.1)
Last updated on FEBRUARY 06, 2022
Applies to:
Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
Service Request Data Purge fails.
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:
(R) Service
(N) View > Requests
- Execute concurrent request: Service Request Data Purge
- Enter concurrent request parameters
- Request completes with error.
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 |