This discussion is archived
2 Replies Latest reply: Feb 5, 2013 2:15 PM by Bikki RSS

Duplicate Item Category

Bikki Newbie
Currently Being Moderated
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.

Legend

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