1 Reply Latest reply on May 3, 2013 5:59 PM by Hussein Sawwan-Oracle

    R12 upgrade - ICX_CAT_INTERMEDIA_INDEX_PVT.create_index issue

    user482035
      Hi

      In R12 iprocurement after upgrade from 11i, I am trying to Rebuild Catalog interMedia Index using below sqls.
      SQL> exec ICX_CAT_INTERMEDIA_INDEX_PVT.drop_index;
      SQL> exec ICX_CAT_INTERMEDIA_INDEX_PVT.create_index;

      Drops work fine but create index is giving error as below.

      SQL> exec ICX_CAT_INTERMEDIA_INDEX_PVT.CREATE_INDEX;
      BEGIN ICX_CAT_INTERMEDIA_INDEX_PVT.CREATE_INDEX; END;

      *
      ERROR at line 1:
      ORA-20000: Exception at ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1800):
      ORA-20000: Exception at ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1800):
      ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
      ORA-20000: Oracle Text error:
      DRG-10504: primary key is required when using the DETAIL_DATASTORE
      ORA-06512: at "APPS.ICX_CAT_INTERMEDIA_INDEX_PVT", line 402
      ORA-06512: at line 1

      any inputs.
        • 1. Re: R12 upgrade - ICX_CAT_INTERMEDIA_INDEX_PVT.create_index issue
          Hussein Sawwan-Oracle
          user482035 wrote:
          Hi

          In R12 iprocurement after upgrade from 11i, I am trying to Rebuild Catalog interMedia Index using below sqls.
          SQL> exec ICX_CAT_INTERMEDIA_INDEX_PVT.drop_index;
          SQL> exec ICX_CAT_INTERMEDIA_INDEX_PVT.create_index;

          Drops work fine but create index is giving error as below.

          SQL> exec ICX_CAT_INTERMEDIA_INDEX_PVT.CREATE_INDEX;
          BEGIN ICX_CAT_INTERMEDIA_INDEX_PVT.CREATE_INDEX; END;

          *
          ERROR at line 1:
          ORA-20000: Exception at ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1800):
          ORA-20000: Exception at ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1800):
          ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
          ORA-20000: Oracle Text error:
          DRG-10504: primary key is required when using the DETAIL_DATASTORE
          ORA-06512: at "APPS.ICX_CAT_INTERMEDIA_INDEX_PVT", line 402
          ORA-06512: at line 1

          any inputs.
          Please don't post duplicates -- ICX_CAT_LATEST_BATCH_JOBS_V is invalid after upgrade from 11i to R12