My Oracle Support Banner

Store Importer "Delete and Seed" Job Fails With Error 'ORA-02292' When Starter Store Exist (Doc ID 2877943.1)

Last updated on JUNE 22, 2022

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 19.4 and later
Information in this document applies to any platform.


In Enterprise Inventory Cloud Service (EICS), When the starter store record exists in the store table, the "Delete & Seed"option for the Store importer job fails with the error below:

ORA-00001: unique constraint (SIM01.STORE_PK) violated. (Process# in EICS - 891996).

Step To Reproduce:

Prerequisites: Starter Store (ID = 0) record exists in the STORE table.


1. Run Store_Fnd_ProcessFlow_From_RMS and let the store records get imported into the STORE table.
2. Run the Store_Fnd_ProcessFlow_From_RMS again and add a few more stores to the STORE_IN table.
3. Disable Constraints .
4. Job Name - Store and Seed Option: Delete & Seed.
5. Job fails with error above.



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.