OATM Errors Out When Moving Intermedia Indexes
(Doc ID 365466.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Application Object Library - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]Information in this document applies to any platform.
Symptoms
Sometimes OATM migration fails with errors like:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX PER_EMPDIR_PEOPLE_N1 failed
ORA-06508: PL/SQL: could not find program unit being called
This could happen to any of the intermedia indexes in Oracle Application 11i :
Owner Index Name
-------- --------------------------
AR HZ_STAGE_CPT_T1
HZ_STAGE_CONTACT_T1
HZ_STAGE_PARTIES_T1
HZ_CLASS_CODE_DENORM_T1
HZ_STAGE_PARTY_SITES_T1
HZ_CUST_ACCT_SITES_ALL_T1
CS CS_KB_SETS_TL_N3
SUMMARY_CTX_INDEX
CS_KB_ELEMENTS_TL_N2
CS_KB_SOLN_CAT_TL_N1
CS_FORUM_MESSAGES_TL_N4
HR HR_LOCATIONS_N1
PER_ADDRESSES_N4
IRC_DOCUMENTS_CTX
IRC_DOCUMENTS_CTX1
PER_EMPDIR_PEOPLE_N1
IRC_POSTING_CON_TL_CTX
IRC_SEARCH_CRITERIA_CTX
PA PA_PROJECT_CTX_SEARCH_C1
AMV AMV_C_CHANNELS_DESC_CTX
AMV_C_CHANNELS_NAME_CTX
ENI ENI_DEN_HRCHY_PAR_IM1
IBC IBC_ATTRIBUTE_BUNDLES_CTX
ICX ICX_QUES_CTX
ICX_CAT_ITEMS_CTX_DESC
JTF JTF_TASKS_TL_IM
JTF_AMV_ITEMS_URL_CTX
JTF_AMV_ITEMS_DESC_CTX
JTF_AMV_ITEMS_NAME_CTX
JTF_AMV_ITEMS_TEXT_CTX
OKC OKC_ARTICLES_CTX
OKC_TERMS_TEMPLATES_CTX
OKR OKR_IPS_TL_N1
APPS IBE_CT_IMEDIA_SEARCH_IM
APPLSYS FND_LOBS_CTX
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 |
| Cause |
| Solution |
| References |