2 Replies Latest reply on Feb 19, 2016 3:04 PM by Ariz - Apps DBA

    Rebuild Help Search Index Concurrent Program Failed

    Ramaraju

      Hi,

      The 'Rebuild Help Search Index' concurrent program is failed after upgrade from R11i to R12.2.4. Please help on this issue.

       

      Log File:

      --------------

      +---------------------------------------------------------------------------+

      Application Object Library: Version : 12.2

       

      Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

       

      AFLOBBLD: Rebuild Help Search Index

      +---------------------------------------------------------------------------+

       

      Current system time is 18-FEB-2016 20:46:19

       

      +---------------------------------------------------------------------------+

       

       

      +-----------------------------

      | Starting concurrent program execution...

      +-----------------------------

       

      Arguments

      ------------

      APPLSYS

      APPS

      ------------

       

       

      Concurrent Manager encountered an error while running SQL*Plus for your concurrent request 43788382.

       

      Review your concurrent request log and/or report output file for more detailed information.

       

       

      +---------------------------------------------------------------------------+

      No completion options were requested.

       

      Output file size:

      310

       

       

      Output is not being printed because:

      The print option has been disabled for this report.

       

      +---------------------------------------------------------------------------+

      Concurrent request completed

      Current system time is 18-FEB-2016 20:46:19

       

      +---------------------------------------------------------------------------+

       

      Output File:

      --------------

      declare

      *

      ERROR at line 1:

      ORA-20000: Oracle Text error:

      DRG-10709: this preference is referenced by FND_LOBS_CTX_LEX and cannot be

      dropped

      ORA-06512: at "CTXSYS.DRUE", line 160

      ORA-06512: at "CTXSYS.CTX_DDL", line 40

      ORA-06512: at "CTXSYS.AD_CTX_DDL", line 195

      ORA-06512: at line 56

      ORA-06512: at line 106

       

      Thanks,

      Ramaraju