My Oracle Support Banner

Sitmain Fails With an Error: "update_insert~ITEM_MASTER~-1~ORA-00001: Unique Constraint (.) Violated" (Doc ID 2383227.1)

Last updated on APRIL 16, 2021

Applies to:

Oracle Retail Merchandising System - Version 15.0 and later
Information in this document applies to any platform.


SITMAIN batch fails with unique constraints error when the batch is executed in multi thread mode.


Steps to Reproduce:

  1. Set up a link between an item list containing a single item and a location list containing multiple locations in the Retail Merchandising System(RMS) front end.
  2. Ensure the SITMAIN batch is configured to run 10 threads.
  3. Run all 10 threads together from scheduler.
  4.  Observe that all jobs fail with an error "update_insert~ITEM_MASTER~-1~ORA-00001: unique constraint (.) violated~CLOSE cursor C_ITEM in package NEW_ITEM_LOC_SQL.PERSIST" in multiple threads.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.