My Oracle Support Banner

Error - when running concurrent Service Request Data Purge - API Error (CS_SR_PURGE_CP.PURGE_SERVICEREQUESTS) (Doc ID 1538240.1)

Last updated on JULY 21, 2020

Applies to:

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

Symptoms

When attempting to purge service requests using Service Request Data Purge program the following error occurs.
  
Error:
API Error (CS_SR_PURGE_CP.PURGE_SERVICEREQUESTS): The Service Request Purge Concurrent Program failed. The error encountered was: ORA-01722: invalid number.
  
Steps To Reproduce:
 
  1. Field Service Administrator > run request > Service Request Data Purge
  2. Params: Not updated since: 3 Months
  3. # of Workers: 4
  4. Purge Batch size: 1000
  5. Non field service tasks: Purge Closed
  6. Maintain Purge Audit: Yes



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.