This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Sep 24, 2012 6:40 AM by 860213 RSS

OATM fail for APPLSYS FND_LOBS_CTX  - ORA-01418: specified index does not e

user437657 Newbie
Currently Being Moderated
Hi,

I am in the process of doing OATM before r12 upgrade, but it failed on the following. I am struggling for the last several days. I followed some oracle note to fix but did not fix.
I spend hours and hours for creating the index by running one sql script aflobbld.sql under $FND_TOP/bin which took a lot of trime, failed couple of time for space and finally the script successfully completed. I thought that all problems are solved after that but when I ran the OATM migration got the following error.

Migration Error Report

Report Date : September 19, 2012
Object Object SubObject
Schema name type type
------- ------------------------------ ---------- -------------
Migration Error
------------------------------------------------------------------------------------------------------------------------------------
APPLSYS FND_LOBS_CTX INDEX INTERMEDIA
ORA-01418: specified index does not exist


When I checked the status of the index showing INPROGRS :

SQL> SELECT STATUS FROM DBA_INDEXES WHERE INDEX_NAME LIKE '%LOBS_CTX%';

STATUS
--------
INPROGRS
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points