2 Replies Latest reply: Feb 5, 2013 4:15 PM by Bikki RSS

    Duplicate Item Category

    Bikki
      Hi, when i am trying to pull the data collections. I am getting the following errror. Please help.

      ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
      30-JAN 15:39:13 : ======= Below records violate the unique constraint =======
      30-JAN 15:39:13 : PLAN_ID -1 / SR_INSTANCE_ID 1001 / ORGANIZATION_ID 4 / INVENTORY_ITEM_ID 23333 / NEW_PLAN_ID / SIMULATION_SET_ID


      RDBMS : 11.2.0.3.0
      Oracle Applications : 12.1.3

      So friends, please help me in this issue.

      "How can we fix INVENTORY_ITEM_ID 23333"

      Thanks.