My Oracle Support Banner

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 later
Information 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.




Steps
(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


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