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:
Oracle Teleservice - Version 11.5.10.2 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |