OATM Errors Out When Moving Intermedia Indexes (Doc ID 365466.1)

Last updated on JANUARY 12, 2016

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:

HR PER_EMPDIR_PEOPLE_N1 INDEX INTERMEDIA
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

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