My Oracle Support Banner

Unique Constraint Error ORA-00001 Recieve When Adding Child Items (Doc ID 2696371.1)

Last updated on APRIL 16, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

When Creating child getting below error  with some value stored in cache.
Error ORA-00001: unique constraint (RMS01.PK_ITEM_MASTER) violated returned by program unit ITEM_CREATE_SQL.INSERT_ITEM_MASTER.

 

Steps :

 

1) Create a item ( item level 1 tran level 1)

2) Approve the item

3) Try to create child items for above item

4) Error receive on UI

Error ORA-00001: unique constraint (RMS01.PK_ITEM_MASTER) violated returned by program unit ITEM_CREATE_SQL.INSERT_ITEM_MASTER.


 

Cause

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
Symptoms
Cause
Solution
References


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