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

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle iStore - Version 11.5.10.2 and later
Information in this document applies to any platform.

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms