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.

Symptoms

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:

ERROR:
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.

 

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.