1 2 Previous Next 16 Replies Latest reply: Sep 24, 2012 8:40 AM by 860213 RSS

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

    user437657
      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