Compilation Error for CTXSYS.CS_KB_CTX_PKG And Index Creation Failed After OATM Upgrade (Doc ID 2324355.1)

Last updated on NOVEMBER 02, 2017

Applies to:

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

Symptoms

After upgrading OATM, some indexes fail and the package CTXSYS.CS_KB_CTX_PKG compiles with error:

 

SQL> ALTER INDEX "CS"."CS_KB_ELEMENTS_TL_N2" REBUILD parameters ('replace storage APPS.TXN_IND_STORAGE_PREF');
ALTER INDEX "CS"."CS_KB_ELEMENTS_TL_N2" REBUILD parameters ('replace storage APPS.TXN_IND_STORAGE_PREF')
*
ERROR at line 1:
ORA-01418: specified index does not exist
SQL> ALTER INDEX "CS"."CS_FORUM_MESSAGES_TL_N4" REBUILD parameters ('replace storage APPS.TXN_IND_STORAGE_PREF');
ALTER INDEX "CS"."CS_FORUM_MESSAGES_TL_N4" REBUILD parameters ('replace storage APPS.TXN_IND_STORAGE_PREF')
*
ERROR at line 1:
ORA-01418: specified index does not exist
SQL> ALTER INDEX "CS"."CS_KB_SETS_TL_N3" REBUILD parameters ('replace storage APPS.TXN_IND_STORAGE_PREF');
ALTER INDEX "CS"."CS_KB_SETS_TL_N3" REBUILD parameters ('replace storage APPS.TXN_IND_STORAGE_PREF')
*
ERROR at line 1:
ORA-01418: specified index does not exist

 

LINE/COL ERROR
-------- -----------------------------------------------------------------
279/5    PL/SQL: Statement ignored
279/15   PLS-00313: 'REMOVE_TAGS' not declared in this scope
309/4    PL/SQL: Statement ignored
309/19   PLS-00313: 'REMOVE_TAGS' not declared in this scope
318/9    PL/SQL: Statement ignored
318/19   PLS-00313: 'REMOVE_TAGS_CLOB' not declared in this scope

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