R12: Content Manager : Text Index Synchronization Completed With ORA-29855 Error (Doc ID 1484551.1)

Last updated on JUNE 22, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Merchant UI

When attempting to run Content Manager : Text Index Synchronization concurrent program
the following error occurs.

ERROR
-----------------------
Content Manager: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

IBC_CONTENT_SYNC_TEXT_INDEX module: Content Manager : Text Index Synchronization
+---------------------------------------------------------------------------+

Current system time is 12-JUL-2012 06:38:12

+---------------------------------------------------------------------------+

**Starts**12-JUL-2012 06:38:12
**Ends**12-JUL-2012 06:38:12
Sync_Text_Index: IBC_CITEM_VERSIONS_TL_CT1 :IBC_UNEXPECTED_ERROR ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10507: duplicate index name: IBC_CITEM_VERSIONS_TL_CT1
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Sync_Text_Index: IBC_CITEM_VERSIONS_TL_CT1 :IBC_UNEXPECTED_ERROR ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10507: duplicate index name: IBC_CITEM_VERSIONS_TL_CT1
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+--------------------------------------------------------------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Content Manager : Text Index Synchronization concurrent program

Changes

 

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