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

Last updated on AUGUST 23, 2023

Applies to:

Symptoms

After upgrading the Oracle E-Business Suite Tablespace Model (formerly called the Oracle Applications Tablespace Model, or 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

Changes

Cause

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