Error In "iStore Search Insert Concurrent Program" Performance.

(Doc ID 1293504.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

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


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

"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
 ORA-6512: at "APPS.IBE_SEARCH_SETUP_PVT", line 323
 ORA-6512: at line 1

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


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