This discussion is archived
7 Replies Latest reply: Dec 28, 2012 7:11 AM by 981337 RSS

how to identify the unique index constraint violation error

959687 Newbie
Currently Being Moderated
AQ: XOP12083212969:Failed during processing,
check the log. SQLCode: ORA-00001: unique constraint (OPS$CMS.X2_XOP_FAILED_ORDERS)
violatedSYS.ppr_enh_retorders_cb

Above is the error which i am getting in my package, so i want to search in my package, where exactly the problem is, so kindly tell me what are all the ways to identify the exact statement in the package or procedure, its affected..

Legend

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