Unable To Delete Multiple SRs When Running The Service Request Data Purge Concurrent Program
(Doc ID 2759875.1)
Last updated on MARCH 17, 2021
Applies to:
Oracle Teleservice - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to purge multiple SR by running concurrent program "Service Request Data Purge" and selecting SR Type, the list of values returns error message below:
Errors
APP-FND-01564: ORACLE error 24345 in fdlget
Cause: fdlget failed due to ORA-24345: A Truncation or null
fetch error occured.
The SQL statement being executed at the time of the error
was: SELECT INCIDENT_TYPE_ID,NAME VALUE, DESCRIPTION
DESCRIPTION, NVL('N','N'), NVL(TO_NUMBER(NULL), -1), NULL
..
..
was executed from the file &ERRFILE.
APP-FND-01564: ORACLE error 24345 in fdlget
Cause: fdlget failed due to ORA-24345: A Truncation or null
fetch error occured.
The SQL statement being executed at the time of the error
was: SELECT INCIDENT_TYPE_ID,NAME VALUE, DESCRIPTION
DESCRIPTION, NVL('N','N'), NVL(TO_NUMBER(NULL), -1), NULL
..
..
was executed from the file &ERRFILE.
Steps
(R) Service
(N) Requests > Run
Service Request Data Purge
Select SR Type
Receive error above.
(R) Service
(N) Requests > Run
Service Request Data Purge
Select SR Type
Receive error above.
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 |