Error In "iStore Search Insert Concurrent Program" Performance. (Doc ID 1293504.1)

Last updated on MAY 10, 2022

Applies to:

Symptoms

When attempting to run the "iStore Search Insert Concurrent Program" the following error occurs:

ERROR
-----------------------
"ORA-00001: unique constraint (IBE.IBE_CT_IMEDIA_SEARCH_U1) violated".


Concurrent Program Log
ORACLE error 1 in FDPSTP

 Cause: FDPSTP failed due to ORA-1: unique constraint
 (IBE.IBE_CT_IMEDIA_SEARCH_U1) violated
 ORA-6512: at "APPS.IBE_SEARCH_SETUP_PVT", line 323
 ORA-6512: at line 1




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Set Profiles Options -
 "IBE: Category Set Filter for Product Search" = null  (blank)
 "IBE: Web Status Filter for Product Search" = All

2) Login as the iStore Concurrent Programs Responsibility - iStore Concurrent Programs -> iStore Search Insert

Changes

Cause

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