JTF: ORA-29874 and ORA-29960 when Running "Synchronize JTF_NOTES_TL_C1 index" Concurrent Request (Doc ID 601335.1)

Last updated on MAY 18, 2016

Applies to:

Oracle Teleservice - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 18-May-2016***
EXECUTABLE:JTF_NOTES_TL_C1_SYNC - Synchronize JTF_NOTES_TL_C1 index


Symptoms

When running 'Synchronize JTF_NOTES_TL_C1 index' concurrent request the following error occurs:

ERROR:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. (R) CRM Administrator
2. (N) Requests
3. Run
4. Choose "Synchronize JTF_NOTES_TL_C1 index" (requests adds standard parameters automatically)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms