My Oracle Support Banner

ORA-01858, ORA-06512 Errors When Running The Interaction History Data Purge Concurrent Program (Doc ID 580536.1)

Last updated on MARCH 09, 2019

Applies to:

Oracle Customer Interaction History - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.


When running the Interaction History Data Purge concurrent program, the following error occurs in the concurrent request log :

The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Request_Id,

-- Steps To Reproduce:

The issue can be reproduced at will with the following steps:
1. Responsibility: Interaction History Data Purge
2. Use the following parameters
Party_ID, Start Date, End Date, Safe Mode=Yes and Active flag='N'

The error above is seen in the log file




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

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